+ Reply to Thread
Results 1 to 3 of 3

Batch Sheet Copy Iterate Forumla

  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    Shelby, MI
    MS-Off Ver
    Excel 2003
    Posts
    4

    Batch Sheet Copy Iterate Forumla

    I am trying to copy a formatted sheet in my workbook to the remaining 1000 sheets while preserving the formatting.

    On the summary page within A13:A1012 can be found the names of the corresponding sheets and the link to said pages. In each of the rows of A13:A1012 I am referencing cells from the individual pages. Currently I have set up the first page with all the formatting that I need, but when I try to copy this page to the remainder of the sheets it obviously only copies the exact data it doesn't iterate to the next row/sheet.

    I hope this is clear. I cannot upload the file as it is too large. But if anyone could offer some clarification I would really appreciate it!

    Patrick

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Batch Sheet Copy Iterate Forumla

    Most of this forum's helpers are no clairvoyants.

    Post a sample workbook containing 3 sheets in which you clarify what you want.



  3. #3
    Registered User
    Join Date
    10-27-2011
    Location
    Shelby, MI
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Batch Sheet Copy Iterate Forumla

    Here is an upload of the file.

    Basically I have already set up sheet '10' exactly as it should be so that all of its values populate correctly in 'Main' Row A13. I now need to copy sheet '10' style and formulas to the remainder sheets but so that they adjust to their corresponding names/rows. i.e. so sheet '20' would now populate with the item description from 'Main' A14 and in turn sheet '20' will return data values for 'Main' I14
    Attached Files Attached Files

+ Reply to Thread

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