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
regards,
- Mahen