hi excel fans,
I'm having a little bit of problem in finding an 2007 Excel solution for the next issue:
I need to create some reports in Excel containing in a file with several spreadsheets having tha same fields but different data offcourse.
the data from these spreadsheets are obtained from a pivot table by double click on the records. so the data is automatically formated as a table in the spreadsheets.
usually I have like 20-30 spreasheets that I have to apply the same sorting criteria (on 3 fields). this is very time consuming and I tried to do a macro but i get a nasty error that i think has to do to the fact that the spreadsheets and tables names are different.
the number of rows in the spreadsheets are at most 200.
could you please give me some advise?
I don't know if this is possible but it would be wonderfull if the macro would work for all the spreadsheets I'm selecting at once and not one at a time.
thank you, looking forward for your replies
,neveu
I'm having a little bit of problem in finding an 2007 Excel solution for the next issue:
I need to create some reports in Excel containing in a file with several spreadsheets having tha same fields but different data offcourse.
the data from these spreadsheets are obtained from a pivot table by double click on the records. so the data is automatically formated as a table in the spreadsheets.
usually I have like 20-30 spreasheets that I have to apply the same sorting criteria (on 3 fields). this is very time consuming and I tried to do a macro but i get a nasty error that i think has to do to the fact that the spreadsheets and tables names are different.
the number of rows in the spreadsheets are at most 200.
could you please give me some advise?
I don't know if this is possible but it would be wonderfull if the macro would work for all the spreadsheets I'm selecting at once and not one at a time.
thank you, looking forward for your replies
,neveu