5itface
asked on
Looking for a great Windows OS Patching template (preferably in Excel).
We just starting with patching in our environment. We are using WSUS, but I am not happy with the reporting that WSUS provide. I want to create a master sheet in excel that will show details of what we have patched, and was wondering if there are any good template out there where I can download. A template that will break items down in columns, etc. Can someone point me in the right direction? I've seen a few online, but they are not that detailed.
ASKER
Just an excel template that I can download and modify myself. Anything you can recommend. Something with Drop down selection and stuff. What I do need is a calendar pop up to where I click and a calendar pops-up to allow me to select a date. Maybe you can create something and hand off to me? 500 points in it for you. Thanks.
500 points in it for you
Verry inappropriate comment, we are not in a bazar here.
You specify clearly what you want and Experts propose solutions for you and when you are satisfied you close the question that could be beneficial for lots of people having the same issue as these are posted on the www
So please post a workbook specifying the fields you want and what you are after and will be glad to develop this.
Regards
gowflow
ASKER
I just need a template that has a simple function: the calendar pop-up. If you can create just a column for that, I think i can fill in the rest. I just don't know how to create that.
Something like the example here would be ideal:
http://www.fontstuff.com/vba/vbatut07.htm
Something like the example here would be ideal:
http://www.fontstuff.com/vba/vbatut07.htm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Any chance to have tried out the proposed solution ?
gowflow
gowflow
ASKER
The template you sent me does not work. I've attached a template so that you can modify and sent back to me. I want the date to populate for the following column: Scan Date, PatchDate. For the following column: Installed Patch Count, Missing Patch Count, Missing service Pack, I want it modified to have a drop down to select from 0-100. Thank you.
Patch-master-list.xlsx
Patch-master-list.xlsx
what excel version you have?
gowflow
gowflow
ASKER
2010.
When you say that the solution I provided does not work, would you be kind enough and considerate to advise what is the problem so we fix it for you ?
Remmeber we DO NOT WORK for you !!!! we are all Experts that do this work FREE OF CHARGE and just to gain experience.
So please be kind enough to give feedback instead of instructions.
gowflow
Remmeber we DO NOT WORK for you !!!! we are all Experts that do this work FREE OF CHARGE and just to gain experience.
So please be kind enough to give feedback instead of instructions.
gowflow
a great Windows OS Patching template
Can you post a sample of the data you have to understand better what you want ?
gowflow