Recent content by Sharon Hague

Hi All Thanks for all your replies. I have tried all the suggestions you have all advised on. I am using the Data/Subtotals routine and whether I have the subtotals on a seperate worksheet or even another spreadsheet that is linked to the main spreadsheet that I refresh on, when I refresh the...

Hi All I have a spreadsheet which I refresh data on which is stored on our accounts package. I do this using ODBC. I want to insert subtotals into the spreadsheet which I can do, however when I go to refresh the data again the subtotals dissapear and I have to insert them again. Is there any...

Many thanks.

Hi All Is there a quick key to take you automatically to the formula bar to edit what it contains as opposed to clicking in there with your mouse?? I'm sure there must be and I'd appreciate anybody's help on this. :confused:

Hi Yes 12 would be best. Beyond 12 doesn't matter as I will just use the same worksheet for future years. Many Thanks

Hi Many thanks for your help on this. It looks as though it will work great, however, I have added some more rows for months 3 and 4 underneath the others, defined the ranges but when I come to change the if function it doesn't work. I have added just the 3rd index to see if it worked but it...

Sorry Try now.

Hi Shades I have just had a look at the index way and I don't think it is going to work. I have attached an example worksheet of what I am looking for. I hope its pretty straight forward. Cheers.

Hi No I havn't used or heard of that before. Is it quite straight forward and can I find this in help?

Hi I have a worksheet consisting of data in 4 rows and 10 columns In rows 1 and 3 across 10 columns I have dates which are formatted to dd/mm/yy and displayed underneath in rows 2 and 4 accross 10 columns I have number fields. i.e A B C...

Many thanks its worked a treat. Cheers

Hi All I have a spreadsheet where I have hidden a large number of rows which I want to remain hidden. From the information I have left I want to copy this onto another worksheet without it carrying over the hidden cells. I'm sure there must be a way but no matter what I try it copies the...

Hi All I have set a parameter in a query on a number field. When I run the query it lists all entries relating to the number I enter. Once I have ran the query by either opening the query or clicking on the datasheet view when I am in design view, is there a way that I can re-run the query...

Hi Ken I do have a subform called FrmSubformAbsenceDetails which I use to total the holidays/absence shown on another form FrmFullEmployeeDetails. Can I use the total in the form FrmFullEmployeeDetails to sho in my report?

Hi I have a report which runs from a query. It basically is a report I run each week for each employee which they complete as to what their attendance has been for that week. It also lists if they have any holidays booked for that week. The report is run from a query which has a date...