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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top