crash24210
New Member
- Joined
- Sep 13, 2017
- Messages
- 1
Thanks for stopping by,
First off, I am new to VBA so I feel like what I am trying to accomplish is probably way over my head. Also, I have searched for a solution to this but can not find exactly what I need.
I have a workbook that has an overview (Monthly) worksheet with value headers in the first row. The second sheet is a template for transactions. What I would like to do is be able to click a button that adds a new "transaction" sheet, and a corresponding row in the overview sheet that links to the new transaction sheets values.
In the transaction sheet in column "A" you have: Name, Date, Retail Value, Tax, Business Share, & Profit. In the next column are the corresponding values.
I would prefer to hide the original transaction sheet and use it only as a template to copy, but if that's to involved then I can just leave it visible but blank.
I hope I have given you enough information to go on. Thank you very much for any time and effort you can provide.
First off, I am new to VBA so I feel like what I am trying to accomplish is probably way over my head. Also, I have searched for a solution to this but can not find exactly what I need.
I have a workbook that has an overview (Monthly) worksheet with value headers in the first row. The second sheet is a template for transactions. What I would like to do is be able to click a button that adds a new "transaction" sheet, and a corresponding row in the overview sheet that links to the new transaction sheets values.
In the transaction sheet in column "A" you have: Name, Date, Retail Value, Tax, Business Share, & Profit. In the next column are the corresponding values.
I would prefer to hide the original transaction sheet and use it only as a template to copy, but if that's to involved then I can just leave it visible but blank.
I hope I have given you enough information to go on. Thank you very much for any time and effort you can provide.