Hi,
I hope this post makes enough sense to get the right help.
I am fairly new to excel and am a little confused about how to go about dealing with this but I would like to import data between sheets based on the 'Net Comms' and the 'Trade Date'.
I would like to have the 'Net Comms' allocated to the correct 'Account Name' and date based on the 'Trade Date'.
The months are split into the 4/5 weeks in that month so that is what the "1, 2, 3, 4, 5" mean.
I have added an example within the attachment of what I am trying to achieve.
Thanks for any help provided!
Commission Tracker.xlsx
Bookmarks