Search results for query: *

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

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

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...

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...

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...

Hi, I am trying to do a vlookup between 2 worksheets but the value is coming back as #N/A The source worksheet supplying the data has a problem with the its pairing column. If I enter the cell at the rightside of the number and click the delete button the vlookup works. Is there a quick way...

Hi, I have column that has an array of different numbers that denote order references, these numbers range in size. The first 2 digits of each number indicates the location where the order was placed. If I have a number in this column that begins with "20" I would like to do a find and...

Hi, I have a column of numbers ranging from 1 to 15. Each number indicates a location name. I would like to conducted a find/replace on each of these numbers and change it to the location name. e.g. the number "1" becomes "London" If I try to find the number "1" its replaces every "1" in the...

Hi, I have a worksheet(Sheet1) that contains a cell(B22) with a formula adding up values in a column. In another worksheet in another cell I want to copy over the value from cell(B22), I type =!Sheet1(B22)but all I get is 0.00 and not the correct value. If I paste special the value from the...

Hi, To get the value from cell A1 in sheet 1 to appear in Sheet 2 I would use =Sheet1!A1 I have a sheet called Loss Notification and I am trying to take values from cells from this sheet into Sheet2 using the same method as above. Why I try this I only get the formula appear in the cell and...

Just imported a report in to excel from a txt file, in one of the columns the numbers appear with a minus at the end. The minus needs to appear at the front so as to read it properly for calculations. How can this be changed correctly. Please help. Thanks

If I have a list of headers in a column is it to convert them in the row headers....example. i have Week 1 Week 2 Week 3 Would like this in rows like Week 1 Week 2 Week 3 Easily done without cut and paste?

I have downloaded the latest updates for Acrobat 5.05 but I cannot seem to get the acrobat menu to appear in the Office XP version of Word or Excel, am I missing something? I have acrobat 6 standard but this doesn't have the batch processing function that I do use in the 5.05 pro version. Is...

I have a raw report that requires formatting to become the finished article. I can use recorded macros for most of it. With the report I need to delete every row with 'No' in a certain column, the number of rows changes with every report so a simple recorded macro wouldn't work. How can I can...

I have a brand new machine with Windows Xp SP2 installed. In Explorer when you click on the search button, explorer crashes back to the desktop. The error in the Event viewer is a little vague but the info is Event Id is 1000 File is Explorer.exe The faulting module is unknown I have look on...

Is this possible to access an Access report by using a link from say Word? I know you can have a startup menu in Access that can have buttons to the reports but I was after a link that could go straight into the report. Any ideas? Thanks

Trying to delete lines from a list of Account names, I have tried using the link below 240077 - Macro Examples to Delete Duplicate Items in a List http://support.microsoft.com/default.aspx?scid=kb;en-us... but I get this error. Runtime Error 9 Subscript out of range.

Trying to create a formula that looks at a cell and depending on whats in there looks up a certain data range. In the cell I would either type in COST or REV. If I typed in COST then a VLOOKUP further down the sheet would only look at a cell range. Im okay with the vlookup its incorporating...