[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 77
  • 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)AstronautCommented:
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 BurtonDirector, Practice Manager and Computing ConsultantCommented:
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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

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