Hi, If you provide us a copy of your current macro cade, we can give you ideas on how to modify it to do what you want. Regards - Dave.
> Date: Mon, 15 Sep 2008 18:17:10 -0700> Subject: $$Excel-Macros$$ Copy Paste > Macro - Excel 2003> From: [EMAIL PROTECTED]> To: > excel-macros@googlegroups.com> > > Hello all,> > Here's what I am trying to > accomplish...> > I've create a macro to place the current time in a > cell...say A1...and> I've created a command button to do this...so every time > I click the> command button the updated time will be displayed in A1 and only > A1.> > What I want to be able to do is that everytime I click on the command> > button to update the time in A1 it copies that information to another> > cell...say B1...and once B1 has been filled with the same time that> was just > updated in A1 the next time I go to update the time in A1> then that time is > entered into cell B2...and then next update entered> in A1 also appears in > B3, etc. Essentially, this creates a list of all> the times that were > displayed in A1.> > Thank you very much in advance for any advice on how to > accomplish> this!!> > > > > > _________________________________________________________________ It's simple! Sell your car for just $40 at CarPoint.com.au http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
