| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying cells from one sheet to another
I have data in sheet one, A1 thru A50, and in another sheet these cells are
referneced. I need to copy as follows: Sheet 1 A1 to Sheet 2 A1 Sheet 1 A2 to Sheet 2 A10 Sheet 1 A3 to Sheet 2 A20 Sheet 1 A4 to Sheet 2 A30 and so on.... but everytime I try to copy Sheet 2 A10 gets the data from Sheet1 A10 and not A2. How do I get around this? Thanks. P.S. I am in office 2000 and 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying text on sheet 1 to corresponding cells on sheets 2 to 5 | New Users to Excel | |||
| Copying Cells From Multiple Worksheets to Create Summary Sheet | Excel Discussion (Misc queries) | |||
| Copying specific cells from a sheet to another | Excel Discussion (Misc queries) | |||
| Copying a column to a new sheet so that cells match. | Excel Worksheet Functions | |||
| Copying cells downward on sheet | New Users to Excel | |||
Threaded Mode
