How can I set the output formula, to get output data always in the same worksheet, but each run output saves in a new tab with the running date (mm-dd-yyyy) and time?
@Shaopingfu By *in the same worksheet* you actuall mean the new Workbook? Right?
Yes, workbook
@Shaopingfu We can use the DateTimeNow() Function to get the current DateTIme then you can convert it to the format you want.And we can use the DateTime now to compose a FullPath of output workbook and use the Date Time now as variable of Tab Name.
Below is a quick sample. Hope it helps.
This is exactly what I want. Thank you very much.
