| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drag copy between worksheets
In column A of Worksheet#1 I have the following values in R1 - "AA", R2-"BB",
R3-"CC", and so on though R26 "ZZ". In Worksheet#2 I want column A Row 1 to equal (Worksheet#1!A26) and show the "ZZ" value. I want to then drag that formula down so that Worksheet#2 A2 would show "YY" and so on until A26 would then show "AA". Excel is confused with the reverse of direction between worksheets, is there a way to fix this problem. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drag copy between worksheets
One way ..
Assume source data in A1:A26 in Sheet1, ie: AA, BB, ... ZZ In Sheet2, Put in A1: =OFFSET(Sheet1!$A$26,1-ROW(A1),) Copy A1 down to A26 to return the reverse order: ZZ, YY, ... AA -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "gte077g" wrote: In column A of Worksheet#1 I have the following values in R1 - "AA", R2-"BB", R3-"CC", and so on though R26 "ZZ". In Worksheet#2 I want column A Row 1 to equal (Worksheet#1!A26) and show the "ZZ" value. I want to then drag that formula down so that Worksheet#2 A2 would show "YY" and so on until A26 would then show "AA". Excel is confused with the reverse of direction between worksheets, is there a way to fix this problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Worksheets | Excel Worksheet Functions | |||
| How do I copy text using a formula between worksheets in Excel? | Excel Worksheet Functions | |||
| Allow header/footer to copy to other worksheets in 1 spreadsheet. | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| CREATE MACRO TO COPY MULTIPLE WORKSHEETS | Excel Discussion (Misc queries) | |||
Linear Mode
