Pulling rows from a master list into separate pages

A few questions -

1. Would you prefer that as you select a value in the dropdown, the row should immediately be copied / moved? Or do you want to select the dropdowns for each row and then click on a button to transfer the rows? If you do the 1st option, the data will transfer immediately, so if you select the wrong option, the data will be wrongly transferred. The 2nd option is more safe in these terms.

2. Do you want the rows to be moved or should they be copied?

3. If the rows are going to be copied to the other sheets, once you load the data today and run the macro, if you load fresh data tomorrow, would the fresh data be loaded in the next available row or would you clear the data in the master sheet and then load the data?

Hi,
Maddyp


pls check attahment
hope this will help u

Did you try the solution in post 3?

Try this code - Each time any changes are done to the main page, you need to run the macro -

Option Explicit

Sub update_sheets()
Dim i As Long, lrow As Long
Dim sname As String

Application.ScreenUpdating = False

For i = 1 To Worksheets.Count
    With Worksheets(i)
        If .Name <> "Equipment" Then
            lrow = .Range("A" & .Rows.Count).End(xlUp).Row
            If lrow > 1 Then .Range("A2:M" & lrow).ClearContents
        End If
    End With
Next i

With Worksheets("Equipment")
    lrow = .Range("L" & .Rows.Count).End(xlUp).Row
    For i = 2 To lrow
        sname = .Range("L" & i).Value
        If Not Evaluate("ISREF('" & sname & "'!A1)") Then
            Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = sname
            .Rows("1:1").Copy Worksheets(sname).Range("A1")
        End If
        .Range("A" & i & ":M" & i).Copy Worksheets(sname).Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
    Next i
End With

Application.ScreenUpdating = True

End Sub

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

Am glad it worked for you.

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.