Hi Iam pretty new with excel VBA, basicly self learned all.
I have a tricky question about to how to do a summary sheet. The Idea of the sheet is that I have multiple sheets in a workbook. The macro would find all the partnumbers in Column A which begins with a letter. So the summary sheet only includes the values starting with R etc.
The second thing is that it should sum found values if the value in Column A is the same, for examble it finds two R15 in Sheet1 and Sheet2 so it would sum the values and count the value in Column C together in to the Summary Sheet.
Third thing to do is that, on the summarsheet user could see that where the values come from. For example R15 total is in column C and in column E and F there are the values from the sheet1 and sheet2.
The list is dynamic so user can add or delete sheets so it should always be runned when user does changes in the workbook.
Thanks for the help in advance!
Iam not asking for a final solution, but help to get started!
Greentings Ilari
I have a tricky question about to how to do a summary sheet. The Idea of the sheet is that I have multiple sheets in a workbook. The macro would find all the partnumbers in Column A which begins with a letter. So the summary sheet only includes the values starting with R etc.
The second thing is that it should sum found values if the value in Column A is the same, for examble it finds two R15 in Sheet1 and Sheet2 so it would sum the values and count the value in Column C together in to the Summary Sheet.
Third thing to do is that, on the summarsheet user could see that where the values come from. For example R15 total is in column C and in column E and F there are the values from the sheet1 and sheet2.
The list is dynamic so user can add or delete sheets so it should always be runned when user does changes in the workbook.
Thanks for the help in advance!
Iam not asking for a final solution, but help to get started!
Greentings Ilari
