Hi All,
  1. I am trying to come up with a code for doing the following process:
  2. Summary sheet (Sheet 1) contains the list of range in columns A and B. For Example range in Column A will be 1,2,3...n
  3. Sheet 2 is my master sheet with all the data. Row 1 will have the values 1,2,3,...n (same as the values in column A of sheet 1)
  4. I am trying to create a copy of sheet 2 and create n number of sheets based on the values in column A of sheet 1 and rename them with 1, 2, 3,...n. i.e., names of sheet 3 =1, sheet 4 = 2, sheet 5 = 3, and so on.
  5. After creating n copies i would like to go to each created sheet and delete the columns that are not required. i.e., in sheet 3 (name is 1) i would like to loop though row 1 and find the cell value with sheet name (value 1), keep that column and delete all the other columns.
  6. Now sheet 3 will have the only column pertaining to value 1. Then i would like to loop through that particular column and delete all the rows that are empty and contains certain values.

Any help will be greatly appreciated. Thank you very much in advance.

Regards,

Kon.