Search results for query: *

OK, I've got the allocation of the names from cells in Column "B" to a standard TextBox. And I can apply some logic to extract the correct data. Many thanks, D€$

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

Hi strongm, well, there will be about 5 different conditions for shading the cells so I thought I'd just build up several processes in code. I presume that you are talking about just shading from within Excel? Many thanks, D€$

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

Thanks Mike, that worked. It also seems to have done it for my other recent post! [dazed] Many thanks, D€$

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

Well I'll be... I almost spotted that as I thought it looked a bit odd on my screen but I, foolishly, didn't peer closer!! Works the way that I had hoped it would!! Many thanks, D€$

Hi dhookom, I get the error message "The expression you entered has an invalid string. A string can be up to 2048 characters long, including opening and closing quotation marks." Hi Andrzejek, well both in a way as it depends on what I'm trying to find out because referrals that are coded...

Thanks Combo, it just strikes me as REALLY strange that I managed to cross the x & y co-ordinates and achieve what I wanted earlier in the week - although I'll admit that I probably put this in there, did something, moved something somewhere else and Heaven knows what!! I'm finishing for the...

Pivot Filter. Many thanks, D€$https://files.engineering.com/getfile.aspx?folder=5dff302c-eece-4af8-a394-83390d3ddd07&file=20200507_Pivot_Filter.jpg

Just another anomaly, is that I changed "General Medical Practitioner" to "G.P." in the data but the Pivot Filter still offers that as an option. I've attached a couple of screenshots to show what I mean. Many thanks...

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€$

Thank you combo. CHRISTMAS DAY!?!?!? Ha ha! [smile2] I had a suspicion that 'Value' was "better". It's only a small bit of code so I've amended all to 'Value2'. 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...

Hi Skip, apologies for the lack of response. I must confess that I have confused myself looking at your responses. BUT, on the positive side, what I would like to explore is the idea of putting the Financial/Fiscal Year parameters in a table and, somehow access that. I've amended the formula...

Thanks Skip. I have attached an abbreviated copy of the workbook to show exactly what I've got. I think my brain had almost overheated yesterday but what I'd meant to say was All I was able to do was change the colour of each individual column, well, individually! Many thanks...

OK, I Think I've got some sort of solution. I added another 'helper' column to the data table and used that to calculate the Financial Year: (Any better way of doing this would be gratefully received BTW.) I then refreshed the pivot to include this column. I then grouped the Pivot Table by...

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