cpadilla0024
New Member
- Joined
- Jan 4, 2021
- Messages
- 8
- Office Version
- 365
- 2019
- Platform
- Windows
Hi,
I do a Super Bowl pool every year and I am trying to knock out a step that is very time consuming. I maintain a Players List on one tab and my square and other info are on another tab. Ideally, I would like my macro to go loop through one name at a time on my player list and do the following steps:
1. Copy name from Player List
2. Paste in Yellow cell on Squares (this is tied to conditional formatting that highlights their squares when everything is game ready)
3. Save Squares Tab as a PDF (with the players name in the file name of course)
4. Clear Yellow cell on Squares
Repeat to next name on Players List until at the end. It is in a Table and can possibly become a Named Range if that is easier. I am just hitting all kinds of issues building this.
The ultimate goal is to get these to mail merge via e-mail so they players can have their own copies. Right now, I am taking 20+ pictures and sending them out to all of the players. Super annoying! Any help I could get would be really appreciated!
I do a Super Bowl pool every year and I am trying to knock out a step that is very time consuming. I maintain a Players List on one tab and my square and other info are on another tab. Ideally, I would like my macro to go loop through one name at a time on my player list and do the following steps:
1. Copy name from Player List
2. Paste in Yellow cell on Squares (this is tied to conditional formatting that highlights their squares when everything is game ready)
3. Save Squares Tab as a PDF (with the players name in the file name of course)
4. Clear Yellow cell on Squares
Repeat to next name on Players List until at the end. It is in a Table and can possibly become a Named Range if that is easier. I am just hitting all kinds of issues building this.
The ultimate goal is to get these to mail merge via e-mail so they players can have their own copies. Right now, I am taking 20+ pictures and sending them out to all of the players. Super annoying! Any help I could get would be really appreciated!
