leeds

  1. S

    Drop down list linked to Worksheets

    Hey all, If someone could help me with this I would really appreciate it. I have a workbook (named Database) which contains 4 worksheets named Main, Leeds, Bradford, York. Ideally I would like to create a drop down list in Main which lists the other worksheets which when selected will...
  2. C

    Need to replace this with a SUMPRODUCT function - help please

    <tbody> LEEDS DRESS =SUMIF(INDIRECT("'[JAMIE SHEET LEEDS.xlsx]"&$C$5&"'!C$12:C$25"),$C9,INDIRECT("'[JAMIE SHEET LEEDS.xlsx]"&$C$5&"'!J$12:J$25")) DENIM SHIRT </tbody> <tbody></tbody> Where JAMIE SHEET LEEDS is the data source which has multiple worksheets. The INDIRECT function is...
  3. L

    Conditional Formatting multiple columns based on selection made in one column

    Hi, I wonder if someone can help me please. I have a spreadsheet that has a validation list in column A and then other date in columns B to I. I would like to change the colour of a row (all the data in that row) when certain 'Locations' are selected from the validation drop down list. E.G. If...
  4. B

    Replacing data in one column with another

    Hi I have a column which has the following numbers 01 02 04 05 These numbers represent a depot 01 Leeds 02 Manchester 04 Huddersfield 05 Lincoln I need Excel to look up the 01 and replace it with Leeds Both sets of data are in a different table the old way has been to do CTR and F which is...

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