Hi All,
I hope I will be able to be clear enough. I am a beginner in Macros/VBA and I need your help.
Basically I have 2 spreadsheets in one excel document.
Every week I copy and paste a table to sheet2 from another program that allows me to extract data and paste them into excel.
The column on this table are the same but the lines are different. Some weeks I may have less lines.
For example some weeks I may have TMA, TMB, TMR and some weeks I may not have TMR therefore I will have less lines.
What I need is the data from column 2 and 3 to be copied to sheet 1 in any of the cell that I will choose.
For example I would like "8" which correspond to TMK in sheet 2 to be copied into sheet 1 in L13.
The problem is that some weeks TMK might me in the cell A10 and some other could be A14, but I would like excel to recognize automatically RMK and the numbers in the columns 2 and 3 that corresponds to RMK and copy the data into sheet1.
Not sure if this is clear and if this is possible.
I have attached my excel sheets even though there is not much info on it.
Please let me know if you need more info.
Thanks!
Virginia
Bookmarks