Hi All
I have tried my hand at using Excel 2007 to write up a stock control programme
I used sub sheets within the worksheet from day 1 to day 31
Each month I have to erase the data that is entered and I do it manually
I would like to no if it woulkd be possible to automate teach sheet to erase data without changing the formula
All hlp and advice will be higfhly appreciated
This macro can be run to reset all the manual numbers entered into columnc C:E on all sheets:
Please Login or Register to view this content.
...or if protection is involved:
Please Login or Register to view this content.
Last edited by JBeaucaire; 07-01-2012 at 04:31 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi Mr Jerry
Thank you very much it really worked like magic
How may I modify the macros to iclude column I and columns R to T
Many thanx for your help
Edited above.
If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks