URGENT!! Need help and some advice/reference.

[zeecharle]

Hi, Good Day!

Can anyone help me in my excel work.

I Have 1 excel file that Has multiple worksheet. The first worksheet is my master worksheet/ the summary worksheet. and the other worksheet is the worksheet that contains multiple data that are in same format/template. I want to gather all of the data from the multiple worksheet to the master/summary worksheet.

I will consider the duplicate data in different worksheet and it should add the quantity of the duplicate data.

My workbook is an inventory workbook.

Thank you for helping and your time.

-Zee

 

[ImranMalek]

Hi Zee,
There's an inbuilt excel feature called Consolidate you can navigate to it by going into DATA - CONSOLIDATE.
You will have to select ranges from multiple formats (From your statement I'm assuming they have exactly the same structure ! )and add them together.
Used NamedRanges for your ranges in multiple worksheets its easier to track that way.

Hopefully it will yield the result you want !

 

[zeecharle]

Hi Zee,
There's an inbuilt excel feature called Consolidate you can navigate to it by going into DATA - CONSOLIDATE.
You will have to select ranges from multiple formats (From your statement I'm assuming they have exactly the same structure ! )and add them together.
Used NamedRanges for your ranges in multiple worksheets its easier to track that way.

Hopefully it will yield the result you want !

Hi. Thanks for the attention and time for replying with my post.

I try that DATA - CONSOLIDATE, but I want to merge it all in the way that the master/summary worksheet format/template. I Have the template in the master/summary worksheet.

Can you help me? I'll send you my excel data.

 

[MARK858]

As it is a generic question have a look at the Ron de Bruin page in the link below (download the example workbook it will make your understanding easier)

Make sure you read Ron's instructions carefully


Ron's site

 

[zeecharle]

As it is a generic question have a look at the Ron de Bruin page in the link below (download the example workbook it will make your understanding easier)

Make sure you read Ron's instructions carefully


Ron's site

Hey brother. Thank you for the Reference.

Feedback later.

 

[ImranMalek]

Please share your workbook/data that would help understanding your problem better.

 

[zeecharle]

Please share your workbook/data that would help understanding your problem better.

Here is my excel file. Please see attached file "PARTS LIST TEMPLATE.xlxs"
Thank you for your help.

PARTS LIST TEMPLATE

 

[MARK858]

Try the code below on a copy of your workbook. The code goes in a regular module

Sub transferit()
    Dim ws As Worksheet
    Application.ScreenUpdating = False

    For Each ws In ActiveWorkbook.Worksheets
        If ws.Name <> "SUMMARY" Then

            With ws.Range("B8:F" & ws.Range("B" & Rows.Count).End(xlUp).Row)
                Sheets("SUMMARY").Range("B" & Rows.Count).End(xlUp).Offset(1).Resize(.Rows.Count, .Columns.Count).Value = .Value
            End With

        End If
    Next
    Application.ScreenUpdating = True

End Sub

BTW, it doesn't help to test when your sheets are identical

 

[zeecharle]

Try the code below on a copy of your workbook. The code goes in a regular module

Sub transferit()
    Dim ws As Worksheet
    Application.ScreenUpdating = False

    For Each ws In ActiveWorkbook.Worksheets
        If ws.Name <> "SUMMARY" Then

            With ws.Range("B8:F" & ws.Range("B" & Rows.Count).End(xlUp).Row)
                Sheets("SUMMARY").Range("B" & Rows.Count).End(xlUp).Offset(1).Resize(.Rows.Count, .Columns.Count).Value = .Value
            End With

        End If
    Next
    Application.ScreenUpdating = True

End Sub

BTW, it doesn't help to test when your sheets are identical

That my problem. It should be Added if it is identical. If it is duplicate it should be added all the duplicated quantity.

by the way, thanks again for information. I got some knowledge on it. thanks.

 

[MARK858]

That my problem. It should be Added if it is identical. If it is duplicate it should be added all the duplicated quantity.

Sorry but can you rephrase the statement above as it isn't making much sense to me or/and upload another sample with the SUMMARY filled out as you would expect the results to be.