i need a macro to produce three excel sheets for a data input sheet

[Titan001]

hello,

i am new with macros. i have a list of overdue invoices a company needs to pay (refer to data input sheet). I need to to produce three separate excel sheets for payment authorization one to Paul and Steve, another to Paul and Jack and another to Jack and Steve (refer to sheets attached)

Can anyone help with me with a macro? Thanx.

[mrice]

Maybe this?

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010/2013.

[Titan001]

Thanks for this. Will try it out..