The macro I have has a "Dim sAcct, sAddress, sBillCode As String"
I need to take the sAcct and add today's date to it in this format "mmddyyy".
Example: ABCD = sAcct so it needs to be like this ABCD10052014.
If someone needs to whole macro I will upload it.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…