Can anyone help me if this is possible:
Sheets involved in this workbook are ‘Instrument Sheet’ & ‘Instrument List Sheet’, If ‘Instrument List Sheet’ listed 100 Nos. I should make 100 Nos of Sheets. of ‘Instrument Sheet’.
Basically, other Details are the same and I just have to change 2 Cells per ‘Instrument Sheet’ for example; 1st cell is for Page Nos. which are “1,2,3…100 OF 100” while another cell is for Instrument Name which I used to put simple formula ‘=Instrument List Sheet!A1’ listed from ‘Instrument List Sheet’ and that will be followed on the next Instrument sheets by =Instrument List Sheet!A2,A3,… and so on. I want to save time doing this, is there a way we could do copying sheet then automatically geneating +1 on the 2 cells' formula? Thanks.
Bookmarks