Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PWD
  • Content: Threads
  • Order by date
  1. PWD

    Good afternoon, I have a Pivot Tabl

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

    Excel Not Responding

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

    "Marked Threads"

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

    Excel 2019 Pivot

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

    Access 2019 IIF + Public Function

    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€$
  6. PWD

    Range()=OtherRange() vs .Copy Destination:=

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

    Access 2010 Financial/Fiscal Year

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

    Excel 2010 Pivot Chart - Group Each Month By Years

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

    Access 2010 Sort By Calculated date

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

    Excel 2010 Is It Possible To 'SEARCH' Within A Formula

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

    Access 2010 query excluding records from another query

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

    Hidden Apostrophe

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

    Excel 2010 Column Chart Widths Using 2nd Y Axis

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

    Excel 2010 Pausing Execution For Me To Filter A Worksheet On Treatment Date Prior To Vlookup

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

    Printing Outlook 2010 Calendar Object

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

    Deleting Columns and Making Sure The Used Range Shrinks Accordingly

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

    WS.Columns

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

    Word 2010 Is it possible to format MERGEFIELD text based on comparison with another MERGEFIELD?

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

    A=πr^2

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

    How to Eliminate "[Enter Start Date] And [Enter End Date]" x4

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

Part and Inventory Search

Back
Top