Pastlink and drag (1 Viewer)

[mahen]

How do I drag a cell across (from left to right) after past link from another sheet? eg. I have values in C3 to C10 in sheet1. I need to copy and past link the value in C3 in sheet 1 into D5 in sheet 2. And drag C3 accross. How do I do? Report in sheet1 values are up to down. Need those value in another report in sheet 2 which is across. I am useing office 7 and 2010 version.

regards,
- Mahen

 

[Brianwarnock]

This has been answered in his second thread.

You should not start a second thread on the same topic but add to your first.

Brian

 

[mahen]

Sorry. You are right.

- Mahen