Create sheets based on a column of master sheet

**samdaddy07** · 02-06-2009, 01:40 PM

In my master sheet there are two columns. in one column is the customer name (like Allianze Consultant and services) and in the other column is the currency (like USD, INR, TWD, etc).

I want create the number of blank sheets as per the rows of customer names. the sheets should be renamed as per the first two letters of the customer with the currency (like AC - USD, AC - INR, etc, as per above given example).

The format of master sheet is below:

Column A Column B
Allianze Cons USD
Allianze Cons INR

**royUK** · 02-06-2009, 01:42 PM

Attach an example workbook.

**samdaddy07** · 02-06-2009, 02:27 PM

attached the sample

**royUK** · 02-07-2009, 12:09 PM

Try this code

Please Login or Register  to view this content.

**ravishankar** · 02-07-2009, 01:08 PM

HI
The macro in the attached file meets your requirements
Ravi

**samdaddy07** · 02-09-2009, 01:11 PM

Hi ...

please advise for if the data is changed from columns A & B to Coulmns D & E (in the attached file), also if the row is changed from 1 to 8, where to ammend the macro to make it work properly??

**royUK** · 02-09-2009, 03:14 PM

You have two answers, who is your reply addressed to? The code I posted does what you asked, creates a sheet for each entry using the two first letters & the currency. It will only create sheets if the name has not been used.

**samdaddy07** · 02-10-2009, 02:54 PM

Roy, your macro is perfect....

Actually my question is, my data in the attached sheet, starts from column A, Row 1. If i change the destination, say starts from Column D row 8, where i have to amend your macro, to make it work as desired. i am just changing the columns and rows.