troubleshooting Question

How can I consolidate information from multiple worksheets

Avatar of Michael Spellman
Michael SpellmanFlag for United States of America asked on
Microsoft Excel
2 Comments1 Solution277 ViewsLast Modified:
I have a workbook that contains a worksheet for each of my Telephone closets.  I want to consolidate (copy) the populated rows (Column E) from the data sheets to my consolidated worksheet.  For each Data worksheet, I want to populate each row with the closet Rm# (A2) and ClosetID (A3), then if the row contains data in column E, copy column D & column E for that row to the next available row on the cosolidation worksheet.  Repeating this for each Data worksheet.  There is a "Summary" worksheet that just counts the populated rows for each worksheet - (this sheet should not be included in the consolidation).

Example file is attached.  I would like to be able to follow the logic of the steps as a learning tool  so comments explaining thesteps in the routine would be greatly appreciated.  I'll give max points for a clearly explained process.  I hope to be able to learn the approach so I can use similar processes myself in the future.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
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 2 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