LinkBack URL
About LinkBacks
ignes 
Hi,
Everyone always want to get rid of duplicate rows.
Is it possible to create duplicate rows of all the existing rows?
Cheers.
Hi,
Everyone always want to get rid of duplicate rows.
Is it possible to create duplicate rows of all the existing rows?
Cheers.
Yes,
Just copy them and paste back somewhere else - either as values (converting formulas to actual values) or as is.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard Buttrey is rightly said, just copy and paste at end of the record and sort will resolve but i have a purpose if we able to identify sheet2 column a1 field and find in sheet1 A:A, then create duplicate rows for such identified field then that will help me a lot.
The thing is that it is a time value running sequentially at the moment.
Ex:
A
B
C
D
I want it to be:
A
A
B
B
C
C
D
D
Cheers.
Is this OKIE?
Sub dupRow() Range("A1").Select Do ActiveCell.EntireRow.Copy ActiveCell.Offset(1, 0).Select Selection.Insert Shift:=xlDown ActiveCell.Offset(1, 0).Select Loop Until IsEmpty(ActiveCell.Value) = True End Sub
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Thanks. Working!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks