Hello,
In my application I have Sales table with transactionID, date, manager, item and amount.
And I have a separate table with manager and item and budget amount as input field to allow user create budget in the application directly.
I need to copy sum of sales amount by manager and item for particular date to my budgeting table. For example, we need to create a budget for the next month that is 10% more than our current sales.
Is it possible to make a macro that will loop through our sales data aggregated by manager and item for particular date and to copy values into input field?
The main questions are:
1. how to make a loop
2. how to find an offset for "SetInputFieldValue" function for particular combination of manager and item?
Kind regards,
Alexander