Macro to update cell (should be easy)

**Leinad7** · 04-04-2013, 03:33 PM

Hi There,

I need a macro to update columns B4:B6 depending on cells E12:E14. Cells B4:B6 would ONLY be updated if the corresponding 'pet' exists in A12:A14.

I've attached my example. This sounds VERY simple to do, I'm just not sure what functions or coding I need.

Thanks!!

Update Macro Help.xls

**jomili** · 04-04-2013, 04:06 PM

I think this is what you need. Paste this code in the sheet module (see attached for working model).

Please Login or Register  to view this content.

**xladept** · 04-04-2013, 04:16 PM

Hi Leinad,

Here's a short routine for the update part:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

**jomili** · 04-04-2013, 04:19 PM

Wait, I may have misunderstood the problem. The solution I posted updates B4 when C12 is updated. But I think that's not what you're looking for.

**Leinad7** · 04-05-2013, 03:28 PM

Oh my goodness xladept! Amazing - exactly what I asked for! Now - I need to figure out how to change the 'directory' of my list to another location

. At least I have the codes to go by and start to understand what they mean.

**xladept** · 04-05-2013, 03:44 PM

Great! You're welcome! Glad that you're "getting" it!

**Leinad7** · 04-05-2013, 03:59 PM

Actually, how would I modify this code to have the updates occur in a different sheet. Do I need to put "Worksheet!" before the ranges?

Thanks!

**xladept** · 04-05-2013, 04:10 PM

Hi Leinad,

Please Login or Register  to view this content.

And, there are other ways to do it: if you just wanted every sheet in the book - you could use the For Each...Next:

Please Login or Register  to view this content.

Macro to update cell (should be easy)

LinkBack

Thread Tools

Rate This Thread

Display

Macro to update cell (should be easy)

Re: Macro to update cell (should be easy)

Re: Macro to update cell (should be easy)

Re: Macro to update cell (should be easy)

Re: Macro to update cell (should be easy)

Re: Macro to update cell (should be easy)

Re: Macro to update cell (should be easy)

Re: Macro to update cell (should be easy)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions