End Goal = Populate 2019 Plan Tab with values (Get location's budget value from Budget Tab and put it in the corresponding Period based on Schedule Tab & Calendar Tab)
Macro =
a) Find Location from 2019 Tab in Schedule Tab
b) Get date from Column B on Schedule Tab
c) Search date in Column A on Calendar Tab
d) Get Period from Column B on Calendar Tab
e) Search location from Column A in Schedule Tab
f) Paste value in corresponding period based on result from d)
Notes:
- Each location will essentially 4 dates in the Schedule Tab, see location AD & AF for an example (in real life there will be 13 periods in total but all the columns from the schedule remain the same)
I tried a couple of excel formulas but because the locations are across multiple columns and in more than 1 cell, the lookup returns an error or it returns just the first indication.
Bookmarks