Excel -Paste Special
Posted 15 August 2005 - 01:35 PM
Posted 23 December 2006 - 03:34 AM
I think the only way you can acheive the desired result is with a customised script.
I have written the attached VBA script that could be used for the purpose.
If you have a file named BudgetDec.xls simply save as BudgetJan.xls
Use Alt+F11 or from the menu... Tools > Macro > Visual Basic Editor to open the VBA Editor
from the menu... Insert > Module
Double Click the last module
Copy the contents of the attached txt file into the last module
Go to the worksheet to be cleared
from the menu... Tools > Macro > Macros > MacForHglover > Run
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users