Search results for query: *

Good afternoon, I have a Pivot Table that is refreshed from a weekly set of data. One of the row fields is the Cancer Site, as below. I have added a button (both "Text Box" allocated to a macro, which works & "ActiveX Text Box" for testing this) for each site and have just put together some...

Good afternoon, I'm just trying to start something really simple but, using this macro, Excel stops responding for the longest time. I'm fairly confident that it's not the work's network, although that could never be discounted, and I just can't see that there's anything here that would cause...

Good afternoon, I obviously hadn't posted here for a while but when i did, a couple of weeks ago, I noticed that my posts don't now have the red tick against them and aren't included in the list if I choose "Marked Threads First" as the Thread Order. Is this a new 'feature'? Have I not done...

Good morning, I hope this is me being really, REALLY thick! I'm trying to limit the output in a Pivot Table to values greater than n. The attached workbook is just a model of a much larger workbook that I created earlier this week where I was able to use the Value Field filtered 'Greater...

Good afternoon, I use Public Function, and I also use aliases, What I'd like to be able to do is to combine the two, Am I just being too ambitious, or is it just basic stupidity?? [bigsmile] Many thanks, D€$

Good morning and Merry Christmas Eve. Just asking myself the question as to which might be more efficient than the other, a or b. And do I need the .Value? a) Sheets("Data").Range("C" & d).Value = Sheets("Somerset").Range("A" & r) b) Sheets("Somerset").Range("A" & r).Copy...

Good afternoon, I have the following Query and ideally I'd like to be able to incorporate a further column whereby I was able to determine the Financial/Fiscal Year, i.e. April-March. Currently this has involved exporting to Excel (2010) and using a rather convoluted formula, which will only...

Good afternoon, I've done "some" searching and not found a solution. What I would like to display is April of years 1, 2 & 3 etc. together followed by May of years 1, 2 & 3 etc. so that my bosses can have a look and see how each month's demand compares with previous years. Is this possible...

Good morning I have a query within which I have a field that I am using to determine if the appointment date offered has breached our 14 day target, allowing for any adjustments. I think I've got a handle on what to do if those dates fall either over the weekend if today is either Thursday or...

Good afternoon, this is probably a daft question but is it possible to 'SEARCH' within a formula in Excel 2010? Basically we have monthly columns that I'd like to be a smarty pants and be able to use a formula to combine them, and I'm thinking that the first thing I would need to do would be to...

Good afternoon, I have a query that will tell me if patients are likely to breach their 2-week-wait target and can be brought forward. This is fine. Now what I would like to do is to have another query that will have the same output and basic criteria, i.e. are going to breach, but only to...

Good afternoon, we have data that comes from a 3rd party, attached, and there appears to be hidden apostrophes in the output. I just did a macro record to try to do a Text-to-Columns but, as you can see, the result is patchy. Can you suggest how to get rid of them before I run this simple...

Good afternoon I have been given a workbook that contains a chart of 7 items each for a series of 6 years, 2 of which are in the ranges 1000 - 1600 and the other 5 are in the range 10 - 300. This is how it looks in Sheet1 of the attached workbook.I've tried just putting some of the latter 5 on...

Good afternoon. I have code that formats and adds various columns to a workbook produced from our waiting times database. What I do is insert a manual break so that I can filter one worksheet on treatment date 2017/18 (this is not fixed in stone) prior to coding Vlookup formulae on the other...

Good afternoon and a Happy New year to you all!! [smile] I'll be back at work tomorrow and our Deputy Chief operating Officer wants to know the schedule of all our meetings. I didn't set this up and don't fully understand what it is but it is a Public Object that shows all the meetings. The...

Good afternoon, I apologise for the clumsy title. Basically, over the years I've found that the only way to reduce the number of used Columns (or Rows) after having 'Deleted' them is to save the workbook. If I don't and then just key Ctrl+End I end up at the bottom of the previously used range...

Good afternoon, just revisiting VBA after some time away. I'm trying to cycle through worksheets in a workbook but I'm having trouble with a couple of things. 1) I want to replace this code with something less Selecty WS.Columns("K:K").Select WS.Range(Selection...

Yes, it is possible to ask a stupid question; here goes. I have set up the following MERGEFIELD that will put in either the appointment date, if it exists in the Access database, or "Unknown" This has saved me a lot of time but it would be awesome if I could underline the date if it were after...

Well, that's a novelty. Was leaning over the keyboard (Yeah, checking FBk while my phone is plugged in to charge. Guilty!) and my forearm/elbow must have been pressing some weird key combination in the bottom left corner. When I looked back at my monitor, I've got a whole block of:- Who knew...

Good afternoon, I have inherited a query that prompts for start and end period dates. Now, right or wrong, I would normally just hard-code these in a query (because when I'm learning about what a query does and how it works, I'll be swapping between Design and Output modes) but in this case...