Search results for query: *

Hi I need to be able to stop my users amending historical data once the workbook is saved. Is there a way of locking the cells on an 'autosave' or 'save' function? Many Thanks in advance

I have a spreadsheet with 5 columns, all data in these cells are dependant on conditional formatting to create a traffic light scenario. However I need the 6th column to 'count' the number of red cells in the row and if there is more than one instance, then format the 6th column cell as red. I...

lbass Much appreciated... this works perfectly.

lbass, my apologies for not replying sooner (out of office) - we run a 24hr operation here with shifts split from 05:00 to 21:00, however I was looking for analysis by day initially (eg Monday 05:00 - Tuesday 05:00) and then for complete weeks

Currently using Crystal Reports 8.5 If have two fields within a database (date) and (time)which are populated by wifi scanners. As a working shift covers from 21:00 to 05:00 the following day. I need to be able to produce a date/time range so I can analyse the number of scans across shifts. Any...

The working day here is 05:00 to 05:00 How do I select daily data based on this format. 05:00 hrs Monday to to 12:00 hrs Saturday?

Many Thanks for the quick responses. I went with LB's formulae, but cheers for both options.

Tech User... thats a laugh Probably a really basic solution but can anyone help...... I need to show a series of amounts by two date ranges for comparison... . Date 1 Date 2 Dept 1 Qty Qty I have created {@1st date range} in Date (2003, 10, 01) to...

My apologies.... Many Thanks

I am not an Access user but I have created a basic database with an autonumber primary key within the table. Due to testing etc the autonumber has obviously incremented accordingly. Is there a simple way of resetting this value to zero/01

Cheers for quick response, however how do I get over the problem of 'if the sender has tracking set in outlook, when an administrator opens it to view, the sender gets a message showing who has seen the sent item'

Is it possible to send copies of e-mails sent/received from multiple system e-mail adresses to one particular individual without them being 'tracked' by outlook when the e-mails are opened or read.