VBA code required

[Marky_B]

Good evening all,
first off thank you for any help, given. I'm after automating invoices from 2 registers.
The setup is I have 2 workbooks [Register_1] and [Register_2] with 5 sheets in each [Week_1] [Week_2] [Week_3] [Week_4] [Week_5], and 1 workbook [Master] with sheet [Invoice] macros enabled to pull data from the other 2 workbooks all saved in the same folder. What I need help with is the following

• I would like code to search [Register_1] sheet [Week_1] for a surname in cell range {A8-A95} and forename cell range {B8-B95} if match found then
  • copy cell {A1} to workbook [Master] sheet [Invoice] cell {B13}
  • copy total for week to workbook [Master] sheet [Invoice] cell {C13}
  • repeat for [Week_2] [Week_3] [Week_4] [Week_5] moving copy down a cell each time in workbook [Master] sheet [Invoice]
  • If no match then end

Hopefully this all makes sense. I wish I could share the project somehow?

Thank you once again for any help

 

[Marky_B]

anyone?