Microsoft Excel 2013
- by Dan LaMoreaux
We use a spreadsheet as our timecards. The template is stores on the server with links to it on the individual Desktops.
I am trying to figgure out the VB so that wnen the cell for username (B5) is blank, the VB will place next sundays date in (B7). After the user enters thier name in B5, I need it to not change B7 again.
If I use a formula in B7 "=IF(B5="",TODAY()+8-WEEKDAY(TODAY()),B7)" i need to enable the curcular calcualtions, which don't follow from the template to the spreadsheet, thus causing errors for every individual.
Corporate says that they need to be in Excel, because of the import software. Otherwise I'd use Word and the "CreateDate" function.
I've been trying to learn the VB to do it, but I was hoping that soem expert could whip out the code in 5 min. flat and just let me disect it.