order by

Hi All, Sorry if that isn't very clear. What I have is a spreadsheet where I have a MAIN LOG, which I use to keep track of client appointment and report timescales. That all works fine, so don't worry too much about that. What I need help with is this. When 'Y' is entered in Column R (indicating...

Hello, I would appreciate your help with the formula or VBA code for the following function. In the 'Used/unused item number' column I need to apply a sequence of numbers. If the item in the 'Used/Unused' column is 'Used' the formula should by order of 'Date' apply the sequence from the...

I need help creating a formula to look up values in order in the rank column in the table on the right, and pullover the Group A country onto the table to the left. The idea is that I hide the table to the right that is calculating scores based on another area in my spreadsheet, and I will use...

Hi All, Quick question (probably very basic... so apologies in advance) .... I have an access form used by reception, it registers: - caller name - caller phone - who they want to speak to (dropdown list of names) - brief message of content of call If my name is one of the ones on the drop...

Hi, An awkward problem here I suspect! Creating a pivot from a text file, read in via ODBC. This works fine, so naturally they want to change it :rolleyes: Currently: Set objMyPivotCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal) With objMyPivotCache .Connection =...

Hello, I have built a crosstab query to calculate a sum for a specified date. ACCESS automatically populates the query alphabetically by the "CourtTimeSaved" column, however, I want a different ORDER BY list. How may I do that? TRANSFORM Count([Court Time Saved].ID) AS CountOfID SELECT...