Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula / Macro Help
Hi, Can anyone help me? I have some text in cell A1 and i wish it to search in column A on 5 other worksheets for that reference. If it then finds a match on one of the sheets i want it to tell me on sheet1 in B1 that its in worksheet 4 for example ie sheet1 A1 = Toy Car sheet4 A335 = Toy Car sheet1 B1 = Sheet4 Can this be done?? Any help appreciated Regards Craig -- BSLAUTOMATION ------------------------------------------------------------------------ BSLAUTOMATION's Profile: http://www.excelforum.com/member.php...fo&userid=7611 View this thread: http://www.excelforum.com/showthread...hreadid=400755 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving the formula "average" over one column in a macro | Excel Worksheet Functions | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Insert macro into formula | Excel Worksheet Functions | |||
Fill Formula - Macro | Excel Discussion (Misc queries) |