Hi
I have data in cell A1, it is updated automatically, I want to copy and paste automatically from Cell A1 to B1 every 20 mins
please help me
Thanks
Hi
I have data in cell A1, it is updated automatically, I want to copy and paste automatically from Cell A1 to B1 every 20 mins
please help me
Thanks
Hi zit1343,
This may work, but it's at every 20 minutes starting at the hour
Please Login or Register to view this content.
I don't use formulas much so I don't know the code for "Do Nothing"
XLAdept
Last edited by xladept; 04-26-2012 at 07:42 PM. Reason: correction
Hi Thanks everymuch, is there a way to make it every 20 mins ?
Thanks
looks to me like it is?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Zit1343,
I couldn't find "do nothing" code so I've written:
It relies on frequent updating of A1 but it seems to work.Please Login or Register to view this content.
So, if you use macros, put this code in a module and put:
in B1Please Login or Register to view this content.
Last edited by xladept; 04-28-2012 at 10:03 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks