+ Reply to Thread
Results 1 to 3 of 3

Changing Repetitive Entry’s

  1. 09-22-2008, 05:32 PM #1
    plrose
    plrose is offline
    Registered User
    Join Date
    04-20-2005
    Posts
    13

    Changing Repetitive Entry’s

    In the work book I have to create 52 weeks work sheets, In sheet one called “staffhours1” we have a formula =staffhours1!c7. When I copy this to a new sheet for week 2 is there a way that I can make the 1 change to a 2 for week 2 with out having to go into each cell and make the change manually to all of the different cells

    Peter
    Reply With QuoteRegister To Reply
  2. 09-22-2008, 05:36 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
    Maybe

    =INDIRECT("staffhours"&ROW(A1)&"!c7")
    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. 09-22-2008, 09:40 PM #3
    sglife
    sglife is offline
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    If your purpose is to copy the same formula to the same location of all the worksheets
    You can try to change your formula to

    Please Login or Register  to view this content.
    Then you can copy without change anything
    I need your support to add reputations if my solution works.

    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)

Similar Threads

  1. Repetitive Changing
    By boxcarracer5688 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2008, 04:42 AM
  2. Excel is converting .csv files
    By KRayKeeling in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-21-2008, 07:00 PM
  3. How to compute compound interest but with changing interest rates?
    By Frank87 in forum Excel General
    Replies: 3
    Last Post: 02-14-2008, 11:27 AM
  4. Changing rowsource of 2 listboxes based on 3rd listbox.
    By scadaman29325 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2008, 11:20 AM
  5. Negative date values without changing the Date System
    By softuser in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2007, 06:07 PM

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