Recent content by chrisb1978march

  1. chrisb1978march

    Sharing USB devices between 2 computers

    Haha, tell me about it bro! I don't even open my curtains, just in case someone looks at me.
  2. chrisb1978march

    Sharing USB devices between 2 computers

    That seems perfect, and it will allow me to get rid of the HDMI switch too. Thank you Chris
  3. chrisb1978march

    Sharing USB devices between 2 computers

    Hi all, Just found out I have been registered on this site for 10 years, wow how time flies😊. Anyway, I have googled this and not found what I need. Here's the issue I have: Due to all this Covid stuff, I'm currently working from home. I have a works laptop and my desktop PC set up on the...
  4. chrisb1978march

    Should I buy a better CPU or Graphics card?

    Having not seen your other specs of your computer.. I would always recommend a separate graphics card over integrated graphics nowadays. A quick check and it looks as though the card would be compatible with the processor, so you would certainly see an improvement to what you've been using...
  5. chrisb1978march

    Solved Help with a macro in Excel

    Never mind... having thought about it, it was easier to simply hide the cells I didn't want people to edit, then record the macro (unhiding the cells at the beginning and then hiding them again at the end).
  6. chrisb1978march

    Solved Help with a macro in Excel

    Good afternoon, I currently have an excel spreadsheet where i list a number of quotes from different companies to make it easy to compare the quotes and look for the best value products. I have been looking at recording a macro to enable users to run it and it will automatically copy the cells...
  7. chrisb1978march

    Solved DST issues, on Asus AC68U router?

    @crjdriver yes it does have the option of changing the time zone, however it was on the correct one and the router time was showing the correct time... Which was what was odd. But I think, as you said best to use browser rather than the app
  8. chrisb1978march

    Solved DST issues, on Asus AC68U router?

    Thanks @Macboatmaster, I went to the settings on the web rather than the app, cleared all the parental settings and out them back on and it's done it. Not really sure why, but clearing them on the app didn't work.
  9. chrisb1978march

    Solved DST issues, on Asus AC68U router?

    Hi all, I seem to be having issues with the above on my Asus AC68U router. I live in the UK and use the App to schedule the kids internet use - after 10pm they can't access it. All worked fine until the clocks went back this morning at 2am. Their devices now show it's blocked from 9pm. I've...
  10. chrisb1978march

    Solved formula to pull out number of occurrences in a month

    Thanks OBP, it worked, I appreciate your help!!
  11. chrisb1978march

    Solved formula to pull out number of occurrences in a month

    Ah yes, a column for each year would work and they'll be hidden so it won't matter how many column there are anyway. Thanks for your advice and help on this OBP, will try that on Tuesday and report back, byt can't see a reason it wouldn't work. Will mark the thread as 'solved' on Tuesday...
  12. chrisb1978march

    Solved formula to pull out number of occurrences in a month

    It would need to count 2017 and 2018 but not collectively. This is to do with a work spreadsheet I have. It may be easier for me to cleanse the data and attach so you can see....however I have now left work. I'll try and explain a bit more. The spreadsheet is for visits made. The raw data...
  13. chrisb1978march

    Solved formula to pull out number of occurrences in a month

    I am presuming that you can't distinguish between years? The reason is that there a couple of years of data in the spreadsheet. So as the MONTH is looking at specifically the months, it will count both 2017 and 2018 and return 4's for both years? And s the only way to do this, to split the...
  14. chrisb1978march

    Solved formula to pull out number of occurrences in a month

    Thank you, it's easier when i see it like that and yes it works :) Thank you!!
  15. chrisb1978march

    Solved formula to pull out number of occurrences in a month

    I was just typing a response to say that I don't think it would work, however now that you've explained how it could work, yes that would do it :) Thank you! makes it easier for me
Top