Copying entire rows of data if a cell meets certain criteria

**dmchase** · 05-08-2012, 04:00 PM

I need to create an excel macro that searches through a document and if a cell in column A matches a certain name, for example "Name1" then I need it to put the corresponding row into sheet 2. There will be multiple rows that match this criteria. I also need it search column A and anything with "Name2" put that in Sheet3, and so on...

There are approximately 11 different values that I need the macro to do this for, and copy all the corresponding rows into the appropriate sheet. I would greatly appreciate any assistance that anyone can offer.

Thank you.

**micope21** · 05-08-2012, 04:31 PM

Something like this?

Click attachment

Click view/Macros/view Macros/Run

**dmchase** · 05-08-2012, 04:41 PM

This is incredible. Just exactly what I needed. Thank you so much!

**micope21** · 05-08-2012, 04:45 PM

You welcome!

Cheers

**dmchase** · 05-08-2012, 04:57 PM

Quick update question:

Is it possible to make the macro update the values instead of copying them twice if I run it twice? For instance in your spreadsheet, what if the dollar amounts changed and I wanted to update all the other sheets. If I run it twice it simply copies them again.

Thank you!

**micope21** · 05-08-2012, 05:59 PM

Hi

I'm only simple Vba. I would not know how to solved that. I only starting to learn 2 month ago. Long way to go lol.

There is other workbook does in formula instead vba.

here a attachment.

You work on Master. You see 4 Name tab.

If new name. just click right on tab see move or copy click name1 and tick create a copy.
click on tab and change new name match master sheet then on B1 with highlight yellow cell same again change name. that it will come on automatic.

Master sheet up to 1000 row. If need more copy on A to P column and row 1000 carry on till where you want it.

Name 1 to 4 up to row 600.

let me know what you think?

**dmchase** · 05-09-2012, 11:13 AM

LOVING! Thanks yet again!

**gomaa1239** · 04-06-2016, 09:24 AM

i have something different coul dyou please help me

i have a full 2 month dates in row A and i have a numbers at the rest of rows (b,c,d, etc) and i need to write in column B and c the dates from - to ( 07.04.16 to 11.04.16) if i have number 3 in the other rows

name----from date---- to date-----07.04.16----08.04.16----09.04.16----10.04.16----11.04.16----12.04.16----13.04.16
jac------------------------------------3-----------3-----------3------------3----------2-----------5-----------7
ali-------------------------------------5-----------3-----------3------------3----------2-----------5-----------7
joe------------------------------------3-----------3-----------5------------3----------3-----------3-----------3

results should be

name----from date---- to date-----07.04.16----08.04.16----09.04.16----10.04.16----11.04.16----12.04.16----13.04.16
jac------07.04.16-----10.04.16---------3-----------3-----------3------------3----------2-----------5-----------7
ali-------08.04.16-----10.04.16---------5-----------3-----------3------------3----------2-----------5-----------7
joe-------------------------3-----------3-----------5------------3----------3-----------3-----------3-----------5

in the last row i need to have 4 columns (can i do this or not)

thanks in advance for your help