output macro

Help please


Please see attached. Looking for help in Macro. Is there a way where I could set up the macro and it will give me Product # 321321, 659853, 321548?

I need to do it manually every time but if there is a way where I could choose which product I want on my hard copy and return product num, product dis and their valid from, valid to date.

WE don't download

Please cut and paste relevant code....

"xgunda420x" wrote:

>
> Help please
>
>
> Please see attached. Looking for help in Macro. Is there a way where
> I could set up the macro and it will give me Product # 321321, 659853,
> 321548?
>
> I need to do it manually every time but if there is a way where I could
> choose which product I want on my hard copy and return product num,
> product dis and their valid from, valid to date.
>
>
> +-------------------------------------------------------------------+
> |Filename: product.jpg |
> |Download: http://www.excelforum.com/attachment.php?postid=3762 |
> +-------------------------------------------------------------------+
>
> --
> xgunda420x
> ------------------------------------------------------------------------
> xgunda420x's Profile: http://www.excelforum.com/member.php...o&userid=25559
> View this thread: http://www.excelforum.com/showthread...hreadid=400397
>
>

product num product dis valid from valid to
354893 syringes in 50 10/01/2004 09/30/2007
321321 syringes in 20 10/01/2004 09/30/2007
659853 meter 10/01/2004 09/30/2007
321548 test strips 10/01/2004 09/30/2007
321564 prenovbo 10/01/2004 09/30/2007
986565 injection 10/01/2004 09/30/2007
321556 syrings in 10 10/01/2004 09/30/2007

Under Help in Excel (not VBA) search Vlookup

It seems that a simple Vlookup formula is all you need

"xgunda420x" wrote:

>
> product num product dis valid
> from valid to
> 354893 syringes in 50
> 10/01/2004 09/30/2007
> 321321 syringes in 20
> 10/01/2004 09/30/2007
> 659853 meter
> 10/01/2004 09/30/2007
> 321548 test strips
> 10/01/2004 09/30/2007
> 321564 prenovbo
> 10/01/2004 09/30/2007
> 986565 injection
> 10/01/2004 09/30/2007
> 321556 syrings in 10
> 10/01/2004 09/30/2007
>
>
> --
> xgunda420x
> ------------------------------------------------------------------------
> xgunda420x's Profile: http://www.excelforum.com/member.php...o&userid=25559
> View this thread: http://www.excelforum.com/showthread...hreadid=400397
>
>