Extract and Save

I am a complete newbie to Excel programming and Macros, but I have
problem. Think of it as a challenge.

I have a bretty basic excel worksheet.

Column A - Advertiser
Column B - Advertiser Line Item
Columns C-E - Other data pertaining to line items
Column D - Revenue

I have used the subtotal function to subtotal the revenue by advertise
and instert page breaks between subtotals. Easy.

What I would like to do is extract all advertiser line items b
advertiser and save it into a new file that is named with the name o
the advertiser. I would even love it if I could save it into
template to have it formatted.

These are going to be attached to advertiser invoices that we email ou
to our clients. Right now we cut and paste. Takes a long time.

Could this be done easily with the DigDB toolkit?

Thanks in Advance for the help.

Jos

--
joshuacohe
-----------------------------------------------------------------------
joshuacohen's Profile: http://www.excelforum.com/member.php...fo&userid=3430
View this thread: http://www.excelforum.com/showthread.php?threadid=54073