I have a work book that has multiple sheets by month. The base sheet has all available (just) names contained on each sheet without amounts next to them. Not all sheets (months) contain all names so my vlookup does not work.
if sheet Jan has:
cell a1 = x
cell b1 = 1
sheet Feb may have:
cell a1 =y
cell b2 = 2
sheet Mar may have:
cell a1 =x
cell b1 = 1
cell a2 = y
cell b2 = 2
What I need is to add up all totals on the base sheet from each sheet for like names for all sheets.
Bookmarks