Identify data in monthly sheets in WB and consolidate into master sheet

R

Royzer

I have an application that will generate a report each month and expor
it to Excel. The problem is that there are no options to change th
layout of the export and I need to get some of the information into
different format to be reviewed by the "higher-ups". The exported dat
each month will go to a new worksheet (but in the same workbook) an
each month's sheet will have over 2,000 rows, so the idea of manuall
transferring this information is overwhelming (and for all practica
purposes, impossible).

I've attached a workbook. Thank you for taking the time to look at it

+-------------------------------------------------------------------
|Filename: MSO test.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=482
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top