Quote:
Originally Posted by dwanthny
So exporting the catalog as a CSV file won't do what you're looking for?
|
That works, particularly with a macro grabbing the csv data and putting it on a spreadsheet. I have the latter set up nicely for printing. The problem is that the easy way I did the macro and formulas, it's fine as is but clunky and time consuming to reset the sheet to a different column order or new custom columns. I'm not certain scripting can handle those changes, at least with my rusty scripting skills. So I started looking for a better way to deal with changes like that.
(The original catalog.csv file has unformatted data with the columns in alpha order. So the spreadsheet is set to switch columns around.)