How to enter last saved date in Excel workbook
I am using Office Pro Plus 2010 and I wanted to have the last saved date displayed in my document for my records. I found this simple method:
Sheets(“Sheet1”).Range(“A1”).Value = Now
End Sub
I am using Office Pro Plus 2010 and I wanted to have the last saved date displayed in my document for my records. I found this simple method:
Copying from bank statement, issue with all the date copying to a single cell and not into individual cells. The tedious workaround was to copy into MS Word and add a semicolon (or other) after each cell data. Then copy the date to Excel then: Data > Text To Columns > Delimited > ; > Finish I…
I have been trying to install WHS2011 on my HP Proliant Micrserver N40L for a couple of days. I installed it on the supplied HDD but ran out of space. After some investigation I found that WHS had made a 60GB system partition and the remainder of the 250gb hdd was spare. I was planning…
Windows 7 refused to connect to local PCs on the network saying network discovery was disabled and I need to turn it on. I turned it on and restarted but still no joy. I tried several things including registry permissions but the issue was with windows firewall. I had to manually create a new rule…
I had some issues with Kaspersky AV and Outlook 2010. I launched Outlook in safe mode by holding ctrl and then launching Outlook – didn’t solve my issue but something new for me.
Making a list of product SKUs, trying to avoid duplicates. Found this data validation post Click on Data tab>Data Validation Icon Click on the Allow: drop down and change to Custom In Formula field enter: =COUNTIF($A$2:$A$1500,A5)=1 A2 being the start and A1500 being the end of the list. Explanation: The COUNTIF function takes two arguments….
Sorting is not working properly with default template, this should work but I am yet to figure out exactly how to implement for invoice number sorting: Select the statement that you want to edit and open the report designer.Add Section Audit Header DateAdd Section Audit Header Header NumberYou will now have duplicated – Audit Header…