Thread: importing data from one excel spreadsheet to another using macros

I have an excel 2007 doc that has financial information in it.
I need to take this sheet, along with several hundrend other sheets with similar information on them and import each one into a master spreadsheet with different formatting (colors, font sizes, etc). :]

I have pictures of the finished product for last year, but I need to pretty much reverse engineer it so that I can redo it for this year.


I have picture attached.

on the 3d picture there is the top of the screen highlighted...this is part of split thing where when you scroll down, the top of the page doesnt scroll, but the rest of the sheet does scroll.

I don't have pictures of the original data sheets used to compile this master sheet, but if I can get a hold of them then I will add them.


If you can help me out, I can send you the actual excel doc from the pictures via email or something, but It is too big to post on here.

if you need more info about my situation, email me at ryan.burtch@yahoo.com



thank you,
Ryan

Hello Ryan,

Welcome to the Forum!

Nice pictures, but not very helpful in solving your problem. This sounds like a major project, not one that can be answered quickly and simply in this forum. If you are under a deadline, which I suspect you are this time of the year, you have my sympathies. Before anyone can begin to provide you with answers or realistic time frames for completion, you have to provide a workbook. I know there is probably sensitive data in the workbook. You will have to either change the names or delete them before posting the workbook here on the forum. If you can't do this, you should consider posting this request in our Commercial Services forum. Someone may take this challenge on for a fee of course.

Sincerely,
Leith Ross