Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 16th 12, 12:23 AM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2012
Posts: 3
Default Sharing infor between worksheets based on terms

Hello,
I have a master pipeline and in the Status column there will be terms such as "closed", "approved", "pending", etc. I also have additional worksheets in the same workbook titled "closed", "approved", "pending", etc. I want to be able to look at the master pipeline and see everything that was input and have the "closed" rows copied to the "closed" worksheet, the "approved" copied to the "approved" worksheet, etc. How can I do that?

  #2   Report Post  
Old January 16th 12, 02:07 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2010
Posts: 420
Default Sharing infor between worksheets based on terms

Ron de Bruin has lots of code for splitting this kind of stuff on his site:
http://www.rondebruin.nl/tips.htm

I'd try this first:
http://www.rondebruin.nl/copy5.htm


On 01/15/2012 17:23, Tally38 wrote:
Hello,
I have a master pipeline and in the Status column there will be terms
such as "closed", "approved", "pending", etc. I also have additional
worksheets in the same workbook titled "closed", "approved", "pending",
etc. I want to be able to look at the master pipeline and see everything
that was input and have the "closed" rows copied to the "closed"
worksheet, the "approved" copied to the "approved" worksheet, etc. How
can I do that?





--
Dave Peterson
  #3   Report Post  
Old January 18th 12, 03:23 AM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2012
Posts: 3
Default

I am really a beginner, so I have no idea what the article is telling me. I can attach the workbook if you think you can help me fix it.

Tally38

Quote:
Originally Posted by Dave Peterson[_2_] View Post
Ron de Bruin has lots of code for splitting this kind of stuff on his site:
http://www.rondebruin.nl/tips.htm

I'd try this first:
http://www.rondebruin.nl/copy5.htm


On 01/15/2012 17:23, Tally38 wrote:
Hello,
I have a master pipeline and in the Status column there will be terms
such as "closed", "approved", "pending", etc. I also have additional
worksheets in the same workbook titled "closed", "approved", "pending",
etc. I want to be able to look at the master pipeline and see everything
that was input and have the "closed" rows copied to the "closed"
worksheet, the "approved" copied to the "approved" worksheet, etc. How
can I do that?





--
Dave Peterson
  #4   Report Post  
Old January 18th 12, 01:36 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2010
Posts: 420
Default Sharing infor between worksheets based on terms

No thanks to the workbook.

Since you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

On 01/17/2012 20:23, Tally38 wrote:
I am really a beginner, so I have no idea what the article is telling
me. I can attach the workbook if you think you can help me fix it.

Tally38

'Dave Peterson[_2_ Wrote:
;1141885']Ron de Bruin has lots of code for splitting this kind of stuff
on his site:
http://www.rondebruin.nl/tips.htm

I'd try this first:
http://www.rondebruin.nl/copy5.htm


On 01/15/2012 17:23, Tally38 wrote:-
Hello,
I have a master pipeline and in the Status column there will be terms
such as "closed", "approved", "pending", etc. I also have additional
worksheets in the same workbook titled "closed", "approved",

"pending",
etc. I want to be able to look at the master pipeline and see

everything
that was input and have the "closed" rows copied to the "closed"
worksheet, the "approved" copied to the "approved" worksheet, etc.

How
can I do that?



-


--
Dave Peterson






--
Dave Peterson


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
Help with Excel - autopopulate a long table based on infor from an jcpotwor Excel Discussion (Misc queries) 2 July 12th 07 03:12 PM
Sharing Data Between Worksheets spartikus New Users to Excel 2 March 10th 06 02:45 AM
sharing totals between worksheets ~*~ Twinkle~*~ New Users to Excel 1 September 6th 05 08:00 AM
Sharing data across worksheets within a workbook based on identifi deedle93 Excel Discussion (Misc queries) 2 August 18th 05 04:26 AM
sharing an array between worksheets Peter Excel Programming 1 April 29th 04 04:09 PM


All times are GMT +1. The time now is 11:58 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017