I work in a newspaper advertising department and use Excel to keep a
list of ads that will appear in our newspaper. It contains the
advertiser's name, column width and length of the ads. We currently use
the Excel list as a reference to create the page layout by hand - Yes,
old-fashioned pencil and paper! I'd like be able to use the Excel
program itself to create the layout or import the Excel data into a
compatible program to create the "map" of the ads and show where we
want them to appear. They only need to appear as blank boxes in the
appropriate sizes (with the advertiser's name if possible). It would
work best if I could move the boxes around on a template that
represents the news pages.

I know there are some very expensive publishing programs out there that
can do this translating of size data into shapes (like ALS, AdForce,
etc.), but our company has no plans to purchase at this time. Anyone
know of a way to get Excel to create something like this, or of a MS
Office program that can interface with my Excel list to accomplish
this?

I'd very much appreciate feedback!

Thanks! :)


--
adgal
------------------------------------------------------------------------
adgal's Profile: http://www.excelforum.com/member.php...o&userid=29976
View this thread: http://www.excelforum.com/showthread...hreadid=496688