I have a raw financial data set that comes out with values staggered in multiple columns (Eg, the categories "revenue", "profit," etc. come out indented, so some are in Col A, B, C, D, etc.). I want to do a summary page that links these categories to the corresponding financials (these columns are aligned by date, ie, all July financials are in Column J).
What is the best way to do a lookup given the formatting issue across multiple columns?
Can you upload a sanitized sample file showing what you're trying to accomplish?
The file is attached. Thanks
Financial Dashboard.xlsx
Can't you just reorganize the layout on the Current worksheet and remove the blanks between the title and the data?
No, its an output that comes out that way monthly and need to automate the process
Are you going to be summing multiple lines of data or is the idea just to line up the values in columns 1-8?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks