Hi,
I have 4 different excel documents with the same set up. I want to have a master sheet on each document that extracts the data from theses sheets to create a summary sheet.
So for example. i need to extract the persons name, which is always on call B4. then the avearage that is based on data in cell C52. Then the number of assessements which is bacsed on data in C54.
is there a macro to do this or do i have to just do it manually by going in Cell A1 "=Sheet1!B4" then in cell B2 "=Sheet2!B4" etc.
bearing in mind there are roughly 150 people whos data i need to summarize.
Is there a quicker/easier way to reference the values?
Thanks.
Bookmarks