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.


+-------------------------------------------------------------------+
|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

output macro
 

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

output macro
 

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

output macro
 

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