Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Odd copy and paste question
The logic here sounds so simple to me but I can not get the code to work so I
could use some help. I am in Excel 2000 and I am dealing with 2 sheets in the same workbook. On sheet one I have a column of words (like in Cells A1 to A10) and I need to set up some kind of macro loop that will grab the info from cell A1 on Sheet1 and copy it to Cell C2 on Sheet2 then grap Cell A2 from Sheet1 and put in in Cell D2 on Sheet2. because I am copying a column and pasting it into a row I can not just grab the range. I have to get them one at a time. Here is something a Little better to show what I am talking about Sheet1 | Sheet2 (Cell)A | CellA Cell B Cell C 1 Test | Test Desk House 2 Desk | 3 House | |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste Question | Excel Discussion (Misc queries) | |||
Copy/Paste Question | Excel Discussion (Misc queries) | |||
Copy/Paste question | Excel Worksheet Functions | |||
Tricky copy/paste question | Excel Programming | |||
Copy Paste Question | Excel Discussion (Misc queries) |