Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy increment by 1
Hi, My problem is that I can not get excel to copy increment by 1. On
one spread sheet I have data in A1 B1 C1. What I want to do is put this data into another spreadsheet in A1 A2 A3. Then copy the information in A1 A2 A3 to A4 A5 A6. Instead of having the A4 A5 &A6 refrence A4 B4 C4 i want it to refrence A2 B2 C2 etc. I have to copy this aprox. 400 times. Is there anyway I can accomplish this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
copy excell file to a CSV file and than to Notepad | Excel Discussion (Misc queries) | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) | |||
reminder notifications in a column | Excel Discussion (Misc queries) |