I have attached a WS to show what I am asking for.
I have 11 Worksheets. I want WS1 to be the main sheet where data is entered.
WS2-WS11 is where the data will populate.
When I enter data on WS1 I want it to populate in the corresponding WS2-11 based on text entered in a colummn in WS1.
As I continue to enter data on WS1, I want it to fill the rows in order on the corresponding Worksheets.
Please see attached.
Bookmarks