Nice!.....But can it make me a cup of tea?

[dave3009]

Hi Everyone

At the start of this year I knew very little about the full potential of Excel, in fact I think my knowledge extended to SUM, SUBTOTAL, COUNTIF in terms of formula and basic cell formatting if I was lucky.

I have been working in the same place for 3+ years and I was getting a little p'd off with the huge amount of admin we had to do. There seemed to be spreadsheets to check spreadsheets and other ones for those too. I got to a point where I was sick of sending book after book to my manager for them to have to manually update their book for them to send it on (and so on and so on). So I marched myself to my nearest book shop and invested in a range of materials to teach me Excel.

After I got the basic bit out the way I then discovered VBA which in turn lead me back to the book shop to invest in yet more material. Then once I had read through all that I searched the internet and swiftly sign up to this site.

From all of my learning (and help from this site for a full list of people I want to thank click on 'Memberlist') I fully automated the previous process down to everyone just having a single book to work from, all automated, all able to customise the way they looked at data etc. I decided it was time to show my manager what I had done in hope of his approval (after all I was expecting each sales rep to save about 2 hours admin time and the managers around 16 per week) and approval I got.

I then went to roll it out at a sales meeting. I went through the automated process and all the features and benefits (as a salesman does) and everyone seemed extremely happy with the new system.

Then for the back of the room our MD says "Can it make me a cup of tea? I'll use it if it can". Just imagine the foul language that was muttered under my breath.

The system got used without the need for the MD to get a cup of tea, but I really wanted to see if anyone had been given the most useless and ridiculous request for spreadsheet feature. More so I would be interested to see if anyone actually built them in just to show someone up?

Cheers


Dave

 

[Smitty]

Check out the Good Excel Practical Jokes, Pranks, Mean Tricks, etc. post.

Can it make me a cup of tea?

No, but you can make the SOB's "cup holder" open and close (among other things...).

Smitty

 

[dave3009]

Hi Smitty

It was not really about playing pranks on someone, more getting comeupance on someone. For example:

"I have rebuilt this book system to incorporate your requests and yes (Mr MD) it can make you a cup of tea"

I did spend alot of time mopping up after reading the posts in the afore mentioned post and trying out the codes, most of the posts in the Lounge have me in fits of laughter.

Thanks for responding to my first Lounge post

Dave

(dave3009 is my nickname which is my real name plus birthday. I choose this because dave is almost always taken for any forum I join up to)