I'm new with macro and VBA in excel and i hope you could help me on how to create a macro. I would like to find a certain text (e.g. Total Profit) in Column G(let say in the entire sheet) and copy the value next to it which is in the next two column and paste it L1 and M1.
Please see attached file
I would like to search for the word "Total NT" in the entire sheet and copy the numbers in the next two column. In that example, "Total NT" is located in G31 and I would like to copy the value of 11 and 15 and paste it in column L1 and M1.
As well as to search the word "Total Assets" (located in B31) and copy the value of of 999 and 2222 and wanted to paste the value at L3 and M3. and so on and so forth...
By the way, my worksheet has datas from A1:J200
Looking forward to hear anyone from you. Thanks!