Copy sheets only if condition is satisfied (mat)
Hi guys,
i want a macro to do the following:
I have a masterfile with several sheets. If I run the macro i want it
to copy sheet1 and/orsheet2 and /or sheet 3 to a new workbook
depending on a condition.
Sheet 1 has to be copied always
Sheet 2 has to be copied only if the cell A2 from sheet 1 is the same
as the cell A2 from sheet 2
Sheet 3 has to be copied only if the cell A2 from sheet 1 is the same
as the cell A2 from sheet3
the sheets have to be copied as values and with the format off the
sheets from the masterfile.
Thanks guys
mat
|