Results 1 to 1 of 1

From Two Sheets; Copy Sheets but Automatic Generate +1 on two cells' formula - Possible?

Threaded View

  1. #1
    Registered User
    Join Date
    05-09-2013
    Location
    Jeddah
    MS-Off Ver
    Excel 2010
    Posts
    9

    From Two Sheets; Copy Sheets but Automatic Generate +1 on two cells' formula - Possible?

    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.
    Attached Files Attached Files
    Last edited by juanl; 05-09-2013 at 01:18 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1