joeyc
08-05-2009, 10:41 PM
Hello,
I was wondering if anyone could create a quick macro here. I will describe what I am looking for below. Also, I have attached a sample to make things easier.
1- I have workbook with many worksheets. The worksheet of interest is named 'MOVEHOLDINGS.'
2- The worksheet called 'MOVEHOLDINGS' has 9 fields in columns A --> I. The number of rows in 'MOVEHOLDINGS' is undefined.
3- I would like to reformat the data on this worksheet in a special way. I would like to transfer each unique name given in field 2 to a new worksheet. The name for the new worksheet should be the unique name in Field 2. In this case, 3 new worksheets will be created. However, I would like all of these worksheets to appear in a new workbook.
4- To summarize, the way I see this working is, I will run a macro on a workbook that contains a worksheet called 'MOVEHOLDINGS.' The macro will then rearrange the data on 'MOVEHOLDINGS' in a new workbook. Each unique name in field two will be on a separate sheet. Each worksheet will bear the name of the name given in Field 2.
One issue to consider is what if the name given in Field 2 is too long to be used as the name for the worksheet tab. I don't know how I would handle that.
I was wondering if anyone could create a quick macro here. I will describe what I am looking for below. Also, I have attached a sample to make things easier.
1- I have workbook with many worksheets. The worksheet of interest is named 'MOVEHOLDINGS.'
2- The worksheet called 'MOVEHOLDINGS' has 9 fields in columns A --> I. The number of rows in 'MOVEHOLDINGS' is undefined.
3- I would like to reformat the data on this worksheet in a special way. I would like to transfer each unique name given in field 2 to a new worksheet. The name for the new worksheet should be the unique name in Field 2. In this case, 3 new worksheets will be created. However, I would like all of these worksheets to appear in a new workbook.
4- To summarize, the way I see this working is, I will run a macro on a workbook that contains a worksheet called 'MOVEHOLDINGS.' The macro will then rearrange the data on 'MOVEHOLDINGS' in a new workbook. Each unique name in field two will be on a separate sheet. Each worksheet will bear the name of the name given in Field 2.
One issue to consider is what if the name given in Field 2 is too long to be used as the name for the worksheet tab. I don't know how I would handle that.