Solved

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

Posted on 2014-11-17
4
65 Views
Last Modified: 2014-11-20
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
Comment
Question by:gregfthompson
4 Comments
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
Comment Utility
The attached file doesn't contain any macro's. A Macro enabled workbook will have a .xlsm file extension.
0
 

Author Comment

by:gregfthompson
Comment Utility
Sorry. Attached wrong file.
2014-08-23-melbourne.xlsm
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now