Excel question

marine1

marine1

Honorary Master
Joined
Sep 4, 2006
Messages
50,636
Reaction score
3,182
Location
A black hole in the universe - JHB
Hey Excel gods,
Need some advice on something.

I am just learning all the advanced feature so do not know everything yet :)

I have a spreadsheet with details on the sheet.
I use it for staff wanting to borrow money and then at the end of the month, I subtract those loans of their pay.

Now, having a manager there, I do not want him to be able to delete anything but just to add.

So for example, I have at the top, a name, then underneath, I put in each amount throughout the day.
At the bottom is the subtotal.

Is this at all possible?
 
Depends on the version of Excel,easiest way to check how to do it in yours is to press F1 then type "Protect worksheet"
Has the functionality you want and more
 
I am using 2010, what I am trying to understand is, is it possible to allow someone to enter something but not delete?
So for example, my manager enters joe soap borrowed R50 and he clicks enter, then once clicked enter, I do not want him to be able to go back and delete.
 
This generally isn't possible to my knowledge unless you are using a programme which automatically captures information to the excel file. You can then set the access profile of the individual users only allowing them to add and not remove.

What I could suggest (as an auditor) is that you keep the master copy of the schedule. Everyday your managers can capture loans onto a schedule of their own which they send to you at te end of the day and you update your master schedule. This would be an effective control and provides an audit trail.

This should be a daily or weekly control and managers should always send you a schedule, even if there are no loans made (it will be blank) which you keep electronically for your records.
 
Why don't you use a Google Docs form instead of a spreadsheet?

The manager enters the information, which is captured to a spreadsheet (which only you can view).

Let me know if you need help doing this.
 
How many staff members do you have? If not too many the easiest is going to have a form for each one, check link

You can always make a HTML page with links to each staff member to make it easier to enter the data.
 
marine1 said:
But he can still delete the information, that is what concerns me
Click to expand...

Please check the link that I have posted, the manager cannot see the spreadsheet, only the owner of the document with the Gmail username and password can log into Google Docs and retrieve the spreadsheet.
 
marine1 said:
WTF???? How in god's name did you do that?? I have never seen that before. :eek:
Click to expand...

Google Docs, check out: docs.google.com in the top left corner click Create and then Form. Not many people know about this I believe.
 
marine1 said:
Just a quick one, how would one get the responses to be mailed through to myself as it is recorded?
Click to expand...

Check your profile/account settings and choose the subscribe to threads you reply to by default... Something along those lines
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X