Hi everyone,

Can someone help me develop a VBA code that when executed will look for the word "Total" in another workbook and report whatever number in the cell beneath it to the main workbook? For example, I have a master spreadsheet that has the macros and another workbook that has a quote to a customer. When I click on the VBA code button, I want it to look for the word "Total" in the quote spreadsheet and report the number value beneath it to the master spreadsheet. Any idea how I can do this using VBA, please?

Thank you!