Woah...
Ok, option 1 I think I can handle... basically, have a second worksheet
or second workbook for the presentation side. Do a bunch of linked
columns/cells and impose the formatting there? As I refresh the
(source) workbook/sheet it automatically carries over.
More work, but It's in my latitude.
Option 3: We use a business software called FACTS. It's not the
friendliest program around but allows for ODBC, as I am using it right
now. Correct me if I am wrong, but what you are saying is: during the
database query, "view data or edit in ms query"? and give it my SQL
commands there?
--
fncuis
------------------------------------------------------------------------
fncuis's Profile:
http://www.excelforum.com/member.php...o&userid=26466
View this thread:
http://www.excelforum.com/showthread...hreadid=397329