Sethanator
New Member
- Joined
- May 7, 2012
- Messages
- 7
Hi!
I am very thankful for the opportunity to even articulate what i want to do - it's taken a while to get this point. Excel is fun, that's for sure, but the more i learn the more i realize what i don't know!
In my job, i keep track of a dozen or so accounts, that i keep in a workbook: master sheet has the "dashboard" look and the sheets represent each account. When i fill out check requests or credit card statements, I use a template and then i have to copy by hand that data to the respective accounts worksheet. Sometimes a check request has 12 different accounts on it and it's a redundant task! Is there a VBA or macro solution that will copy the data in the check request to the appropriate worksheets with a button push?
I'm new to VBA and Macros - i appreciate your patient and comprehensive guidance
Thank you so much!
Seth
I am very thankful for the opportunity to even articulate what i want to do - it's taken a while to get this point. Excel is fun, that's for sure, but the more i learn the more i realize what i don't know!
In my job, i keep track of a dozen or so accounts, that i keep in a workbook: master sheet has the "dashboard" look and the sheets represent each account. When i fill out check requests or credit card statements, I use a template and then i have to copy by hand that data to the respective accounts worksheet. Sometimes a check request has 12 different accounts on it and it's a redundant task! Is there a VBA or macro solution that will copy the data in the check request to the appropriate worksheets with a button push?
I'm new to VBA and Macros - i appreciate your patient and comprehensive guidance
Thank you so much!
Seth