hi,
i have 1 workbook having 6 sheets
Mater invoice, Sheet2, Sheet3, Sheet4, Sheet5, Sheet6.
Sheet 2 to 6 have invoice no and invoice amount column. when i enter invoice no and amount in any Sheet then that Sheet name, invoice no and amount should be copied to Mater invoice file
and Mater...