Hello,
Recently had some fantastic help from this community, so thanks all. I love excel, but at times we all get a bit stuck.
I have a sheet where I'm working on right first time.
This is my master data tab, where column B is calculating a number of entries from a column on each individuals tab:
Now what i want to auto populate is this:
I want row k of my 'master data' tab to auto collect entries matching that of the entry in column J.......... from column B on all of the tabs as a total.
Recently had some fantastic help from this community, so thanks all. I love excel, but at times we all get a bit stuck.
I have a sheet where I'm working on right first time.
This is my master data tab, where column B is calculating a number of entries from a column on each individuals tab:
Now what i want to auto populate is this:
I want row k of my 'master data' tab to auto collect entries matching that of the entry in column J.......... from column B on all of the tabs as a total.