Auto Copy from one tab to another...

**H-Man3** · 04-20-2012, 10:20 AM

In the Summary tab is a list of producers. (Column K)

I need to Identify the Producer and copy/paste his complete row of information to the corresponding tab.

I was messing with Formulas, but i cant get it to do what i want. I was thinking Macro....but this is where im stuck.

Please help..

thanks

**Mallycat** · 04-21-2012, 04:12 AM

I think it would be better to leave the data in the summary sheet, and use filters. Presumably you are looking for totals for each producer

**arlu1201** · 04-21-2012, 05:45 AM

Your summary tab has a lot of empty cells. For e.g. A4:D5. A macro can do the work for you easily, if you have all the columns filled up for your dataset.