asd

  1. N

    make rows and paste acording to a cellinfo

    I created a thread yesterday https://www.mrexcel.com/forum/excel-questions/1102769-how-set-range-vba-active-cell.html 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
    • Started by PabloFer
    • Replies: 32
    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 ???
    • Started by Sleeplol
    • Replies: 24
    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
    • Started by johnsonk
    • Replies: 22
    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
    • Started by Dellboy
    • Replies: 25
    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
    • Started by ipbr21054
    • Replies: 22
    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
    • Started by Ramballah
    • Replies: 22
    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