select the data and copy in another sheet
 

Hi,

I have this workbook where I have a sheet with this information:

company name-Memory
sheeft 1 TM/CS Type salary 1 salary 2 salary 3 salary 4 def salary

Employ 1 Default - - - - 2500
Employ 2 Default - - - - 3500

Employ 1 TM Special 2600 2700 2800 2900 -
Employ 2 TM Special 2650 2750 2850 2950 -

Employ 1 Promo 3500 - 3500 3500 -
Employ 2 Promo 3600 - 3600 3600 -

Employ 1 Special 4500 - 4500 4500 -
Employ 2 Special 4600 - 4600 4600 -

Employ 1 CS Special 3870 3870 3870 3870 -
Employ 2 CS Special 4570 4570 4570 4570 -

Employ 1 Special 4370 4070 4570 3870 -
Employ 2 Special 5070 4770 5070 4570 -
sheeft2 TM/CS Type salary 1 salary 2 salary 3 salary 4 def salary

Fix Default - - - - 2550
Employ 1 Default - - - - 3550
Employ 2 Default - - - - 4500

Fix TM Special 1870 1570 1370 1370 -
Employ 1 TM Special 1470 1170 970 970 -
Employ 2 TM Special 3200 2970 2770 2770 -

Fix Promo 1170 - 1170 1170 -
Employ 1 Promo 770 770 770 770 -
Employ 2 Promo 3370 - 3370 3370 -

Fix Special 1370 - 1370 1370 -
Employ 1 Special 970 970 970 970 -
Employ 2 Special 4170 - 4170 4170 -

Fix CS Special 1370 1370 1370 1570 -
Employ 1 CS Special 970 970 970 1170 -
Employ 2 CS Special 2770 2770 2770 2970 -

Fix Special 1870 1570 1370 1370 -
Employ 1 Special 1470 1170 970 970 -
Employ 2 Special 3270 2970 4170 2770 -
company name-Mobil
sheeft 1 TM/CS Type salary 1 salary 2 salary 3 salary 4 def salary

Employ 1 Default - - - - 2500
Employ 2 Default - - - - 3500

Employ 1 TM Special 2600 2700 2800 2900 -
Employ 2 TM Special 2650 2750 2850 2950 -

Employ 1 Promo 3500 - 3500 3500 -
Employ 2 Promo 3600 - 3600 3600 -

Employ 1 Special 4500 - 4500 4500 -
Employ 2 Special 4600 - 4600 4600 -

Employ 1 CS Special 3870 3870 3870 3870 -
Employ 2 CS Special 4570 4570 4570 4570 -

Employ 1 Special 4370 4070 4570 3870 -
Employ 2 Special 5070 4770 5070 4570 -
sheeft2 TM/CS Type salary 1 salary 2 salary 3 salary 4 def salary

Fix Default - - - - 2550
Employ 1 Default - - - - 3550
Employ 2 Default - - - - 4500

Fix TM Special 1870 1570 1370 1370 -
Employ 1 TM Special 1470 1170 970 970 -
Employ 2 TM Special 3200 2970 2770 2770 -

Fix Promo 1170 - 1170 1170 -
Employ 1 Promo 770 770 770 770 -
Employ 2 Promo 3370 - 3370 3370 -

Fix Special 1370 - 1370 1370 -
Employ 1 Special 970 970 970 970 -
Employ 2 Special 4170 - 4170 4170 -

Fix CS Special 1370 1370 1370 1570 -
Employ 1 CS Special 970 970 970 1170 -
Employ 2 CS Special 2770 2770 2770 2970 -

Fix Special 1870 1570 1370 1370 -
Employ 1 Special 1470 1170 970 970 -
Employ 2 Special 3270 2970 4170 2770 -


and I want to put every company in a new sheet with name like company name,
and all rows that contain "Default" from the colomn "Type" and from the
column "TM/CS" the rows with TM and CS I want to copy in those sheets, I mean
i want to looks like this sheet for the first company:

sheeft 1 TM/CS Type salary 1 salary 2 salary 3 salary 4 def salary
sheeft 1
sheeft 1 Employ 1 Default - - - - 2500
sheeft 1 Employ 2 Default - - - - 3500
sheeft 1 Employ 1 TM Special 2600 2700 2800 2900 -
sheeft 1 Employ 2 TM Special 2650 2750 2850 2950 -
sheeft 1 Employ 1 CS Special 3870 3870 3870 3870 -
sheeft 1 Employ 2 CS Special 4570 4570 4570 4570 -
sheeft2 Fix Default - - - - 2550
sheeft2 Employ 1 Default - - - - 3550
sheeft2 Employ 2 Default - - - - 4500
sheeft2 Fix TM Special 1870 1570 1370 1370 -
sheeft2 Employ 1 TM Special 1470 1170 970 970 -
sheeft2 Employ 2 TM Special 3200 2970 2770 2770 -
sheeft2 Fix CS Special 1370 1370 1370 1570 -
sheeft2 Employ 1 CS Special 970 970 970 1170 -
sheeft2 Employ 2 CS Special 2770 2770 2770 2970 -


so, is possible ? and how can I can I do that?

thank you.

select the data and copy in another sheet
 

