Populate Data

Closed
meritm19 Posts 2 Registration date Monday 29 January 2018 Status Member Last seen 31 January 2018 - 29 Jan 2018 à 12:25
 Blocked Profile - 31 Jan 2018 à 16:39
I need to auto-populate data from a master worksheet into multiple worksheets, while having the ability to add/delete rows in the master worksheet. These new added rows will have to also appear in the other worksheets. I was able to auto-populate the current data that I have in the master worksheet, but I am having trouble when I add a new row.

Footnote: I have columns A-T filled with data (with headers), and multiple different projects within the master worksheet. Each specific project is then individualized in different worksheets.

I want to be able to update all the worksheets from the master whenever I enter new rows or delete rows under each project.

You help in this matter will be greatly appreciated! Thanks in advance!
Related:

1 response

Blocked Profile
29 Jan 2018 à 16:17
I think this article is right up your alley!

Take a read and let us know if you get stuck!

https://ccm.net/faq/54862-how-to-copy-data-from-one-excel-sheet-to-another-using-a-formula
meritm19 Posts 2 Registration date Monday 29 January 2018 Status Member Last seen 31 January 2018
31 Jan 2018 à 09:38
Thanks for your help. I got stuck doing the user form/sheet controller and all the codes. I thought there'd be a simpler way of doing this :\
Blocked Profile
31 Jan 2018 à 16:39
Nope. No easy way.

You can dummy it down, and start with just cutting and pasting the whole row!

The real answer is, build a DATABASE. Build an entry form to enter in the data, and manipulate records that you wish to alter. Then REPORT on the data in whatever format you wish.

THAT is the EASIEST way to do what you are asking. Use a DB!