Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Copy a row of data from ne worksheet to another

I have an excel workbook with two worksheets,
I need to cut any row that has "Complete" in a specific cell from
worksheet 1.
Then paste it onto worksheet 2 on the next available row.
T.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Copy a row of data from ne worksheet to another

See this example
http://www.rondebruin.nl/copy5.htm#Add

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Galway" wrote in message ...
I have an excel workbook with two worksheets,
I need to cut any row that has "Complete" in a specific cell from
worksheet 1.
Then paste it onto worksheet 2 on the next available row.
T.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Copy a row of data from ne worksheet to another

Thank you!
This worked great.
T.


On May 14, 1:15*pm, "Ron de Bruin" wrote:
See this examplehttp://www.rondebruin.nl/copy5.htm#Add

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Galway" wrote in ...
I have an excel workbook with two worksheets,
I need to cut any row that has "Complete" in a specific cell from
worksheet 1.
Then paste it onto worksheet 2 on the next available row.
T.- Hide quoted text -


- Show quoted text -


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Copy data from one worksheet and paste into another worksheet stockton12 Excel Programming 3 March 30th 08 09:40 PM
Copy data in multiple worksheet tabs into one worksheet Bob Excel Programming 2 February 15th 08 03:01 PM
copy from B worksheet to A worksheet with NO repeated data tikchye_oldLearner57 Excel Discussion (Misc queries) 1 September 29th 06 06:56 PM
copy data in a cell from worksheet A to worksheet B rajesh Excel Discussion (Misc queries) 1 February 21st 06 07:40 AM
Copy Modified Worksheet 1 Data to Worksheet 2 clarkelrc Excel Programming 0 April 15th 04 01:36 PM


All times are GMT +1. The time now is 08:44 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"