+ Reply to Thread
Results 1 to 9 of 9

create duplicate sheets of the master sheet and update to link

  1. 03-14-2008, 05:28 PM #1
    TheBadouin
    TheBadouin is offline
    Registered User
    Join Date
    03-14-2008
    Posts
    3

    create duplicate sheets of the master sheet and update to link

    Hell all-

    Scenario
    Two workbooks each containing 25 sheets

    Workbook1 ~example sheets: Week 1 Total & Summary, Week 2 Totals & Summary etc...

    Workbook2 ~example sheets: Daily totals week 1, Daily totals week 2 etc...


    On workbook 1 I have the master sheet created with all needed link(s) to workbook 2 ~example workbook/sheet1 to workbook2/Sheet1

    Ok now to the questions
    Is there away to create duplicate sheets of the master sheet and update to link(s) to the proper corresponding sheet?? I don't care if i need to even buy some add-on I just need to get this off my desk

    If I have to do 25 sheets X40 cells by hand I may just cry

    Thank you
    The Badouin
    Reply With QuoteRegister To Reply
  2. 03-14-2008, 05:32 PM #2
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Welcome to the forum

    Can you please take a couple of mins to read the forum rules below and the message to cross posters.

    After that please add the link to the other excel forum you've posted this question to.

    Many thanks

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!
    Reply With QuoteRegister To Reply
  3. 03-14-2008, 05:58 PM #3
    TheBadouin
    TheBadouin is offline
    Registered User
    Join Date
    03-14-2008
    Posts
    3
    My bad I didn't realize they were the same forum since I registered with the same username.


    Thank you
    The Badouin
    Reply With QuoteRegister To Reply
  4. 03-14-2008, 06:01 PM #4
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Not the same forum.

    A lot of people answer questions on the same excel forums. If you bothered to read the message to cross posters you would know why it's frowned upon

    PS. Still waiting for you to add the link otherwise thread will be closed

    VBA Noob
    Reply With QuoteRegister To Reply
  5. 03-14-2008, 08:31 PM #5
    Simon Lloyd
    Simon Lloyd is offline
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    VBA Noob, apparently at MrExcel it isn't frowned upon!, i had a few negative pm's from a mod on there for posting cross posters links informing folk where these were.....weird that they condone it check their rules no mention!
    Not all forums are the same - seek and you shall find
    Reply With QuoteRegister To Reply
  6. 03-15-2008, 01:24 AM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    And on Oz, people are routinely banned for cross-posting without a link.

    I think the rule to follow is to follow the rules of the forum where you post.
    Reply With QuoteRegister To Reply
  7. 03-15-2008, 01:29 AM #7
    Simon Lloyd
    Simon Lloyd is offline
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    I have nothing against cross posting but i do mind when someone does not post the link(s) and i end up wasting my free time to help those who couldn't give a toss how many people work on it as long as they get their answer!

    No reflection on you The Badouin but it does compound things when so many do it then eventually you don't want to bother helping!
    Reply With QuoteRegister To Reply
  8. 03-15-2008, 01:46 AM #8
    TheBadouin
    TheBadouin is offline
    Registered User
    Join Date
    03-14-2008
    Posts
    3
    I believe this is what you are asking for....


    Cross Post
    http://www.mrexcel.com/forum/showthread.php?t=309106
    Reply With QuoteRegister To Reply
  9. 03-15-2008, 05:54 AM #9
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    have nothing against cross posting but i do mind when someone does not post the link(s) and i end up wasting my free time to help those who couldn't give a toss how many people work on it as long as they get their answer!
    Simon,

    This is why I police it. I don't want anyone here wasting time answering a question without the knowledge it has being cross posted elsewhere.

    TheBadouin,

    Thanks for the link

    VBA Noob
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1