Hi,
How could I transfer a specific cell from multiple sheets to a separate one.
For example, I want to have B1 cell from all sheets, vertically all transferred to a new one sheet (Transfer).
Hi,
How could I transfer a specific cell from multiple sheets to a separate one.
For example, I want to have B1 cell from all sheets, vertically all transferred to a new one sheet (Transfer).
in your example its horizontally btw.![]()
Please Login or Register to view this content.
If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.
Thanks for your answer Bishonen! But can we transfer the whole link of each cell?
ex. ='AXD-CDG'!B1, ='AXD-LCA'!B1 ... and so on
the code has to be executed with the first sheet being active.![]()
Please Login or Register to view this content.
Thanks a lot! it works!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks