Miscellaneous Techie Help Required in Excel

Halfers

Finger Flapper
Messages
2,314
Location
Hampshire
I'm sure there are some appropriately experienced people around to help me with a Microsoft Excel query!

I'm putting together a Training/Competency Matrix for one of my Customers. I want to add a cell on the workbook that automatically adds the date every time the Spreadsheet is revised/updated.

I've googled and found a couple of formulas and tried them on a spreadsheet, but they don't seem to work. Wondering if anyone might be able to suggest anything?
 
Does that do what you want?. it updates whatever change you make.
Trying to work out how to update and store the date when a specific change is made in particular cells.

Yes, that's all that's required. The Document will have revision control and Access by password, so it's just a case of evidencing that the doc is reviewed periodically. There's no need to record any individual updates, so that works fine for me.
 
One of the challenges I have in my day job is convincing the younger element, who now use GUI code generators to build code rather than writing code, is that simplicity beats clever overly complex solutions every time. They get very upset when I suggest that their badly performing, inefficient and bloated code would work better without the magic unicorn hyperdrive options and silver bullet options...

I had a classic one a few years ago where it was essential that the end-to-end performance over the network was sub 200ms. They were getting responses between at best 500ms and up to 3 minutes. When I reviewed their scripts which they'd been trying to get working for some weeks and I chopped it in 4, pencilled in some very simple changes etc they were every unhappy. They wanted me to list all kinds of gee-whizz techie solutions, not back-to-basics stuff... I insisted on my recommendations being tried first. I won the argument as it ran consistently at under 50ms.

Moral of the story: simple solutions usually work.
 

Similar threads... or are they? Maybe not but they could be worth reading anyway 😀

Social

New! Social Feeds

Look out for the navigation icon:

Follow CafeSaxophone

Latest Song of the Month

Trending

Forum statistics

Topics
32,075
Messages
578,662
Members
8,134
Latest member
banjo
Back
Top Bottom