Cell Reference, Multiple Sheets

C

CazMan007

I have 2 sheets in my workbook. The first sheet is simply a listing o
all my data. I want the second sheet to show the data from the firs
sheet listing my column data vertically on the page of the current ro
position. So if I am on row 5 on my first sheet, I want the secon
sheet to only show all row's 5 data from the first sheet, listing i
down the page. I have tried using cell("address") but it changes it'
value according to what sheet you're in.
Thank you,
CazMan00
 
B

Bob Phillips

If you can manage with VBA, this does it

ActiveCell.EntireRow.Copy
Worksheets("Sheet1").Select
Range("A1").PasteSpecial Paste:=xlPasteAll, Transpose:=True
 
Top