+ Reply to Thread
Results 1 to 3 of 3

Excel Help - advice on how to automate this task

  1. #1
    Registered User
    Join Date
    08-22-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Excel Help - advice on how to automate this task

    Hi Guys..

    At work, i use this spreadsheet to calculate information. I'm hoping you can assist by advising how I can automate this....

    Basically the way I have it designed at present....

    I dump the data into into one of the following page tabs...each tab represents a different week...So week 1, week 2, week 3 and week 4.

    On the main page - (a separate tab), i have formulas pointing to the relevant page tab to make calculations.....

    Because the data is updated each week, week 1 now becomes week 2, week 2 becomes week 3 etc...This is a problem because if I simply rename the page tabs to reflect the updated week, then the formulas from the main pages get mixed up because of the renamed tabs......To solve this, I am cutting and pasting from week 1 tab into week 2 and week 2 into week 3 tabs etc...

    I am wondering if there is a way to automate this process...or if anyone can advise a better solution....

    Hope this request makes sense .

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Excel Help - advice on how to automate this task

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel Help - advice on how to automate this task

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    Read this to understand why we ask you to do this.
    Remember what the dormouse said
    Feed your head

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1