Hi All,
I have spreadsheet I am working on that I know could benefit from a Macro, but my VBA experience is minimal so I'm having difficulty wrapping my head around how to write it.
Currently I have two worksheets (1 Master & a template that feeds off of it), the structure of the master tab is below
<tbody>
</tbody>
What I would like to do is three fold
Any help with writing this macro is greatly appreciated
I have spreadsheet I am working on that I know could benefit from a Macro, but my VBA experience is minimal so I'm having difficulty wrapping my head around how to write it.
Currently I have two worksheets (1 Master & a template that feeds off of it), the structure of the master tab is below
Co. | Div. | PC. | GL | Name | Balance | Rec Required (Actually in Column L) |
6 | 539 | 0 | 1102 | AR | 100 | Yes |
6 | 539 | 0 | 1102 | PPD | 100 | No |
<tbody>
</tbody>
What I would like to do is three fold
- have a copy of my worksheet "Template" made for any record labeled "yes" under Rec Required
- Populate that records Co./Div./PC./GL/ into C3/C4/C5/C6 of the newly pasted template
- Rename the the newly pasted tab as that records Co.-Div.-PC.-GL (6-539-0-1102)
Any help with writing this macro is greatly appreciated