nyconfidential
New Member
- Joined
- Jul 22, 2015
- Messages
- 49
- Office Version
- 365
- 2016
Hi all - I have a user who pastes an entire row of values from a csv into an xlsx file. This was fine initially, but there are now a few columns we DON'T want to paste data into (ex - we copy a row from the CSV that does from column A to Z, we want to paste the data into every column in the xlsx except for column, D, E and F).
I guess my question is - Is there a way to specify which columns to paste after the entire range has been copied to the clipboard? Example - paste columns A-C, don't paste D-F, paste E-Z. I know could use that "Union" function when copying but I'd rather not have to convert the csv into an xlsx -trying to keep this as simple as possible for the user. Thanks in advance...
I guess my question is - Is there a way to specify which columns to paste after the entire range has been copied to the clipboard? Example - paste columns A-C, don't paste D-F, paste E-Z. I know could use that "Union" function when copying but I'd rather not have to convert the csv into an xlsx -trying to keep this as simple as possible for the user. Thanks in advance...