Drag copy between worksheets

G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search Multiple Worksheets 3
How to modify fill handle properties? 3
Table Export 3
Automatic populate Sheet2 with data from Sheet1 based on criteria. 2
Copy Multiple Areas from One Workbook to Another 4
Ignoring blanks and consolidating 1
Substitute Respective Entries In Arrays 7
Copy data from 1 sheet to multiple worksheets 2

Top