+ Reply to Thread
Results 1 to 2 of 2

Use button on sheet to transfer data based on todays date

  1. #1
    Qaspec
    Guest

    Use button on sheet to transfer data based on todays date

    I have data on sheet1 that I'd like to transfer to sheet2. The destination
    cells are the same but the referenced cells will change depending on what
    month we are currently in. Here is what I need. I want to use a command
    button on sheet 2 to do this. Please Help! If more explanation is necessary I
    will be more than happy to clarify.

    Detination cell sheet2 G9

    is today is in
    Jan05 sheet1 a38
    Feb05 sheet1 b38
    mar05 sheet1 c38
    apr05 sheet1 d38
    ....until dec
    jan06 sheet1 a74
    feb06 sheet1 b74
    ....until dec
    jan07 sheet1 a110
    feb07 sheet1 b110
    .....until dec
    jan08 sheet1 a146
    feb08 sheet1 b146
    ....until dec

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello,

    What you want to do can be done. In order for me to help you, if you could e-mail copies of the worksheets that would be helpful. My e-mail is LeithRoss@aol.com

    Sincerely,
    Leith Ross

+ 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