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
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,Originally Posted by Pindacko
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.
In the excel file it shows what I am trying to do.
Thanks
Hi,Originally Posted by Pindacko
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 aswhich tests cell A1 and sets or hides the Button as required.Please Login or Register to view this content.
Such code could test any condition and Hide the button as required.
Is this what you are looking for?
---
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,Originally Posted by Pindacko
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?
---
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.Originally Posted by Pindacko
---
$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.Originally Posted by Bryan Hessey
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.'Originally Posted by Pindacko
Will use W and X, which should keep it clear of your data in Z.
---
ok - for the Form codeOriginally Posted by Pindacko
to be added to the code where youPlease Login or Register to view this content.
Private Sub CommandButton1_Click()
~~
SaveValues txtPart, Label4, DTPicker1.Value
etc, and fort the ThisWorkbookshould go close.Please Login or Register to view this content.
Let me know how you go.
---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks