Hallo!I am an accountant. Every month I am required to come up with a report that compares budget sales with actual sales.
The budget sales are in an excel worksheet while actual sales are in an Oracle database which I export to excel worksheet.
My problem is to come up with a merged document that has both budget and actual sales for each product.The arrangement of rows in the budget worksheet and actual sales worksheet are not compatible thus a simple sort cannot work.
Please look at the attached Excel document called ‘Scenario Data’ to undersand my problem.
As you can see from the document the ordering of rows in the Budget and Actual worksheets are not similar.
Is there an excel feature e.g marcos,merge function that I can use so that I can automate the production of the final report as shown in the Merged worksheet such that ordering of rows of budget and actual sales are compatible?
Thanks.
Bookmarks