duplicate row

  1. S

    Errors when attempting to import text and check for duplicate rows in imported data

    Currently getting a runtime error when copying over the data in the for loop checking for duplicates I am attempting to check all rows for duplicate rows in the imported text. Then copy the entire imported text to the bottom of the original sheet from column c. Sub ImportText1() ' Tester...
  2. 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>
  3. S

    Sum if Cell matches another on different sheet, but only keep one row to continuous tally sum

    Hello- I am making a service trackers for hours earned by students. I have it set to sum their hours as they enter them, however, it creates a duplicate line with the total every time they submit a new entry. What do I need to add to my formula so that once a student is on the total sheet, it...
  4. P

    Notify User of Duplicate Entry

    I am creating a personal finance tracker where a user enters their purchase information in order to track their daily/weekly/yearly spending. Upon submitting the User Form, the information simply populates a raw data source that feeds into many pivot tables and charts. For my own personal...
  5. V

    How to remove entire rows with one specific matching cell.

    i AM A high school student. In this excel document there is list of 100000 doctors. With their unique registeration number in a cell. Like this <tbody> Doc1 1234 adhh rnier Doc2 5678 dscu dcwofn Doc3 9012 ijwo dnw Doc1 1234 fne oeirfj </tbody> Here entire row is not duplicate But the...
  6. C

    Duplicate row according to condition

    Hi all I need to duplicate a row according to the value. So if the qty is 1 I don't need to duplicate but if greater than one let's say 5 I need it to duplicate the row 5 times.

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
Back
Top