Copying contents of a specified cell from 1 worksheet to another

**mathew086** · 02-07-2012, 02:06 PM

Hello all

I have a Main worksheet which contains data in 4 columns & 9 rows. First column contains numbers 1,2 & 3. What is want is this :

I need the DO button in the worksheet 1 to do the folowwing procedure.

The row containing the value "1" in Column A has to be copied to Type 1
The row containing the value "2" in Column A has to be copied to Type 2
The row containing the value "3" in Column A has to be copied to Type 3

When in enter new data in worksheet Main, and then click the DO button, everything in the worksheets Type1, Type 2, Type 3 have to updated.

Can someone show me an example??
Thanks.

Attached is my Test Excel sheet

**JBeaucaire** · 02-07-2012, 03:11 PM

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.

The only real difference is the sheetnames will match the column A values exactly, and row1 needs to be "titles" for each column. Drop your sample data into the sample workbook at row2 and give it a try.

**mathew086** · 02-09-2012, 07:16 AM

Hi JBeaucaire

Thankyou very much .... That example helped me a lot. I t was more or less what i needed. I changed a little bit to my needs and it works peerfectly.... kudos to u

cheers

**JBeaucaire** · 02-09-2012, 12:58 PM

That is the exact intention! Good work.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.