How do I make a condition in Excel 2000 to print out the output?

  • Thread starter Thread starter SiRkNiGhT115
  • Start date Start date
S

SiRkNiGhT115

Hello,
I need some help, I wanted to make a condition so when a item is less
then what it suppost to be I wanted it to turn red and at the end I
would like a print out of all the item that are in red, or when the
condition is met I would like a print out. Could someone help me out
with this problem? I am trying to inventory some of my item in Excel
for now then try to put it in a access form but for now I would like to
setup the condition so I can have a good idea on how to do this. Could
also someone give me a web site where I can make up some formala
myself?
Thank You
 
From what you say I gather that you want Excel to figure out what to print
and then print it. This can be done in a number of ways depending on the
layout of your data and if you want it to take place when the criteria is
met or at some later time. Either way, a VBA macro will be needed.
One question comes to mind. Do you just want to be notified when the
criteria is met (like a message box on the screen) or do you specifically
want a printout?
If you wish, send me, direct, a sample file of what you have, and the
criteria that must be met, and a sample of what you want the printout to
look like, or if a message box is all you want. My email address is
(e-mail address removed). Remove "Cobia97" from this address. HTH
Otto
 
Yes !!!! I would love a print out when the criteria is met ! also a
message box will help me out too. But I will need a print of all the
items that our low in my inventory. You nail my question right on ! I
am also looking if there is a way to received a email to notified when
the critieria is met. I will try to email you!
Thank You
 
Back
Top