Hi Guys,

First post on this forum so hi everyone

I need some help with my workbook which I have attached Master Workbook.xlsm

In my workbook I have the following sheets:

Customer Database
Invoice
Rounds(Week 1)
Rounds(Week 2)
Rounds(Week 3)
Rounds(Week 4)

SOLUTION I NEED:

In my customer database sheet I would like to have 2 buttons, one which says "create invoice" and one which says "add to" -this add to button would then give me four options like so: add to: rounds(week 1), rounds(week 2), rounds(week 3), rounds(week 4)

Now what I need the add to button to do is: in the customer database sheet based on my active/current cell selection when i click the button and choose either rounds week 1, 2, 3 or 4 it would paste the row that my active/current cell selection is on into rounds week 1, 2, 3 or 4

Now what I need the invoice button to do is based on my active.current cell selection when i click the button it would paste that entire row of information into their relative cells in the invoice sheet-EXCEPT "frequency"

Can someone help with this?

Many Thanks