Copy a data from one sheet to another

roberttripoli Posts 2 Registration date Wednesday December 21, 2022 Status Member Last seen December 22, 2022 - Dec 21, 2022 at 04:19 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Dec 27, 2022 at 11:23 AM

I have a Master list (Sheet 1) that contains house numbers and personnel assigned to them. I want to copy the entire row with the data assigned to each person on a different sheet and automatically updates each time the master list is updated.

Additional information:

personnel names starts at N13

Unit numbers starts at B13

Columns in between are dates and concerns for each unit

1 reply

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Dec 22, 2022 at 11:40 AM

Hi Robert,

Your query is a little confusing to me.

You have a sheet named "Master" with names in column N (starting at row 13).
You have additional sheets, which are named after the values (names) found in column N from the "Master" sheet?

1) Now you want to copy any new entry made in the "Master" sheet to the additional sheets as well?
2) Or the other way around: a new entry from any of the additional sheets to the "Master" sheet?

Wether it's option 1 or 2 (or something I didn't expect), when would you like this action to occur?
This could be by entering a value at a certain column (the last value you enter for that row), or maybe you prefer a separate window to enter all data for both sheets at once, or something else?

Best regards,
Trowa
 


0
roberttripoli Posts 2 Registration date Wednesday December 21, 2022 Status Member Last seen December 22, 2022
Dec 22, 2022 at 07:52 PM

The rows look like this I want to copy the row that is assigned to different personnel to different sheet and have all stick to top.
Basically, I just want to filter the rows that contain the name of the personnel to a different sheet of the same work book and have it auto-update each time there is added data in the master list.

0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544 > roberttripoli Posts 2 Registration date Wednesday December 21, 2022 Status Member Last seen December 22, 2022
Dec 27, 2022 at 11:23 AM

Hi Robert,

You aren't very specific: You have 13 columns of data (A:M), so column N is empty. What is the name of the "different sheet", is it just one sheet?

Your query sound similair to this one:
https://ccm.net/forum/affich-850855-copy-a-row-from-one-worksheet-to-another-based-on-criteria#answers
Could you have a look and see if it is applicable?

We can always tweak it to your liking.

Best regards,
Trowa

0