Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 74
  • Last Modified:

Amend existing consolidate sheets macro to create new sheet and include date in new column

The attached file contains a macro that consolidates all worksheets into the Sheet1. But it deletes the contents of Sheet1.
I am seeking to have it amended so that a new sheet (SheetA) is created for the consolidated sheets, and also to have the date from G2 in Sheet 1 to be included in each row containing content under column G in the new SheetA.

Hope this makes sense.
2014-08-23-melbourne.xlsx
0
gregfthompson
Asked:
gregfthompson
1 Solution
 
Wayne Taylor (webtubbs)Commented:
The attached file doesn't contain any macro's. A Macro enabled workbook will have a .xlsm file extension.
0
 
gregfthompsonAuthor Commented:
Sorry. Attached wrong file.
2014-08-23-melbourne.xlsm
0
 
Phillip BurtonCommented:
Please find attached. I have highlighted the new and altered lines with comments at the end.

I have used cell H1 of Sheet1 instead of G2, as that appears to be where the date is located.
2014-08-23-melbourne2.xlsm
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now