Could you help me with using Excel?

[mangoh]

All the things I need help with have been mentioned on the Excel document.

I created a example spreadsheet.

Please could someone help?

https://www.dropbox.com/s/6ns561feblzolaj/example.xlsx

 

[TanyaC]

Hi,

To see today's day use the function =Today() and under format cells select a custom format and put in 4 d's. Eg. dddd. That will make the cell show the day of the week.

To have multiple people able to access the spreadsheet at the same time go to Review > Share Workbook, and tick the check box for "allow multiple users to update..."

Then click on the advanced tab. Under Update changes select "Automatically" and set the number of minutes you would like the spreadsheet updated.

hth
Tanya

 

[mangoh]

Hi,

To see today's day use the function =Today() and under format cells select a custom format and put in 4 d's. Eg. dddd. That will make the cell show the day of the week.

To have multiple people able to access the spreadsheet at the same time go to Review > Share Workbook, and tick the check box for "allow multiple users to update..."

Then click on the advanced tab. Under Update changes select "Automatically" and set the number of minutes you would like the spreadsheet updated.

hth
Tanya

Thank you for your response.

Anyone know the answers to the other questions?

Also the answer to this additional question...

I created an in cell drop-down menu, you only realise it is a drop-down menu when you click the cell as the down arrow shows.

Is it possible to have the down arrow showing permanently so users are aware it is a drop-down menu before actually clicking the cell.

 

[TanyaC]

Anyone know the answers to the other questions?

I thought I'd covered all of them. What did I miss?

I created an in cell drop-down menu, you only realise it is a drop-down menu when you click the cell as the down arrow shows.

Is it possible to have the down arrow showing permanently so users are aware it is a drop-down menu before actually clicking the cell.

Using data validation "list" - No you can't. Using form controls and VBA code, yes you can.

I generally just insert a down arrow in the adjacent cell, and use a description of "Select xyz:" so it becomes apparent that it is a select list. I agree, it is a pain in the bum.

 

[mangoh]

Anyone know the answers to the other questions?

I thought I'd covered all of them. What did I miss?

I created an in cell drop-down menu, you only realise it is a drop-down menu when you click the cell as the down arrow shows.

Is it possible to have the down arrow showing permanently so users are aware it is a drop-down menu before actually clicking the cell.

Using data validation "list" - No you can't. Using form controls and VBA code, yes you can.

I generally just insert a down arrow in the adjacent cell, and use a description of "Select xyz:" so it becomes apparent that it is a select list. I agree, it is a pain in the bum.

Erm the refresh button as the idea is a user presses this button prior to making a call as then it shows them if someone is available.

Also any ideas on automatic input for availability.

Also thanks, I'll use a combo box for the drop-down menu.

 

[TanyaC]

Hi,

Sorry, I thought the auto update interval on the sharing dialogue would suit your needs. Since, every time it updates the workbook, it also refreshes what you see (that is, it behaves exactly like a refresh button).

Look at the image below; The "And see others' changes". This is effectively a refresh option.

A refresh button can be achieved using VBA code. What it would do is load the worksheet from it source location. But since it is possible there are unsaved changes, it must first save the workbook.

The code would go something like this...

'below code for saving and closing the workbook
Workbooks("book1.xls").Activate
ActiveWorkbook.Save
ActiveWorkbook.Close

'opening workbook
Workbooks.Open Filename:="c:\book1.xls"

---
You must activate it before attempting to close it. Insert full path to file name.

Now, as to automatically inputting availability;

This implies that there is a fixed availability list. Where does this availability come from? If it's automatic it has to be stored somewhere. If it's static you would just update it and save the sheet.

If you want them to have the same availability for the whole week, then just get them to enter the first day and use formulas to replicate the availability across the rest of the week.

If I am on the wrong track, please explain what you mean by "automatic availability".


Tanya