macro find value and insert new row in last value found.

**feroguz** · 11-16-2012, 07:03 PM

Hi good afternoon!!

Dear Users, I'm trying to create a macro that takes the Select value in "A4:A" range & insert me a new row in the last value to found in "C9:C" range and if possible put me "S" in "E4:E" RANGE..
it's possible??Find Value and add row in last value.xlsm
Attached is a workbook with a before and after example of what I'm trying to do.

Thanks again for all..

Best Regards!

**jeffreybrown** · 11-16-2012, 08:47 PM

Since the values in A4:A6 match the groups of rows in column C, then doesn't seem like a match needs to take place; rather, just a simple insert rows when column C values change.

Try...

Please Login or Register  to view this content.

**HSV** · 11-16-2012, 09:39 PM

Or:

Please Login or Register  to view this content.

**feroguz** · 11-19-2012, 02:10 PM

Hi jeffrey & HSV!

Good Morning!, thanks a lot!!

I customize the code, and works fine!

This is the code:

Please Login or Register  to view this content.

Best Regards!!

**jeffreybrown** · 11-19-2012, 02:36 PM

Very happy to hear it worked out for you and we are glad to have helped. Thanks for the feedback.

Please don't forget to mark your thread as sloved.

macro find value and insert new row in last value found.

LinkBack

Thread Tools

Rate This Thread

Display

macro find value and insert new row in last value found.

Re: macro find value and insert new row in last value found.

Re: macro find value and insert new row in last value found.

Re: macro find value and insert new row in last value found.

Re: macro find value and insert new row in last value found.

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions