Creating 1 master sheet from data from multiple sheets

[Closed]
Report
Posts
1
Registration date
Saturday April 29, 2017
Status
Member
Last seen
April 29, 2017
-
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
-
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

1 reply

Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
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.