Search results for query: *

Thought i'd add one. Don't forget the "Well hung" Meat Company in devon, UK

Thanks Combo, that works perfectly. Seems to me even with my limited knowledge, that Select Case can be used instead of if-then-else, is this correct? Also, just so i can start to understand "Private Sub Worksheet_change(ByVal target As Range) with Me" what does the bold "With Me" and the...

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

Did you hear about the man that died in his musli? He was pulled in by a strong current! I love a nice Pun me...

Hi all, unfortunately this solution isn't quite what i was after. I'm looking at the possibly of using a helper column in conjunction with the SUMPRODUCT, in order to get the results i am after. Any ideas?

Cheers Glenn, It certainly appear to give me the right results although, like you say, it's a bit of a beast. Food for thought though, do you not think it's possible within SUMPRODUCT? Cheers again

Thanks for your reply Andy. Yes, i am indeed using excel. Typical that i have included as much info as possible and neglected to mention what program i'm using. What i'm really after is to count the records where the criteria in my SUMPRODUCT are met AND each Person_ID is only counted once.

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

I like those ascotta, A colleague of mine always used to say "If his brains were made of rubber he wouldn't have enough to make a flip flop for a one legged budgie" Generally refering to management

Thanks everyone. I've now managed to move the file to a shared drive, using Tony's method. Cheers

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.

I know this isn't quite keeping with the thread subject, but one can short of a six pack reminded me of it. Boss refering to one of his staff: Well he's certainly the full six pack, but i feel he's missing the wee pastic bit that holds it all together!

Fantastic idea Skip, Have used MS Query before to get data from SAGE, but i'd never though of using it like that. Brilliant solution! Thank you!! Have a star for your time and trouble

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

Good call that from Harley, If you've not used them before try: Data-PivotTable PivotChart Report Then work your way through the wizard.

Have a look at Tools-Subtotals! This should be able to deliver what you are after.

Both CTRL-ALT-F9 and CTRL-ALT-SHIFT-F9 seem to force the refresh and the links then update fine. Not sure of the actual cause of this problem still, but that seems to be a viable solution. Thanks all for your help! Cheers

Thanks for your replies, No fraid not Skip, Calculation is set to automatic. Any other idea's It is a very large workbook, could this be a reason?

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