Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Paste Values
Hi,
I have a file with about 10 worksheets in it, each with a lot of data, formulas, macros etc - as a result the file is a chunky 16MB. In order not to take up huge amounts of space when the file is updated every week I could like to save all the data formatted in exactly the same way etc but without the formulas and macros into another separate file. I can create a macro to do a copy/paste special values into another pre assigned file with the same layout and no macros - thats no problem. However it is, or will be a long long macro which means if I need to change it will be a nightmare. Is there any quicker way of doing this? Thanks LiAD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change paste to only paste values | Excel Programming | |||
find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
can you change the default paste method? (paste values) | Excel Discussion (Misc queries) | |||
Auto-lookup values between Sheet3 & UserForm & paste to Sheet1 | Excel Programming | |||
How do i compare values from two sheet and copy & paste if values match? | Excel Programming |