b1b20

  1. K

    Locking Formula

    Hi All, this question I asked a long time ago and didn't really get on top of it, I'm assuming I would need some VBA code to accomplish this Looking for some help on this one, if I have a series of numbers in cells A1:A20, then I would like these numbers to be printed in there corresponding...
  2. L

    Need help with Formula

    Using the data validation I created a drop down list. The formual I used is =VLOOKUP(K2,A1:A20,2). The list has several codes associated with name of places in A1:A20. When you pick a code in K2, it will display one of the cities from A1:A20 in K1 cell. I need K2 to also display what is showing...
  3. K

    Move/Delete Entire Row If Value of Cell Matches a Range From Another sheet

    Hi Excel masters. I am working on one excel report which is to be used repeatedly. However, I am stuck with this one challenge right now. Please help! :( Here is what I am trying to achieve. 1. Move an entire row to another sheet if a value of it's column is found in a range that is located...

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