Hi everyone,

I was wondering if anyone could help with the code to do the following:


1. Start a loop going row by row through Sheet A of workbook (A)
2. For each column between 179 and 201 with a step of 2, if there is a value in it, copy a sheet (B) in Workbook A to a new Workbook (B).
3. Rename this new Sheet B in workbook B as the value in the column
4. Go to the next step/column in that row and if there is a value there, check to see if there is not already a sheet in the new workbook (B) that is under that name. If not then create a new sheet in workbook B named with that value
5. Commence the next row of Worksheet A if there is anything there and repeat step 2 onwards if there is.

The purpose of this is to create an invoice for a group of suppliers. However, if the supplier invoice has already been created obviously I don't want another invoice created. Is there any limit to how many sheets one can have in Excel 2007?

Many thanks in advance.