Working on a schedule type sheet, and I want it to print a copy, update a cell, print a copy, update a cell, print....etc. Say the cell I want updated is A1, and the list to update for each print is in column B. So first print would use value in B1 in A1, second would be B2 in A1, .....so fourth.
Anyone know how to do this? Maybe it could generate a new sheet for each, and then I print multiple sheets.
Thanks
Anyone know how to do this? Maybe it could generate a new sheet for each, and then I print multiple sheets.
Thanks