Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to copy rows and paste-special to another workbook
I need a macro that upon closing of the workbook will copy all the non-empty
rows of a specified worksheet, say "Sheet1" and paste only the values (paste-special, and not formula or links) to a specified sheet of another protected workbook. The destination workbook should be locked upon pasting the new values. Password can be embedded in the macro. I need to make this happen automatically without opening the destination workbook. Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Paste Special Values Workbook | Excel Programming | |||
Copy, Paste Special Values all sheets in workbook | Excel Programming | |||
How to copy formulas to a new workbook? Paste Special is different | Excel Worksheet Functions | |||
Copy Paste Special Macro | Excel Discussion (Misc queries) | |||
Select Range every 20 rows copy & paste special | Excel Programming |