VBA-Macro-Loop Creation for Inventory Management System
i need help with creating a macro-loop-etc that helps reconcile two different spreadsheets...one with Revenue and one with Expenses.
The hard part is to figure out how to merge once a week updated revenue info into the expenses spreadsheet with the following requirements.
The inventory is different types of tickets. Tickets are expensed at different quantities and sold at different quantities, some not sold at all. The shared fields that we merge on are 1-DATE AND 2-VENUE. They both must be fulfilled.
The revenue is different types of tickets, in different order quantities.
Need to find some code for a loop that takes a sale with its corresponding revenue and quantity, and creates a system whereby one row equals one ticket...whereby multiple rows are created if the quantity is greater than one. Hence the loop.
Can send powerpoint for more info