1. A

    Macro to find Like and paste values

    Hello, This is my first post. I am fairly new to VBA and this has me in over my head. I have scoured the internet to try and find the answer for my issue. I am trying to write a script to reference column "S" by row ("S2", "S3", "S4" to the end of the list) and find Like values in Ranges...
  2. S

    Formula from input to list all outputs which data comes from a table

    <tbody> Input Apple Ref No Item 1 Item 2 1 Apple Banana Output Banana 2 Berries Coconut Watermelon 3 Watermelon Apple Berries 4 Banana Coconut Lettuce 5 Berries Apple 6 Lettuce Cucumber 7 Apple Lettuce </tbody>
  3. G

    This thing is out of my league (SUM+lOOKUPV+INDIRECT in the same formula)

    Hello everyone, Im going crazy trying to make an excel sheet that is kinda out of my league. I have different worksheets with data arranged as follows, beggining at B5 Worksheet 1 Milk....2 Eggs...3 Yest...1 Worksheet 2 Milk....2 Eggs...3 Yest...1 Lettuce...4 My objective was to create...

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