Hello,
My client wants to have an Income Stmt created in FRX to export to an excel spreadsheet with each month of the year as a seperate worksheet. So the spreadsheet name would be IS 2006 and each worksheet would be a month July, August etc. I am having trouble getting this to work - Trees don't have a date option and they don't want a column per month as they have a lot of budget and variance columns (the report was to big). I thought I could create a catalog for each month and then set the export path to the specific worksheet but i can't get that to work -- any ideas???
They don't want to cut/paste and they are not comfortable with Macros's
Thank you,
Dan Bigelow
My client wants to have an Income Stmt created in FRX to export to an excel spreadsheet with each month of the year as a seperate worksheet. So the spreadsheet name would be IS 2006 and each worksheet would be a month July, August etc. I am having trouble getting this to work - Trees don't have a date option and they don't want a column per month as they have a lot of budget and variance columns (the report was to big). I thought I could create a catalog for each month and then set the export path to the specific worksheet but i can't get that to work -- any ideas???
They don't want to cut/paste and they are not comfortable with Macros's
Thank you,
Dan Bigelow