Pastlink and drag (1 Viewer)

mahen

Registered User.
Local time
Today, 17:18
Joined
Jan 13, 2008
Messages
56
If anyone don't understand what I am trying to say, please let me know. See attachement example..... Mahen
 

Attachments

  • ex.xls
    17.5 KB · Views: 79

Brianwarnock

Retired
Local time
Today, 17:18
Joined
Jun 2, 2003
Messages
12,701
If I understand you correctly then the way to do this is
Copy
Pastespecial transpose

But I suspect that there may be more to your requirement.

Brian
 

mahen

Registered User.
Local time
Today, 17:18
Joined
Jan 13, 2008
Messages
56
Hi Brian,
Thanks for your response. But I don't think you under my request. I do need similar way of transpose with formulas. So eveytime I change the value in sheet1 it should change in sheet2. I can do one by one copy and pastlink to do this task. But I don't want to do one at a time. I want something copy one and drag. Is it possible?
 

Brianwarnock

Retired
Local time
Today, 17:18
Joined
Jun 2, 2003
Messages
12,701
I don't understand, there appear to be 2 issues here, first you mention copy and drag and then talk about doing it one cell at a time with transpose, just for the record to use transpose
highlight all the required cells on sheet1 ie c3 to c10 select Copy

select cell D5 on sheet2 select Edit, pastspecial, check Transpose and click OK
D5 to K5 will now contain the data.

What have Formulas got to do with this?

If you want a Cell on Sheet2 to equal a cell on Sheet1 then =sheet1!c3 for example, does the trick.

Brian
 

mahen

Registered User.
Local time
Today, 17:18
Joined
Jan 13, 2008
Messages
56
Brian,
I just want to do what you mentioned on your last line. But I want to do the same along line three (left to right) on sheet2. I don't want to copy one cell at a time. Anything like draging along line three?
 

Brianwarnock

Retired
Local time
Today, 17:18
Joined
Jun 2, 2003
Messages
12,701
I am still unclear, it now seems as though you want to type
=Sheet1!c3 into a cell and then drag that along a row with the row number changing, that is not possible as far as I know, dragging along a row will cause the column reference to change, this can be avoided by using absolute addressing
=Sheet1!$c3
Then this will appear in each cell thus leaving you to change the row number.

This appears to be a different question than the original of copying from sheet1

Brian
 

mahen

Registered User.
Local time
Today, 17:18
Joined
Jan 13, 2008
Messages
56
Brian,
This is what I wanted to do, but I wanted to know whether any short cut is available instead of changing every single row numbers in the cell.
 

Users who are viewing this thread

Top Bottom