Lester
10-24-2007, 06:24 AM
Hi
[I asked this question embedded within another thread, but maybe it should have a thread of its own, so here goes...]
I have created a macro and a PivotTable for displaying some data in an excel application.
Now, does anyone know what is the best way (if at all possible) to be able to use this new macro/pivotTable on a different (source) data file?
What would be the best way to do this? Would it be possible to 'import' the new source data into the existing file containing the macro, then re-run the macro against the new data? How about the PivotTable? Would that also be regenerated with the new set of input data?
I'm not sure the best way of utilising the macro/table for other sets of data that have the same 'structure' as my original set of data.
Any ideas? Please let me know.
Many thanks
Lester.
[I asked this question embedded within another thread, but maybe it should have a thread of its own, so here goes...]
I have created a macro and a PivotTable for displaying some data in an excel application.
Now, does anyone know what is the best way (if at all possible) to be able to use this new macro/pivotTable on a different (source) data file?
What would be the best way to do this? Would it be possible to 'import' the new source data into the existing file containing the macro, then re-run the macro against the new data? How about the PivotTable? Would that also be regenerated with the new set of input data?
I'm not sure the best way of utilising the macro/table for other sets of data that have the same 'structure' as my original set of data.
Any ideas? Please let me know.
Many thanks
Lester.