Hi,
I have a macro question. I have 10 rows, and in column A I insert the data A1-A10 in each column consecutively. Then in column B I put data at random, e.g B12, B3, B144, B1, B3, B45 etc. If I run a macro in the same workbook but on a different sheet I can get column B to repeat the order exactly. But if I muddle the A column in sheet 3, so in A1 I write A5, in A2 I write A1 etc, the B column repeats the information from before.
What I want it to do is to read what’s written in column A and respond accordingly – e.g if in sheet 1 the data A1 has the data B12 next to it in the B column, then wherever the data A1 appears on sheet 3, the data B12 will appear next to it. Does this make sense? And can you help? I have attached a relevant spreadsheet.
Thanks,
Graeme
Bookmarks