New Ro Macros Please Help

**avila11** · 05-08-2013, 03:11 PM

So I have a worksheet that we send out and our managers fill out with a ton of data for our tracking,but theirs as well. Now we want to create a new sheet that pull data relevant to our needs with out affecting their original sheet. Basically if the criteria in one of the columns matches what we are looking for, I want all the column information associated with that row pulled to the new sheet. I want it to go through all 60 rows and return the ones we care about. In actually it's basically a consolidation because OUR new sheet will only have around 25 of the original 60. I'm very very new to Macros. Please help a dummy!

**NeedForExcel** · 05-08-2013, 03:13 PM

Can you attach a sample workbook?

**avila11** · 05-08-2013, 03:34 PM

Okay I attached a sample, I wan to pull only the ones that are Funded By North America. I want those certain rows to fill into my Sheet 2 (new sheet, sheet 1 is old sheet) whenever I run the macro. That way if the managers make up updates or add new ones, my macro will capture that when run.
Remember I am newb to macros....

**arlu1201** · 05-09-2013, 01:55 AM

Avila,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.