Hi guys, I need a help in solving the below problem.
I would like to return the cell value from every 3rd column, but having an issue with OFFSET function as it does not work with a closed workbook.
Knowing that INDEX function would be an alternative, but I have no idea with it, can someone share an example with me pls?
For an example, I wanna copy I4, L4 O4 U4 and so on, which is every 3rd column from the previous selection.
I would like to return the cell value from every 3rd column, but having an issue with OFFSET function as it does not work with a closed workbook.
Knowing that INDEX function would be an alternative, but I have no idea with it, can someone share an example with me pls?
For an example, I wanna copy I4, L4 O4 U4 and so on, which is every 3rd column from the previous selection.