Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help combining multiple different reports.
Hello.
I have been looking at these reports for a week now and I only get frustrated. There are 4 quarters of information (detail and summary) each on a different spreadsheet and data from multiple locations. The problem is that every reports is slightly different. There is a lot of information that is not supposed to be included, but is on the reports mixed in. The reports are very disorganized. It looks like all the information was created manually. Whoever created this report/template, in my opinion, was not thinking for the end result. I have no idea where to start. I have to have this done by Thursday and I am assuming there are going to be late nights. If it helps, a simple vlookup so far has not helped my problem. There are incorrect spellings, information on one sheet might not be one the other, etc. Simple put, a mess. Does anyone have suggestions for where to start? Should I just redo the entire report (which may take a very large amount of time and might not be able to be completed before Thursday)? I greatly appreciate any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining two reports into one | Excel Worksheet Functions | |||
How to create reports based on data residing in multiple workbooks | Excel Discussion (Misc queries) | |||
How do I merge multiple quicken reports into one workbook? | Excel Discussion (Misc queries) | |||
Creating multiple reports from a database | Excel Discussion (Misc queries) | |||
Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions |