Hello
A lot of help needed please.
I have 3 Workbooks named WorkbookA, WorkbookB & WorkbookC. WbA has a user form, WbB has the data I want to find. WbC has the data across 3 sheets, examples attached.
In WbA my user form (Ctrl u to open) has command buttons to open & close WbB & WbC, There is also a button for closing the userform. These all work ok.
This is where I need the help.There is also a button I want to press which will look at the cells in WbB (other cells are populated with different data but need to be ignored) and find the matches in WbC, across 3 sheets.
When found I want the column heading of the matched data and the row data from column A & B to be copied and pasted in WbB column B cell below and column H adjacent column I.
I f this is too much to expect from the press of 1 button I am quite happy to break it down to individual searches as long as I get the copy & paste I am looking for. Which should look like Column Header/ Row Data Column A\Row Data Column B.
I hope that makes sense.
Gil