Attached - Workbook_001.xlsm (for reference.)
Hi, I am novice in VBA application for Excel.
I need your help in creating VBA (.xlxm) file that will do tasks as detailed below.
i) The Workbook contains One “Summary” sheet & one “Master” sheet.
“Summary” sheet has table with Serial number, reference No., Description etc.
“Master” sheet will be used for making duplicate multiple copies as required.
ii) On click of a button placed in “Summary” sheet, -
1. One Row should get added to the table with automatic Next serial number & Next Reference number in series.
2. After Row is added to the Worksheet, “Master” worksheet should make a copy of itself at the end of all worksheets.
3. This newly added Worksheet should be renamed to Reference number from Row added in “Summary” sheet
4. Defined Cells (e.g. A2 or B2 etc) inside this newly added worksheet should reflect values from newly added row in Summary sheet.
(i.e. Serial Number & Reference Number generated in Summary sheet should also go into Copied Master sheet at specified cells (A2,B2)
5. After the text is manually entered in “Description” column of “Summary” sheet, it should reflect in respective duplicated “Master” Worksheets at specified cells (C2)
6. If possible, I want to keep “Master” Sheet hidden.
Bookmarks