I am pretty new to VBA, but I am in the process of building multiple micro systems around an excel spreadsheet that is populated with Data.
In the current micro system I am building I would like to type in a number in say cell F7 and type in cell I7 any text of my choosing.
When I press a button I want the macro to copy cell I7 open another workbook with stored data, search for the value from cell F7 of other workbook in Collum A and paste the text from cell I7 into the same row of found cell, in to cell at collum Q.
I hope I have explained myself ok, and look forward to any responses.