Search results for query: *

Hi all, I've created a report which can be run at different levels, i.e. countywide and for each of 3 different regions. Part of the report is a trend analysis which will show one of 4 graphs of trend information. As i'm very inexperianced with VBA, i'm probably not going about this the right...

Hi, I have been passed an urgent piece of work that i just cannot fathom out on my own. It involves paying Practices on a sliding scale. This is the guidence i have: Lower threshold 20% = £196.07 Upper threshold 50% = £117.64 an average practice will receive £196.07 if the proportion of...

G'day all, I'm attempting to summarise a large dataset with formulae as opposed to a pivot table. I would, of course, usually use a pivot table, but this issue is only part of the overall task which involves me updating a table on a monthly basis using VBA. Anyhow, i'm currently at the...

Hi, this is probably very simple indeed. I've created a .pst file in outlook to store old messages and the like. I'd now like to move this file to a different directory, so i can access it in other locations. I can't seem to find any way of doing this. Thanks in advance for you help.

Hello, I have created a report which is produced monthly within excel. This report is run for 5 services who's data is stored on five different sheets (i know this isn't ideal data management but all these sheets contain tens of thousands of rows and they wouldn't all fit into one sheet). I...

Hi all, I came accross this today and found it rather strange. I was wondering if any of you have had the same problem and whether or not you were able to solve it? I have a spreadsheet where several sheets link to a date (reporting month). The date is specified on a 'Control Tab'. When i...

Hi, This is probably very easy, but being very new to VBA I've gotten myself a little stuck. I record macro's then try to edit them in order to make them a little bit more dynamic and try to take out any unnessessary code. I have browsed this forum and found how to Copy a formula down to the...

Hi all Right, i'm trying to create a dynamic range that will return the last/bottom 12 rows from a range. I need to produce charts which show performance on a rolling 12 month period, i currently have a table which is set out something like this: Date Actual % Target Jan 06...

Hi all, I am trying to create a dynamic named range, that changes size as more information is added. I have read the FAQ 68-1331 posted by skipVought and tried using his worksheet function to achieve this. However, this formula doesn't seem to work. this is the formula as i have typed it...

Hi all, I am trying to mail merge from an excel spreadsheet into a word doc. The word document is in the form of a table and i need to merge each row of excel with a row in the table. Using the usual mail merge procedure word creates a new page for each row in excel. I'm sure there must be a...

Hi, I produce a spreadsheet from a database weekly in oder to show activity on a week to week basis. I then use this spreadsheet to create a pivot table so the information is easy to understand. I want to create a macro that creates a dynamic range, adds a couple of formuala's and creates the...

hi there, I'm having some problems syncing my palm V with outlook 2000. My e mails are coming across fine, but my calendar, tasks and contacts are no where to be seen. I've tried reinstalling palm desktop on my pc, but this doesn't seem to make any difference. Any suggestions? Thanks in advance

G'day, is it possible to use a Look up function which contains year refs (01_02, 02_03 etc) to return all the values from the look up table that should contain more than one year ref. cheers

Hi I'm currently administrating a large relational database. I need to Run an update statement something like this. UPDATE table1 SET column1 = '6c' WHERE column2 = 602 AND column3 = 45; The problem is that column2 resides in a different table that column1 and column3. Are you with me? I...

Hi, I want to create an excel form to collect data in a workbook list. I need the work book list to be hidden from users. I just want users to open the workbook, fill in a form, submit it and the data to be recorded in a list. Can anyone help? Cheers

hello What is the name of the key above the tab key and below the escape key? You know the one with three lines on it next to 1. No-one i've asked knows. Cheers Never push your Granny while she's shaving; You might make her cut her leg!

We are workimg on a Excel speadsheet, trying to work out how many dates someone has gone over. We have got our date range containing the 'SPOT dates' and have named it SPOT. Our mission in life at the moment is to write a formula to count the number of dates that have been covered by each...

Hi We are trying to write a function to work out if a date range (start Date - Now) pass over a set of specific dates. If the date range crosses a 'Spot Date' then we need to return the result '1', if the range passes 2 'Spot dates we need to return the result '2' and so on. we have put the...

Hello, I currently administrate a database for a training provider/college. We've been running on Interbase for about 2 years and the size of the database has obviously grown over time. I've just had a conversation with our suppliers and they seem to think that our database is too large to...

Hi I've recently inherited a database at work, containing all sorts of data relating to students at a college. Someone has gone nuts on this DB and created loads of unnecessary columns. Most of them i can simply delete, though some have got relevant information in them. Is there a way i can...