LinkBack URL
About LinkBacks
I would post this in the programming section (with a sample), since it involves opening >3.500 sheets.
//Ola
If it was just a few sheets...:
A1: upper left corner in matrix
=OFFSET($A$1;INT((ROWS($B$1:B1)-1)/3);MOD(ROWS($B$1:B1)-1;3))
I would post this in the programming section (with a sample), since it involves opening >3.500 sheets.
//Ola
If it was just a few sheets...:
A1: upper left corner in matrix
=OFFSET($A$1;INT((ROWS($B$1:B1)-1)/3);MOD(ROWS($B$1:B1)-1;3))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks