Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default Move data to new sheet depending on criteria

Hi
Hopefully this can be done.

I want to create a button on a sheet that will import all data from a master
sheet. eg if CostCode = 11005, I want all that data that refers to this
code to be moved to a sheet marked for that code beginning on line 2 of new
sheet.

Thanks enna49
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Move data to new sheet depending on criteria

Hi enna49

Try this
http://www.rondebruin.nl/copy5.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"enna49" wrote in message ...
Hi
Hopefully this can be done.

I want to create a button on a sheet that will import all data from a master
sheet. eg if CostCode = 11005, I want all that data that refers to this
code to be moved to a sheet marked for that code beginning on line 2 of new
sheet.

Thanks enna49



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
Charting depending on criteria & data series name as a column val Mr.LuckyMe Charts and Charting in Excel 2 June 16th 09 02:53 PM
How to move data to another worksheet depending on the criteria harwookf Excel Discussion (Misc queries) 7 November 19th 08 03:29 AM
move data to another sheet depending on criteria harwookf Excel Worksheet Functions 8 October 24th 07 02:40 PM
moving data depending on criteria harwookf Excel Worksheet Functions 1 October 24th 07 02:40 PM
Move data to new sheet - rename sheet based on criteria ? [email protected] Excel Discussion (Misc queries) 7 May 16th 07 10:22 PM


All times are GMT +1. The time now is 01:12 PM.

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"