Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Condiational Macro
Hi all! I've got a problem and I really need help. Say the data in sheet 1 looks like this: http://www.excelforum.com/attachment...tid=3960&stc=1 And the data in sheet 2 looks like this: http://www.excelforum.com/attachment...tid=3961&stc=1 So basically, I need some macro that will fill up the Number column in Sheet 2. As can be seen in Sheet 1, for example, AAA Inc. has only one ID (AAA) but can be part of either the LMFI or LMFII group. So I need something that will fill up the Number column in Sheet 2 conditional on the Group in Sheet 1. Any help would be really really appreciated. Thanks! +-------------------------------------------------------------------+ |Filename: sheet2.JPG | |Download: http://www.excelforum.com/attachment.php?postid=3961 | +-------------------------------------------------------------------+ -- uberathlete ------------------------------------------------------------------------ uberathlete's Profile: http://www.excelforum.com/member.php...o&userid=28388 View this thread: http://www.excelforum.com/showthread...hreadid=480103 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
How to use condiational validation choices in same column? | 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 |