I need a macro created that merges sales revenue and advertising cost data from two separate Excel spreadsheets and creates one spreadsheet with net revenue calculations.
The macro will be used to merge data from two spreadsheets:
1) an Excel spreadsheet that contains sales revenue data from my CRM
2) an Excel spreadsheet that contains advertising cost data from my advertising account (Google Adwords)
I would like the macro to be able to produce the following output:
- net revenue per ad
- net revenue per website placement
I can provide bidders with additional info on the spreadsheets (e.g. column headers), if necessary.