Copy a data from one sheet to another
ClosedTrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 27, 2022 at 11:23 AM
- Copy a data from one sheet to another
- Transfer data from one excel worksheet to another automatically - Guide
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
- Tmobile data check - Guide
- How to screenshot excel sheet - Guide
1 response
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
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.
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