Duplicate rows based on cell value
Solved/Closed
fireburn
Posts
28
Registration date
Monday February 3, 2014
Status
Member
Last seen
June 23, 2014
-
Feb 3, 2014 at 01:31 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 13, 2014 at 12:07 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 13, 2014 at 12:07 PM
Related:
- Excel duplicate rows based on cell value
- How to duplicate rows in excel based on cell value - Best answers
- Duplicate rows in excel based on cell value - Best answers
- Excel duplicate rows n times ✓ - Office Software Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Copy and insert rows and number of times ✓ - Excel Forum
- Excel date format dd.mm.yyyy - Guide
- Based on the values in cells b77 b81 ✓ - Excel Forum
2 replies
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
Feb 3, 2014 at 12:11 PM
Feb 3, 2014 at 12:11 PM
Hi Fireburn,
Try this code and let me know how it works:
Best regards,
Trowa
Try this code and let me know how it works:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim x As Integer
If Intersect(Target, Range("F:F")) Is Nothing Then Exit Sub
If IsNumeric(Target.Value) = False Then Exit Sub
If Target.Value = 0 Then Exit Sub
If Target.Value = vbNullString Then Exit Sub
x = Target.Value
Do
Range(Cells(Target.Row, "A"), Cells(Target.Row, "E")).Copy
Range(Cells(Target.Row + 1, "A"), Cells(Target.Row + 1, "E")).Insert Shift:=xlDown
x = x - 1
Loop Until x = 0
Application.CutCopyMode = False
End Sub
Best regards,
Trowa
Feb 13, 2014 at 09:43 AM
Thank you so much for helping me out with the code it helped me a lot. I don't know so much about excel, I am a nurse working in senior's home. I am currently working on a spreadsheet. I have one more favor to ask you. I am working with data on a spreadsheet, if I enter the name of the client in a cell, I want to reference other data to table or database? wherein it will automatically enter other data on certain cells in the row like for example the postal code, room number etc. I don't know how to achieve it, i've searched a lot and can't find any answer.
Feb 13, 2014 at 10:52 AM
It sounds to me the VLOOKUP formula will do the job.
But without details I can't help you more specifically.
Could you provide sample data like you did in your original post as it is now and how you foresee the result?
Also consider the possibility of posting your workbook (careful with personal data) using a filesharing site like www.speedyshare.com or ge.tt and then post back the download link.
Best regards,
Trowa