[hglover]

Does anyone know how to copy data via 1 excel workbook into a new one... keeping all the formulas and formats; while replacing the original data values with zero's? This is for a payroll related file, I need to create a new file for the upcoming budget period... I will not have major changes to workbook... The data values will change!

[Advertisements]

hglover,
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
Open 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


regards
dsm

Attached Files

•  GTG_hglover.txt   2.51KB   153 downloads

[dsm]

hglover,
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
Open 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


regards
dsm

Attached Files

•  GTG_hglover.txt   2.51KB   153 downloads