E
ExcelMonkey
I have a very large model. I routinely create a summary file and paste
special data/formats into it. The problem is that the large model has custom
views which are needed in the summary file. However, as I understand it,
there isn't a way to export those custom views into the summary file.
Is this easiest way around this to write a macro in VBA which takes my first
file, copy and paste specials data in the sheets I do want to keep, delete
all the sheets I do not want and rename as summary file. This would allow me
to keep the custom views of the original file and have a summary file.
Or is there a better way?
Thanks
EM
special data/formats into it. The problem is that the large model has custom
views which are needed in the summary file. However, as I understand it,
there isn't a way to export those custom views into the summary file.
Is this easiest way around this to write a macro in VBA which takes my first
file, copy and paste specials data in the sheets I do want to keep, delete
all the sheets I do not want and rename as summary file. This would allow me
to keep the custom views of the original file and have a summary file.
Or is there a better way?
Thanks
EM