I have a little complicated formatting issue which I need to address via VBA in order to get references and values aligned in one row, so that I can later on look them up via a VLOOKUP formula.
right now, I would a need a macro which helps me to perform the following steps within column A, ranging from A2 to the last cell with content in column B (offset -1 to clolumn A)
1. cell A2 should display the value of B3 ( means write formula =b3 into cell A2)
2. offset by 4 rows from A2 to A6
3. cell A6 should display the value of B7
4. offset by 4 rows from A6 to A10
repeat....
repeat this until the last cell of the range is reached, then copy column A and paste the values to get rid of the formulas.
I have no clue how to go about macro. Would much appreciate if someone could provide me some code to get there.
Thank you very much!
A2k
Bookmarks