Auto-populating data from one worksheet to another

[cpeske]

First time poster; I'm admittedly a VBA newbie.

I have a large database in an Excel worksheet. I would like to have all of the data from a row auto-populated into the row of another worksheet tab when I assign it a new label.

Currently I am filtering all of my data and then copy/pasting it into the differnt tabs manually (12 different tabs). This takes a lot of time, and it would be more efficient/valuable to me if it was in real time.

For example, I have column A in worksheet 1 ("Database") blank. When I update column A with new data text (i.e. "Stars") I'd like to take all of the data from the whole row and import it into a row in the "Starts" worksheet tab. If I type in "Monkey" in column A of the database tab, I'd like the data in the row to autopopulate into the "Monkey" tab... and so on and so forth.

There could be 24+ rows worth of data in each worksheet, so it would be great if they autopopulated sequentially. However, if each new row in "Stars" needs to be unique in order to fit into the proper sheet/row to work (i.e. Stars1, Stars2, Stars3, etc.), that'd be fine too.

Lastly, I'd prefer it to run in realtime, but if not, a "RUN" button would work aswell... whatever is easier.

Thank you so much for any help you can provide.

[JBeaucaire]

In situations like this, I like to think of the other sheets as "reports" and all the data in the master worksheet is always the most current and accurate.

Having it "realtime" is an issue. At what moment when you're typing in a row should the data copy? I really think a macro is the way to go, but one that fires to update the other sheets at a specific moment. Manually gives you the most control, but there are other ways to trigger it at a specific moment without it being manual.

============
I have a macro that may be "ready to use" for parsing rows of data from one sheet to many sheets named for the same values.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing.

That macro can go into a regular module.

==========
Then, to automate this, just add this macro to the MASTER sheet module so that anytime you leave the Master sheet, it updates all the other sheets:

Please Login or Register  to view this content.