G
Guest
Hi,
I need to link a row of data into a column of data (in the same workbook).
The Source worksheet will be changed periodically. I have tried all
variations of paste special and paste link and cannot figure out how to do
this. Help Please!!
example worksheet 1 (E1:Z1) to transpose this row into a column on
Worksheet 2 (F1:F26). However, the source worksheet 1 will have new data
entered so worksheet 2 must be linked to to worksheet 1.
Instead of just copying and clicking on the "paste link" option to take a
row in worksheet 1 to worksheet 2, how do I make it a column in worksheet 2?
Thanks,
I need to link a row of data into a column of data (in the same workbook).
The Source worksheet will be changed periodically. I have tried all
variations of paste special and paste link and cannot figure out how to do
this. Help Please!!
example worksheet 1 (E1:Z1) to transpose this row into a column on
Worksheet 2 (F1:F26). However, the source worksheet 1 will have new data
entered so worksheet 2 must be linked to to worksheet 1.
Instead of just copying and clicking on the "paste link" option to take a
row in worksheet 1 to worksheet 2, how do I make it a column in worksheet 2?
Thanks,