Can you give a list of what data is in which columns. I need to know where
to get the Company Name, the Sheet name, and how to determine where one hseet
or workbook aend and the next starts.

"diaExcel" wrote:

Hi,

I have this workbook where I have a sheet with this information:

company name-Memory
sheeft 1 TM/CS Type salary 1 salary 2 salary 3 salary 4 def salary

Employ 1 Default - - - - 2500
Employ 2 Default - - - - 3500

Employ 1 TM Special 2600 2700 2800 2900 -
Employ 2 TM Special 2650 2750 2850 2950 -

Employ 1 Promo 3500 - 3500 3500 -
Employ 2 Promo 3600 - 3600 3600 -

Employ 1 Special 4500 - 4500 4500 -
Employ 2 Special 4600 - 4600 4600 -

Employ 1 CS Special 3870 3870 3870 3870 -
Employ 2 CS Special 4570 4570 4570 4570 -

Employ 1 Special 4370 4070 4570 3870 -
Employ 2 Special 5070 4770 5070 4570 -
sheeft2 TM/CS Type salary 1 salary 2 salary 3 salary 4 def salary

Fix Default - - - - 2550
Employ 1 Default - - - - 3550
Employ 2 Default - - - - 4500

Fix TM Special 1870 1570 1370 1370 -
Employ 1 TM Special 1470 1170 970 970 -
Employ 2 TM Special 3200 2970 2770 2770 -

Fix Promo 1170 - 1170 1170 -
Employ 1 Promo 770 770 770 770 -
Employ 2 Promo 3370 - 3370 3370 -

Fix Special 1370 - 1370 1370 -
Employ 1 Special 970 970 970 970 -
Employ 2 Special 4170 - 4170 4170 -

Fix CS Special 1370 1370 1370 1570 -
Employ 1 CS Special 970 970 970 1170 -
Employ 2 CS Special 2770 2770 2770 2970 -

Fix Special 1870 1570 1370 1370 -
Employ 1 Special 1470 1170 970 970 -
Employ 2 Special 3270 2970 4170 2770 -
company name-Mobil
sheeft 1 TM/CS Type salary 1 salary 2 salary 3 salary 4 def salary

Employ 1 Default - - - - 2500
Employ 2 Default - - - - 3500

Employ 1 TM Special 2600 2700 2800 2900 -
Employ 2 TM Special 2650 2750 2850 2950 -

Employ 1 Promo 3500 - 3500 3500 -
Employ 2 Promo 3600 - 3600 3600 -

Employ 1 Special 4500 - 4500 4500 -
Employ 2 Special 4600 - 4600 4600 -

Employ 1 CS Special 3870 3870 3870 3870 -
Employ 2 CS Special 4570 4570 4570 4570 -

Employ 1 Special 4370 4070 4570 3870 -
Employ 2 Special 5070 4770 5070 4570 -
sheeft2 TM/CS Type salary 1 salary 2 salary 3 salary 4 def salary

Fix Default - - - - 2550
Employ 1 Default - - - - 3550
Employ 2 Default - - - - 4500

Fix TM Special 1870 1570 1370 1370 -
Employ 1 TM Special 1470 1170 970 970 -
Employ 2 TM Special 3200 2970 2770 2770 -

Fix Promo 1170 - 1170 1170 -
Employ 1 Promo 770 770 770 770 -
Employ 2 Promo 3370 - 3370 3370 -

Fix Special 1370 - 1370 1370 -
Employ 1 Special 970 970 970 970 -
Employ 2 Special 4170 - 4170 4170 -

Fix CS Special 1370 1370 1370 1570 -
Employ 1 CS Special 970 970 970 1170 -
Employ 2 CS Special 2770 2770 2770 2970 -

Fix Special 1870 1570 1370 1370 -
Employ 1 Special 1470 1170 970 970 -
Employ 2 Special 3270 2970 4170 2770 -


and I want to put every company in a new sheet with name like company name,
and all rows that contain "Default" from the colomn "Type" and from the
column "TM/CS" the rows with TM and CS I want to copy in those sheets, I mean
i want to looks like this sheet for the first company:

sheeft 1 TM/CS Type salary 1 salary 2 salary 3 salary 4 def salary
sheeft 1
sheeft 1 Employ 1 Default - - - - 2500
sheeft 1 Employ 2 Default - - - - 3500
sheeft 1 Employ 1 TM Special 2600 2700 2800 2900 -
sheeft 1 Employ 2 TM Special 2650 2750 2850 2950 -
sheeft 1 Employ 1 CS Special 3870 3870 3870 3870 -
sheeft 1 Employ 2 CS Special 4570 4570 4570 4570 -
sheeft2 Fix Default - - - - 2550
sheeft2 Employ 1 Default - - - - 3550
sheeft2 Employ 2 Default - - - - 4500
sheeft2 Fix TM Special 1870 1570 1370 1370 -
sheeft2 Employ 1 TM Special 1470 1170 970 970 -
sheeft2 Employ 2 TM Special 3200 2970 2770 2770 -
sheeft2 Fix CS Special 1370 1370 1370 1570 -
sheeft2 Employ 1 CS Special 970 970 970 1170 -
sheeft2 Employ 2 CS Special 2770 2770 2770 2970 -


so, is possible ? and how can I can I do that?

thank you.