1. N

    make rows and paste acording to a cellinfo

    I created a thread yesterday and this is the continue of my macro which I believe has to change what I had help with yesterday . Sorry for not thinking the whole thing through before posting Here is what I...
  2. V

    Split Value

    Hello All, good day. I have excel file in the below format. Sheet Name :- Sheet1 <tbody> QTY Data Value Solution QTY Data Value 1 TSK desc1 1 TSK desc1 2 ASD DESC201 1 ASD DESC201 1 ASDF des30 1 ASD DESC201...
  3. N

    Paste multiple lines from single point of reference

    I want to copy multiple lines from one sheet that have the same reference number into another sheet, any ideas how? e.g. all the rows that have the ref: 123 <tbody> Ref Info1 Info2 Info3 123 wer asd uio 456 ert dfg wer 123 xxy bbg yyhj 123 wer asd ffg 456 erg wer asd </tbody>
  4. M

    Index or Pivot Table

    Hi All Please could help be provided with the following. I am trying search for a value in the Name Column - in this instance ABCD and at each occurrence return the entire row associated with ABCD Sample data <colgroup><col><col span="6"></colgroup><tbody> Name Thing 1 Thing 2 Thing 3...
  5. S

    (VBA) Search duplicates in column then work on whole rows

    Hi Guys, I will describe you my problem as far as I can. I need help with a macro which fill search for duplicates based on column D and IF THERE IS duplicated row, he will be always in next following row. Then all what we need to do is delete the duplicated rows, but add values from columns...

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