Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a macro to do this...
Hi all, I have tried to achive the following from writing a formula in th spreadsheet, but unfortunatly have been unable to achieve the desire result. I have a workbook which contains information about a series of product (PPV) in a catagory. The critical information is Product Name (D1:D50 Risk Value (DG1:DG50) and Risk Rating (DJ1:DJ50). example: Prod Name...Risk...Rating apple,............2........2 orange,.........2........1 pear,.............3........3 kiwi,..............3.........1 mango,.........2.........3 I need a macro that will find Orange, Apple, Mango (the prod names) an report them back into say cells A1,A2,A3 and 1,2,3 (the prod ratings into cells B1,B2,B3 in another workbook (prod inf) I need to formula if poss to look at the risk value from say cell E and then report this info back. I have no idea about VB but im prett sure it would be possible. Be great if anyone can help. Many thanks, Chris Rowe -- chrisrowe_c ----------------------------------------------------------------------- chrisrowe_cr's Profile: http://www.excelforum.com/member.php...fo&userid=2522 View this thread: http://www.excelforum.com/showthread.php?threadid=38939 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a macro to do this...
Say you enter orange in Cell A1 of the other workbook, then you can use the
formula =Vlookup(A1,[Book1.xls]Sheet1!$D$1:$DJ50,108,False) in B1, in C1 =Vlookup(A1,[Book1.xls]Sheet1!$D$1:$DJ50,111,False) then in A2 put in Apple, in A2 put in Mango drag fill the formulas down the column. -- Regards, Tom Ogilvy "chrisrowe_cr" wrote in message news:chrisrowe_cr.1skweh_1122048359.3436@excelforu m-nospam.com... Hi all, I have tried to achive the following from writing a formula in the spreadsheet, but unfortunatly have been unable to achieve the desired result. I have a workbook which contains information about a series of products (PPV) in a catagory. The critical information is Product Name (D1:D50) Risk Value (DG1:DG50) and Risk Rating (DJ1:DJ50). example: Prod Name...Risk...Rating apple,............2........2 orange,.........2........1 pear,.............3........3 kiwi,..............3.........1 mango,.........2.........3 I need a macro that will find Orange, Apple, Mango (the prod names) and report them back into say cells A1,A2,A3 and 1,2,3 (the prod ratings) into cells B1,B2,B3 in another workbook (prod inf) I need to formula if poss to look at the risk value from say cell E2 and then report this info back. I have no idea about VB but im pretty sure it would be possible. Be great if anyone can help. Many thanks, Chris Rowe. -- chrisrowe_cr ------------------------------------------------------------------------ chrisrowe_cr's Profile: http://www.excelforum.com/member.php...o&userid=25220 View this thread: http://www.excelforum.com/showthread...hreadid=389394 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |