Excel 2007 : automatically enter data into master sheet from other sheets

**littledragon20x** · 05-10-2010, 02:20 PM

I have about 7 sheets with employee names. I would like any data entered into these sheets to also be automatically entered into a new row in a master sheet that would contain the same thing, just that it would have everyone's data in one sheet. All sheets including the master sheet have the same amount of columns with their headings, same headings. And any further changes to the existing data will also be reflected in the master sheet as well..hopefully I make enough sense so that someone can help me...please ASAP

**royUK** · 05-10-2010, 02:21 PM

You don't need individual sheets,you can store all data in one then use AutoFilter to view specific data

**littledragon20x** · 05-10-2010, 02:23 PM

Originally Posted by royUK

You don't need individual sheets,you can store all data in one then use AutoFilter to view specific data

can you please elaborate a bit more on what you said? and how would I go about that process? step by step..sorry I'm fairly new to excel..thanx

**royUK** · 05-10-2010, 02:43 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Mike MN** · 11-01-2012, 01:40 PM

I believe the scenario is: You have multiple worksheets and want data entered into the rows on the seperate sheets to feed to a master spreadsheet? Same formats, column headings, rows, etc. The master would need an auto-update every time a new row was created or existing data modified on the other worksheets. Do you still need a dummy workbook to answer that? It is simply taking data entered into a row on one sheet and moving it to a different one (would have to be to an empty row to not overwrite existing rows on the master)

Thanks!