Hi
Hoping there is a way to do this.
I have 6 sheets, 1 for each surveyor to input information from a report - forming a list of surveys they have attended with findings - each sheet has the same format/setup.
I then have a master sheet where I ideally would like to pull the lists from each surveyor sheet so I have the full list.
Im not sure that consolidate is the right thing any help would be gratefully received,
Thanks
Kat
Bookmarks