mikemathis
Board Regular
- Joined
- Jul 9, 2003
- Messages
- 135
- Office Version
- 2019
- Platform
- Windows
Ok, here's what I'm doing and hoping that there's an automated way to do it. I'm creating a donation sheet (a summary sheet followed by individual worksheets for each giving family). I have the summary sheet with the family names in column "A" (ascending order). My puzzle is, what happens when I have a 'new' giving family through the year? I have referenced the summary rows (for a single family) onto it's own unique worksheet to show a detail of what that family has given (which will be printed out on a quarterly basis).
I'm not a 'coder' and have no macros used in this sheet (which currently has over 65 worksheets to it).
My questions are:
1. Is it possible to dynamically name a worksheet from a cell in my summary worksheet?
2. Is there a way to have a single template detail sheet (since the giving statements will be given out quarterly and have no other purpose) and have a *pick a 'family', print, next family*
many thanks.
I'm not a 'coder' and have no macros used in this sheet (which currently has over 65 worksheets to it).
My questions are:
1. Is it possible to dynamically name a worksheet from a cell in my summary worksheet?
2. Is there a way to have a single template detail sheet (since the giving statements will be given out quarterly and have no other purpose) and have a *pick a 'family', print, next family*
many thanks.