Creating 1 master sheet from data from multiple sheets

Closed
ExcelNoNothing Posts 1 Registration date Saturday April 29, 2017 Status Member Last seen April 29, 2017 - Updated on Apr 29, 2017 at 01:32 AM
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - Apr 29, 2017 at 07:36 AM
Hello,

So I am at a complete loss on how to solve my problem. I'm brand new to excel and any help would be much appreciated.

What I'm wanting to do is create a single master sheet from data entered on other sheets.

The format of each sheet is identical, the sheet names are different per agent they pertain to, and the name section is different per agent, but otherwise everything else is identical.

I'm also hoping to keep the formatting the same in the master document.

I'm hoping someone can help me figure out how to get a Master sheet that will automatically update when information is updated in other sheets.

I want one master sheet showing the combined entries from every agent.

Hope someone can help me :-D

Thanks
Related:

1 reply

vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
Apr 29, 2017 at 07:36 AM
Hello ExcelNoNothing,

I'm trying to picture how your work book is set up. From your explanation, I'm assuming:-

- You have a worksheet named after each Agent.
- The Agent's name is in a particular cell (e.g. cell A1) in each sheet.
- Row 2(?) has headings.
- Your data starts in row 3(?).
- Once data is updated in any row of any individual sheet, you would like that row of data transferred to a Master sheet.

This can be done using VBA coding however:-

- What criteria (such as "Yes", "Completed", "Done and Dusted" etc.) do you wish to use to activate the code that will do the transferring?
- In which column will the criteria be placed?

Please let us know.

Cheerio,
vcoolio.
0