Required a macro to create following worksheets and copy Id Nos to appropriate worksheet in a cell position C3 on all sheets.
Worksheet Name Id Name
Name1 A001
Name3 C004
Name6 W042
These details are in the same workbook in a worksheet.(eg Sheet1)
Thanks.
Mahen
Worksheet Name Id Name
Name1 A001
Name3 C004
Name6 W042
These details are in the same workbook in a worksheet.(eg Sheet1)
Thanks.
Mahen