Recent content by Airbiskit

Hi, We have a shared inbox that when viewed appears in the users inbox pane. Is there away of having both inbox panes appear, similar to the shared calendars where you can view numerous claendars on one page. Thanks Steve

Wonderful, thats works a treat. Thank you.

Hi, In column L4 I have the formula =SUM(24-H4+K4) In the next column I have the formula =IF(L4>24,L4-24,L4) Is there anyway of merging these 2 formulas so I don't need the extra column? Many Thanks Steve

Hi, In excel is it possible to in page break when a value in a column changes. For example we would like to insert page break after the employee name in Column A changes. Any ideas would be welcome. Thanks Steve

Thanks Arthur for you reply I have started to work though changing each argument but need help with something. In the argument below the True value is taken from the row cell in column K, how do I change the statement below to point to the row cell from column K going down the spreadsheet...

Hi, Can the amount of arguments in an IF statement be increased or do you know a work around? I have this IF Statement that I need to add a few more arguements to. =IF((AND(N230="WD",G230>=0,J230<=6,K230<=6,J230<>0)),K230, (IF((AND(N230="WD",G230=0,K230>6)),6...

Hi, I have a large spreadsheet that consists of the following Fields... Start Time, Finish Time, Total Hours. The Start Time and Finish time are in time format (eg "00:00:00"). I am trying to write an if statement on the lines of =IF(A1>00:00:00 AND B1<06:00:00, "Y", "N") Excel doesn't...

Thanks chaps, I will work through these solutions.

Also check which format the Outlook is using. Go to Tools menu, then Options, Go to the Mail format tab and see where it says compose in this message format. By changing this on the users machine to something like Rich or Plain text may help. Cheers Steve

I have been using Tek Tips for over 4 years and I think every post within the Office forum has had a reply from Skip. Very helpful and knowledgeable, thanks for your help.

Hi, From the Tools menu, go into Options. In the delegates tab, Add the user as a delegate and give them the desired permissions to your calendar. From their Outlook, go to File, then Open, then Other User's Folders. Enter your name and then select Calendar. That should do it. Thanks Steve

Thanks Skip, The information I need to process is name, skill and date. If I had one sheet that showed name in column A and all the skills across from say Column B to H. In Each field with a skill was a true or false value. In sheet 2 tha same layout but this time a date would be entered in...

Let me see if I can explain this clearly. I have a sheet that lists all our employee names in column A. In column B to L are headed by a type of skill. So against each employee they will have a "Yes" under their relevant skills. Some have the same skills. The second sheet is a timetable as...

Woohoo, no worries I worked it out. Change Value to Font... oCell.Font.Color = RGB(255, 100, 0) Thats worked Thanks Steve

Hi, I have used code from a previous Conditional Formatting question which works great, I have changed it to match my needs...nothing amazing I must add. But I am looking to change the text colour to match the interior colour property, so the hole cell is the same colour. Code is below with my...