Hi guys, I'm very new to VBA but I got some help and made it so that on my cover sheet, I can run a pregram on the job listings and it creates a page named for each job.I was wondering if there is a way to make it better.
What I would like to happen is enter a new job (lets say Apple) in column B on COVER page, then run a macro so it makes a sheet named Apple.The pagewould be a coply of a blank form named BLANK. The row Apple would then have all the associations that the rows abov it have. For example all the job rows in olumn D reference I44 on there respective pages. Is that possible or even make any sense? Thanks in advance guys.