|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 17th 12, 12:58 PM
|
|||
|
|||
Macro/formula?
Slide1.jpgSlide2.jpg
oh my! i'm in a world of hurt and desperately need assistance. please know that i know very little about excel but i will do my best to describe my problem. SHEET 2 has a column of keywords:confused in column A. i need to take each seperate keyword and search for it on SHEET 1. every instance that the specific keyword shows up on SHEET 1 (typically about 3000 x's), i need to then add that keyword to SHEET 1 in column M. i have about 1000 different keywords to look up. UGH! can anyone assist? 
|
| Ads |
|
#2
May 21st 12, 03:57 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Macro/formula?
On Thursday, May 17, 2012 7:58:49 AM UTC-4, CEMCCABE wrote:
> Slide1.jpgSlide2.jpg > > oh my! i'm in a world of hurt and desperately need assistance. please > know that i know very little about excel but i will do my best to > describe my problem. SHEET 2 has a column of keywords:confused in column > A. i need to take each seperate keyword and search for it on SHEET 1. > every instance that the specific keyword shows up on SHEET 1 (typically > about 3000 x's), i need to then add that keyword to SHEET 1 in column M. > i have about 1000 different keywords to look up. UGH! can anyone assist? > > > > > -- > CEMCCABE So if the keyword shows up in SHEET 1, copy the keyword to column M, otherwise leave column M blank??
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| store formula in macro then paste it when macro runs | Nina | Excel Programming | 3 | December 16th 09 07:21 PM |
| formula or macro to change a formula in muliple spreadsheets | [email protected] | Excel Programming | 1 | May 21st 09 05:27 PM |
| use macro to copy formula with value and not formula without value | ramzi | Excel Programming | 3 | August 4th 08 02:07 PM |
| Formula in macro causes macro to fail | KCK | Excel Programming | 2 | February 8th 07 08:47 PM |
| Formula expected end of statement error, typing formula into cell as part of VBA macro | [email protected] | Excel Programming | 1 | July 20th 06 07:58 PM |
Linear Mode
