+ Reply to Thread
Results 1 to 11 of 11

Macro to copy cell data on a set date

  1. #1
    Registered User
    Join Date
    12-05-2006
    Posts
    81

    Macro to copy cell data on a set date

    Is there a way to copy data from one cell to another on a set date in excel.
    If anyone could help with vba

    Thanks

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Pindacko
    Is there a way to copy data from one cell to another on a set date in excel.
    If anyone could help with vba

    Thanks
    Hi,

    was that to run once only the first time the book was opened, or the sheet activated, or figures entered?

    Is there a definate entry in one of the cells so that the macro can detect it has happened and not do it again, or would you wish it to keep updating all day?

    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    12-05-2006
    Posts
    81

    Have a look and see if this makes sence

    In the excel file it shows what I am trying to do.

    Thanks
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Pindacko
    In the excel file it shows what I am trying to do.

    Thanks
    Hi,

    Looking at your sheet, it appears that what you are trying to do is to display the Button when you are within the '10 Days'.

    If this is so then, IF the button is created under Control Toolbox then it would have proerties that included 'Visible' (View, Toolbars, Control Toolbox, and on that, Design Mode, rightmouse a made Button and Properties)

    This can be set with a small piece of code such as
    Please Login or Register  to view this content.
    which tests cell A1 and sets or hides the Button as required.

    Such code could test any condition and Hide the button as required.

    Is this what you are looking for?

    ---

  5. #5
    Registered User
    Join Date
    12-05-2006
    Posts
    81

    copy data from one cell to another on a set date in excel

    No what I want to do is use the form to enter the part number select cell and on date pick have it populate the cell.

    Thanks

  6. #6
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Pindacko
    No what I want to do is use the form to enter the part number select cell and on date pick have it populate the cell.

    Thanks
    Hi,

    Ok - so you select the 10 day button to activate the displayed '10 day breakpoint' window, enter the part and then click the 'Start Timer'.

    The new part would need to be assigned a Row (either in the normal sheet, or in (say) Sheet4 designated for holding only these parts), the timer-start date + 10 days would be recorded on the same row.

    The Workbook open routine can then scan the dates held to see which are not < today() -- such items are then transferred to the required area and removed from the 'newstart' holding area.

    does this sound like what you are looking to do?

    ---

  7. #7
    Registered User
    Join Date
    12-05-2006
    Posts
    81

    Macro to copy cell data on a set date

    Yep you got it man

  8. #8
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Pindacko
    Yep you got it man
    ok - if you want me to write the code to release after ten days you will need to specify where the Part and Date are (to be) stored, and how to tell which column it will be released into.

    ---
    $k$26 ?

  9. #9
    Registered User
    Join Date
    12-05-2006
    Posts
    81
    Quote Originally Posted by Bryan Hessey
    ok - if you want me to write the code to release after ten days you will need to specify where the Part and Date are (to be) stored, and how to tell which column it will be released into.

    ---
    $k$26 ?
    Ok if you look @ 47 E RR and click on 10 day you will see that column will change to what ever selected As for the part and date they can be stored off to the right any where.
    Thanks a lot for your help on this.

  10. #10
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Pindacko
    Ok if you look @ 47 E RR and click on 10 day you will see that column will change to what ever selected As for the part and date they can be stored off to the right any where.
    Thanks a lot for your help on this.
    ok - no luck with the 10 day, response was 'Could not load an object because it is not available on this machine.'

    Will use W and X, which should keep it clear of your data in Z.

    ---

  11. #11
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Pindacko
    Ok if you look @ 47 E RR and click on 10 day you will see that column will change to what ever selected As for the part and date they can be stored off to the right any where.
    Thanks a lot for your help on this.
    ok - for the Form code

    Please Login or Register  to view this content.
    to be added to the code where you

    Private Sub CommandButton1_Click()
    ~~
    SaveValues txtPart, Label4, DTPicker1.Value

    etc, and fort the ThisWorkbook
    Please Login or Register  to view this content.
    should go close.

    Let me know how you go.
    ---

+ 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