Macro to extract data on Summary sheet

[Howardc1001]

I have a "summary sheet " and I would like a macro to extract the data from sheets 2 onwards and paste this on the summary sheet and also insert the name of the applicable sheet in Col D (company name) on the summary sheet based pertaining to the data copied for that sheet


I have attached sample data


Your assistance is most appreciated

[jindon]

Try

Please Login or Register  to view this content.

[Howardc1001]

Thanks Jindon

Thanks for the help, much appreciated

Stay Safe


Regards


Howard

[Howardc1001]

Hi Jindon

I have added an extract sheet called "Summary 1st Payment"


I have tried to amend your code so that data is only extracted from sheet "CGP" up until the last sheet

I get a run time error Next with for , but unsure of how to correct this


Kindly advise

Please Login or Register  to view this content.

[jindon]

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Howardc1001]

Thanks Jindon. It works perfectly

If I wanted to exclude another sheet for eg "summary 2nd payment" do I do it as follows

Please Login or Register  to view this content.

[jindon]

That will not work
1) If you want to exclude the sheet name begin with "Summary" then just change to

Please Login or Register  to view this content.

2) Or no rule then Select Case statement would be better

Please Login or Register  to view this content.

[Howardc1001]

Thanks Jindon