Sum Column B based on Column A using Excel VBA Macro

[Rakesh Kamani]

There are 4 worksheets in the workbook. Command button in sheet 1, project name and actual hours in sheet 2, project name and planned hours based on month and year in sheet 3, final report display on sheet 4. (Name of project, actual hours and planned hours).

When I click on the Command button on Sheet 1, Report Display on Sheet 4 based on Sheet 2 and Sheet 3.

How to write a VBA in this case?

Thank you in advance.

 

[DanteAmor]

I don't understand what the pattern is. I will assume that everything that does not start with "auto" or "total" is a project.

 

[Rakesh Kamani]

I don't understand what the pattern is. I will assume that everything that does not start with "auto" or "total" is a project.

Yes Amor,
1)The project id is 7digit (stating first letter is alphabet or only number)
2)sheet2 project column is only ID, sheet3 project column is id+name

 

[Rakesh Kamani]

I don't understand what the pattern is. I will assume that everything that does not start with "auto" or "total" is a project.

please consider below snap shot as a sheet2

 

[Rakesh Kamani]

Yes Amor,
1)The project id is 7digit (stating first letter is alphabet or only number)
2)sheet2 project column is only ID, sheet3 project column is id+name

Dear Amor,
Can you please provide solution about previous reply.

 

[DanteAmor]

If you change the structures of the sheets, the macro or previous solutions will not work.

You could put examples of your 3 sheets using xl2bb tool. Please put the information with the real structure, that way I can deliver a suitable solution.

 

[Rakesh Kamani]

Hi Amor,

I have uploaded sheet3 image, because unable to download XL2BB. tomorrow I'll add full data in XL2BB from my personal laptop. meanwhile can you please consider below attached image as a sheet3.

Thank you in advance.

 

[DanteAmor]

Again you changed the structure of the sheet.
Please, you can provide concise information, but of the 3 sheets, then it would be 3 images.