Copy Sheets in A Master Sheet

[Pirvu Vali]

Hi! i need for a vba with this condition : if i check x in column B, in column A will be allocate a unique number(for Sheet1.............Sheet6).All sheets will be copy in sheet Master. Thanks

[YasserKhalil]

Not clear
I think it is better to upload sample workbook with some of desired output

[Pirvu Vali]

so if in column B from Sheet1 i will write x, then in column A will be alocate automatically a unique number. All data from A1:Z50 will be copy in Master

[YasserKhalil]

Upload sample of your file with some of the expected output

[Pirvu Vali]

I uploaded a file with a little example

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[Pirvu Vali]

hi! if i put "x" in column B from Sheets1, 2, 3, not happening nothing

[Pirvu Vali]

i want to allocate unique number on column A from sheets 1, 2, 3 automatically, and all data copy to master. if in column A from Master is already a number, in sheets 1,2 ,3 this number can't be allocated

[Pirvu Vali]

hi! please help me! i want to allocate automatically number in column A, in in column B check x for every sheets, excepting Master.

[Pirvu Vali]

nobody can help me?