Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Printing selected parts of a list....

I have a parts list that is VERY long and want to make it so that when people
go in and enter a part that they use, it will only print those rows that the
data was changed in, or are some how marked.

How can I make this happen?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Printing selected parts of a list....

Without a lot more detail it would be difficult to hazard more than a guess.

You could use event code to mark when cells are changed then Autofilter for
those marked cells.


Gord Dibben MS Excel MVP

On Tue, 3 Apr 2007 13:28:01 -0700, Daniel R
wrote:

I have a parts list that is VERY long and want to make it so that when people
go in and enter a part that they use, it will only print those rows that the
data was changed in, or are some how marked.

How can I make this happen?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Printing selected parts of a list....

Thanks, I just needed to be pointed in the right direction. I think I can
take it from there...

"Daniel R" wrote:

I have a parts list that is VERY long and want to make it so that when people
go in and enter a part that they use, it will only print those rows that the
data was changed in, or are some how marked.

How can I make this happen?

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
Printing selected columns Dave Excel Discussion (Misc queries) 2 February 9th 07 07:05 PM
A validated List which link to selected cells according to what is selected on the list WL Excel Worksheet Functions 1 June 5th 06 08:52 PM
Help printing selected rows kcowan Excel Discussion (Misc queries) 4 January 2nd 06 11:52 PM
Printing selected rows maacmaac Excel Discussion (Misc queries) 1 December 8th 05 05:15 PM
Dependant parts list -lookup BEEZ Excel Discussion (Misc queries) 3 October 8th 05 12:37 PM


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