troubleshooting Question

Excel 2007 Macro to consolidate data into single sheet

Avatar of andreyman3d2k
andreyman3d2k asked on
ProgrammingMicrosoft ExcelVB Script
8 Comments1 Solution632 ViewsLast Modified:
Hi -- I asked this question a few days ago and only got a partial response. I think it's because I made the question sound more complicated than it is.

I am trying to pull the data from all the sheets in a workbook into a single summary sheet. Block pasted one under the other.

1 caveat:

I would like to have the name of the spreadsheet from which the record came in front of each record in the resulting workbook (i.e. in column A) So if record "Apple | 7 | tasty | red" came from sheet "Bob Smith", the resulting record should be: Bob Smith | Apple | 7 | tasty | red

I would be very grateful for any help with this. Kind of a rush!

Thank you!

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros