This is probably not possible so I'm probably looking for a miracle.
I'm hoping to create a workbook whereby the 1st sheet ("Summary") will have a header row followed by data rows below. The "miracle" that I'm looking for is a macro to accomplish the following:
As user enters a new data row and clicks a button, it will trigger the marco to:
1) insert a new sheet and name it based on what user entered is "B" and "C" separated by a space. Example, user entered "12345" in "B" and "9999999" in "C", the new sheet will be named "12345 9999999".
2) the new sheet will be pre-populated with some labels and formula (sort of like a template) per sample in attachment #1. Note that grey cells with red fonts require labels and formula to be filled in by the macro
3) each of the inserted sheet will have a total amount (referred as "column total" in the sample attachment), which needs to be updated in the "Summary" sheet (last cell in the data row entered by the user. Attachment #2 is a sample of the "Summary" sheet.
I'm hoping to create a workbook whereby the 1st sheet ("Summary") will have a header row followed by data rows below. The "miracle" that I'm looking for is a macro to accomplish the following:
As user enters a new data row and clicks a button, it will trigger the marco to:
1) insert a new sheet and name it based on what user entered is "B" and "C" separated by a space. Example, user entered "12345" in "B" and "9999999" in "C", the new sheet will be named "12345 9999999".
2) the new sheet will be pre-populated with some labels and formula (sort of like a template) per sample in attachment #1. Note that grey cells with red fonts require labels and formula to be filled in by the macro
3) each of the inserted sheet will have a total amount (referred as "column total" in the sample attachment), which needs to be updated in the "Summary" sheet (last cell in the data row entered by the user. Attachment #2 is a sample of the "Summary" sheet.