Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > select the data and copy in another sheet
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 5
Default 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.
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 9,101
Default 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.
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
select a range, copy it to a new sheet Dave F Excel Discussion (Misc queries) 1 September 22nd 06 08:06 PM
Stop select and copy of excel sheet in protect mode Rakesh[_2_] Excel Programming 0 August 28th 06 09:54 AM
Select rows and copy to another sheet. Juan Excel Programming 6 March 29th 05 12:53 AM
Select a sheet to copy from one workbook to another holysoul[_4_] Excel Programming 2 June 4th 04 03:27 PM
Automatically select range and copy to new sheet Alistair[_2_] Excel Programming 3 October 11th 03 04:33 AM


All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement