Auto populate rows from master sheet to other sheets Excel 2013
Solved/Closed
RyanLug
-
Sep 3, 2015 at 05:11 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Sep 25, 2015 at 04:07 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Sep 25, 2015 at 04:07 AM
Related:
- Excel populate rows from another sheet
- How to screenshot excel sheet - Guide
- Mark sheet in excel - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Little alchemy cheat sheet - Guide
- How to open excel sheet in notepad++ - Guide
2 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Sep 6, 2015 at 08:36 AM
Sep 6, 2015 at 08:36 AM
Hello Ryan,
I think that I have understood what you would like to do so see if the following code does as you would like:-
Following is my test work book for you to peruse. Run the macro and the data for each unique ID will be transferred to the respective individual sheet (including blank cells).
https://www.dropbox.com/s/at3a9pumvlxsnkb/RyanLug.xlsm?dl=0
I hope that this helps.
Cheerio,
vcoolio.
I think that I have understood what you would like to do so see if the following code does as you would like:-
Sub TransferData() Application.ScreenUpdating = False Dim lRow As Long Dim MySheet As String lRow = Range("A" & Rows.Count).End(xlUp).Row For Each sht In Worksheets If sht.Name <> "Master" Then sht.UsedRange.Offset(1).ClearContents End If Next sht For Each cell In Range("A2:A" & lRow) MySheet = cell.Value cell.EntireRow.Copy Sheets(MySheet).Range("A" & Rows.Count).End(xlUp).Offset(1, 0) Next cell Application.ScreenUpdating = True Application.CutCopyMode = False End Sub
Following is my test work book for you to peruse. Run the macro and the data for each unique ID will be transferred to the respective individual sheet (including blank cells).
https://www.dropbox.com/s/at3a9pumvlxsnkb/RyanLug.xlsm?dl=0
I hope that this helps.
Cheerio,
vcoolio.
Sep 24, 2015 at 01:22 PM