urn

  1. N

    VLOOUP and INDEX I think?!

    Hi all, been a while! I'm creating another spreadsheet and wondered if anyone can help me out with it. I have a survey that asks a question, with responses to the question being: - Definitely - Likely - Not Sure - Unlikely - Definitely Not - N/A The downloaded sheet displays the answers in six...
  2. Q

    VBA to Add 1 to Highest Number

    Very complicated one here so I won't explain why I need this.. I want to create a button that when clicked a pop-up appears saying "Enter URN". When the user enters this info, the record with that URN is updated. It will update by adding a number to the 'CompNo' field which will be Maximum...
  3. T

    Help please

    Hi all, I have several worksheets containing data that I would like to exploit, example columns setup as per below. Worksheet 1 URN LLDRG Date1 111 apple 1/1/2018 123 pear 1/1/2018 222 apple 1/1/2018 Worksheet 2 URN Date2 111 4/2/2018 111 12/2/2018 111...
  4. M

    Macro to query website search funtion

    I have a list of 800ish unique establishment references and I need to enter each one into a search box on a website to get a specific item of information form the result. I can see there are quite a few solutions out there but I need to get this done ASAP and as I need to work on other areas of...
  5. S

    Using IF and VLOOKUP?

    So, I'm new to this forum and hoping you can help me with a formula... I think it's simple but explaining it might be hard. I have two tabs: tab 1: <tbody> URN Ref 2318 YOU008 2319 YOU009 </tbody> tab 2: <tbody> Ref sALES YOU008 £5 YOU008 £10 YOU009 £5 YOU009 £25 YOU009 £23...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top