Transfer data from one worksheet to another

**Gigi2009** · 08-02-2010, 08:22 PM

Hello - any help will be appreciated.

I need help creating a macro to transfer data from from worksheet into a new worksheet. Basically, I have one worksheet containing all data and need to:
1. At each change in data - move data (all rows) to new worksheet
2. Create a tab and rename tab using information from one of the cells
3. Include header from main worksheet

For example:

Master File
Column A Column B
AA 1
AA 2
BB 3
BB 4
CC 5

In the end, I would like to have a total of 4 tabs named: Master File, AA, BB and CC.

Tab AA
Column A Column B
AA 1
AA 2

Is this possible? I attached a sample master file with tabs to show what I need.

Thanks.

**rylo** · 08-02-2010, 09:00 PM

Hi

Here's one way.

Please Login or Register  to view this content.

rylo

**Gigi2009** · 08-03-2010, 08:05 AM

This is great - thanks.

Is there a way to tweak the code to add columns.
My actual worksheet column range is A:DG

I also need to change the above code to show the filter of Column CS (this is also the tab name).

**rylo** · 08-03-2010, 06:54 PM

Hi

Update your example file to fully cover the design of your actual structure, and I'll have a look.

rylo

**Gigi2009** · 08-03-2010, 07:53 PM

Thanks.
I've attached an updated sample.

Basically, I need information from cell CS to be separated into different tabs - and the tabs named using the cell information.

Does it matter how many rows I have? The actual worksheet has over 1000 rows.

Thanks.

**rylo** · 08-03-2010, 09:47 PM

Hi

OK, See how this goes.

Please Login or Register  to view this content.

rylo

**Gigi2009** · 08-09-2010, 04:26 PM

Sorry for the delay - but the macro worked perfectly.

Thanks again.

Transfer data from one worksheet to another

LinkBack

Thread Tools

Rate This Thread

Display

Transfer data from one worksheet to another

Re: Running macros to transfer data from one worksheet to another

Re: Running macros to transfer data from one worksheet to another

Re: Running macros to transfer data from one worksheet to another

Re: Running macros to transfer data from one worksheet to another

Re: Running macros to transfer data from one worksheet to another

Re: Running macros to transfer data from one worksheet to another

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions