mlamew66
New member
- Joined
- Apr 22, 2019
- Messages
- 9
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2003
I am trying to copy and paste cells from one sheet to antoher (withn the same workbook), the cells I am copying are being pasted in a different sheet but not in the same solumn set up
copy from - copy to
sheet1 a1- Sheet2 a1
Sheet1 b1- Sheet2 b1
Sheet1 c1- Sheet2 e1
Sheet1 e1- Sheet2 h1
Sheet1 f1-Sheet2 i1
When I click on the first cell where I am pasting in sheet2 I type =sheet1 a1. I can then copy the adjacent cell (b and c - down as many rows I need), but how can I get the non-consecutive cells to populate without having to go back and forth to sheet one, copy the other data (which I would have to do twice as there is a column in between that I do not need the data from.
I have tried to attach a file to show what I am trying to do. I hope it uploads
The file will be used with excel 2003.
copy from - copy to
sheet1 a1- Sheet2 a1
Sheet1 b1- Sheet2 b1
Sheet1 c1- Sheet2 e1
Sheet1 e1- Sheet2 h1
Sheet1 f1-Sheet2 i1
When I click on the first cell where I am pasting in sheet2 I type =sheet1 a1. I can then copy the adjacent cell (b and c - down as many rows I need), but how can I get the non-consecutive cells to populate without having to go back and forth to sheet one, copy the other data (which I would have to do twice as there is a column in between that I do not need the data from.
I have tried to attach a file to show what I am trying to do. I hope it uploads
The file will be used with excel 2003.