sh0ckwav3s
New Member
- Joined
- Jun 27, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Morning all, new user here with extremely basic knowledge on all this as only just started using them.
ive created s spreadsheet to copy data from a from 2 columns, and then paste it into another worksheet.
Ive got it setup atm so it copies the data, then creates 2 empty columns to the left of the data ready for the next data to be copied over, so the data goes in order from right to left.
What i would like is for the data to go from left to right, but i cant figure out how to make the macro put the data into the next available column on the right without overwriting the original data.
Sorry if this doesnt make sense, like i said, i am only just getting into it to help make my job slightly easier & quicker
quick screenshots of my basic code, plus an example of it, so week 26 is after test2, but i would like it going test2, test1, then week 26, if its possible
Cheers for any responses![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
ive created s spreadsheet to copy data from a from 2 columns, and then paste it into another worksheet.
Ive got it setup atm so it copies the data, then creates 2 empty columns to the left of the data ready for the next data to be copied over, so the data goes in order from right to left.
What i would like is for the data to go from left to right, but i cant figure out how to make the macro put the data into the next available column on the right without overwriting the original data.
Sorry if this doesnt make sense, like i said, i am only just getting into it to help make my job slightly easier & quicker
quick screenshots of my basic code, plus an example of it, so week 26 is after test2, but i would like it going test2, test1, then week 26, if its possible
Cheers for any responses