b22

  1. J

    Dropdown list multiple column

    Hi please need a help. I have a excel sheet as given below. I need to make a drop down list of that, when I select item name from the dropdown list , item code also come in the next column. Is it possible . Sheet1 <thead> A B </thead><tbody> 1 Item Name Code 2 TRIM CLIP ON LED PANEL 6W...
  2. A

    VB Code to copy and paste values

    <article>Dear Sir, I need a simple vb code and will link it to the button, when I lick it, the value should be copied from; Copy T2 into B22 to B31 next empty cell Copy X2 into D22 to D31 next empty cell Copy AB2 into E22 to E31 next empty cell Copy AF2 into F22 to F31 next empty cell Copy AJ2...
  3. S

    Adding all data into 1 cell from a row ignoring blanks and adding title before whats in non blank cells

    Hi All, I have searched all over the net and cant find the answer. I have a spreadsheets with hundreds of thousands of rows and hundreds of columns, I need to pull out the data that's in a row and add all into 1 cell but where it finds data in a row i need it to take the title name to the word...
  4. R

    multiple if functions in the same cell

    Good afternoon, I am trying to create a formula that "specifically" if cell B22 has a date in it that cell F10 stops adding the date from the previous cell (E10) however if there is a date in B22 then F10 stops counting (this is the easy part I have got this) now if cell C22 does not have a...

Watch MrExcel Video

This Week's Hot Topics

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
Top