Search results

Is it possible to sort the results of a pivot table? See attached file. The 2.5 NB pipe is right down the bottom with the 24 inch pipe. Also within the ranges, i.e. in the 4 inch range the 'schedule 80_' precedes 'schedule 40_'. I can foresee that if it is possible to sort the 'schedule 120'...

I have a concatenated value in Column S =CONCATENATE(P5,Q5,R5,N5) In column T I have the formula =LOOKUP(S5,$H$124:$H$2340,$Q$124:$Q$2340) I can see the concatenated value I want in column A ELBWSA 234 WPB1.5Sch80_ and this appears below in the H-Q range specified in the lookup...

Just a simple question about Windows XP Explorer background colour. I have changed the background colour so that the explorer window panes are not white - I have to stare at it all day and a very pale light green I find is a bit easier on the eyes. I went to Control Panel / display/ appearance...

Is it possible to set a formula to copy a colour/format of a cell when it selects the values? I have set up a sumif formula in a cell to select from a range of cells. In the range I have coloured the cells containing the prices in USD of one company in Green and another company's prices in...

Hello, I would like a cell, A1 say, to always show the value of the cell directly below. i.e. typing '=A2' in cell A1. If a new row is inserted below row 1, I still wish A1 to show the value of the values I will enter into A2. I have tried both absolute and relative references but when I...

Is there a way to have text from one cell centred vertically over a selection of cells in a column? The text of is at 90 degrees going from down to up the column. s

Has anyone designed or know of a good World Cup Sweepstakes Chart for the office? s

Let's say I have a chart with an 'A' column that has 'Yes' and 'No' values in the rows. In the 'B' column I have numerical values alongside all the 'Yes' and 'No's. I would like to know if it is possible to take all the corresponding values in the 'B' column to every 'Yes' in the A column and...

I am setting up a form for estimating documents. There is a box for the document number, a box titled "Revision" and a check box titled "Current Revision" A tick to be placed in the check box if the document is the most up to date. Each time the estimate is reveiwed and changed, a new...

I have set up a form like a web page with a "Next >" button to close the current form and open a new form. Is it possible to have the new form open and be ready to accept a new record instead of having to hit the "Create a new record" [>*] button? s

I am setting up a form with a few tables in it. I want each table to relate to the form. When the Next button at the bottom of the page is clicked I want all the values of each table recorded even if there were no values put in the boxes. For example if there is no value added to the field...

I am setting up a form for employees to enter data for 'hours' and 'rates' alongside records. I have nominated the fields as Project, Hours and Rates In the project field there are subgroups (records) a,b,c,d,e, etc. each with hours and rates applied. I would like the employees to open up a...

I have inserted a Command Button in a Form to open another form. It opens the nominated form but the previous form is still on screen in front of the nominated form. I have named the Command Button "Next >" just like you see on many forms and I want it to save the information, close the...

I'd like a have it so that soon as Access is opened a form pops up, how do I do this? s