Danny: How about transposing data from one workbook (jan data to dec data over columns) to another (jan data to dec data over rows) however maintaining a link to the original workbook. only the column letter needs to be changed on each row.
Re: Links - They are easily broken. My suggestion is to keep the two workbooks that are "linked" in the same directory. This is especially important if - for example - you are sharing the workbooks between an office and home computers let's say via a USB Thumb Drive.
Thanks for the help :)
puppy482 1 month ago
@puppy482
My pleasure. Thanks for adding your comment.
Danny Rocks
The Company Rocks
DannyRocksExcels 1 month ago
Danny: How about transposing data from one workbook (jan data to dec data over columns) to another (jan data to dec data over rows) however maintaining a link to the original workbook. only the column letter needs to be changed on each row.
johnjoliver 3 months ago
@johnjoliver
I don't see any reason why that would not work.
Re: Links - They are easily broken. My suggestion is to keep the two workbooks that are "linked" in the same directory. This is especially important if - for example - you are sharing the workbooks between an office and home computers let's say via a USB Thumb Drive.
Danny Rocks
The Company Rocks
DannyRocksExcels 3 months ago
Many thanks for explaining us the transposing function,it is actually very useful
sharma1amit 3 months ago
@sharma1amit
My pleasure. I am glad that you enjoyed my tutorial.
Danny Rocks
The Company Rocks
DannyRocksExcels 3 months ago
Thanks, it is very helpful. And your teaching method is very easy to understand and learn. Thanks again.
digitaldeziner 9 months ago
@digitaldeziner
Thank you for writing to me. I am pleased that I could help you.
Danny Rocks
The Company Rocks
DannyRocksExcels 9 months ago