elkerpride
New Member
- Joined
- Nov 29, 2023
- Messages
- 7
- Office Version
- 365
Hello -
I have a column in a spreadsheet I need to paste onto another spreadsheet. The 2nd sheet is filtered, and I only need to paste on the showing/visible cells.
In the below example, I filter the destination (Bottom) sheet to only show one account number each name, the remaining 3 for each is hidden. I need to past the color column from origin (top) sheet into a column on the filtered sheet.
Can this be done?
Thanks!
I have a column in a spreadsheet I need to paste onto another spreadsheet. The 2nd sheet is filtered, and I only need to paste on the showing/visible cells.
In the below example, I filter the destination (Bottom) sheet to only show one account number each name, the remaining 3 for each is hidden. I need to past the color column from origin (top) sheet into a column on the filtered sheet.
Can this be done?
Thanks!
account number | Name | Color |
1234 | Name 1 | Blue |
4567 | Name 2 | Green |
7890 | Name 3 | Red |
1475 | Name 4 | Yellow |
account number | Name | |
1234 | Name 1 | |
1234 | Name 1 | |
1234 | Name 1 | |
1234 | Name 1 | |
4567 | Name 2 | |
4567 | Name 2 | |
4567 | Name 2 | |
4567 | Name 2 | |
7890 | Name 3 | |
7890 | Name 3 | |
7890 | Name 3 | |
7890 | Name 3 | |
1475 | Name 4 | |
1475 | Name 4 | |
1475 | Name 4 | |
1475 | Name 4 |