Run a search and replace based on what is in another Cell?

**cekenney** · 09-28-2012, 12:14 PM

Basically I have two sheets.

Sheet 1 changes monthly. It has a list of names in column A and their associated emails in column B. New Names and Emails are added and taken off and existing emails change.
Sheet 2 comes in daily and has just the list of names.

I need to figure out a macro that will look at sheet 1, look at a cell in column A, take the name that is in that cell.
Search for that name in Sheet 2, then replace that name in sheet 2 with the email(column B) from sheet 1 associated with that name.

It's quite all right if I need to merge the two sheets to accomplish this, but it would be preferable to keep them separate.

**rvasquez** · 09-28-2012, 12:37 PM

Hello there,

When do you want this action to take place? On change of a cell in worksheet 1, on add new worksheet?, on button press?

Thanks!

**cekenney** · 09-28-2012, 02:14 PM

Really just when the macro is run. So on a shortcut key press or a button would work as well.

**Bishonen** · 09-28-2012, 02:51 PM

very bad code, but it works ^^

Please Login or Register  to view this content.

**cekenney** · 09-28-2012, 03:07 PM

Originally Posted by Bishonen

very bad code, but it works ^^

Please Login or Register  to view this content.

How would I change this if I simply wanted to do it from 2 different sheets within the same workbook?

**Bishonen** · 09-28-2012, 03:13 PM

Originally Posted by cekenney

How would I change this if I simply wanted to do it from 2 different sheets within the same workbook?

Please Login or Register  to view this content.

**cekenney** · 09-28-2012, 03:17 PM

wow! worked like a charm thanks so much!

Run a search and replace based on what is in another Cell?

LinkBack

Thread Tools

Rate This Thread

Display

Run a search and replace based on what is in another Cell?

Re: Run a search and replace based on what is in another Cell?

Re: Run a search and replace based on what is in another Cell?

Re: Run a search and replace based on what is in another Cell?

Re: Run a search and replace based on what is in another Cell?

Re: Run a search and replace based on what is in another Cell?

Re: Run a search and replace based on what is in another Cell?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions