LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Sub to transfer values and log the transfer

Looking for help with a sub to do this ..

Transfer the values:
In D15 to D11
In G19:G39 to E19:E39
then log the time/date of the transfers in cell E11 in this format:
"Last Transferred on 9:30 AM 24 Aug 2009"

D15, G19:G39 contain formulas whose returns are to be "copied/pasted as
values" into D11 & E19:E39

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to transfer values from one column to a big table? Piia Excel Discussion (Misc queries) 3 March 4th 09 03:31 PM
t-shit transfer - transfer Dpoly Excel Discussion (Misc queries) 1 August 11th 08 05:32 PM
How does one update and transfer values between cells and not the. JC Excel Discussion (Misc queries) 2 January 13th 05 07:15 PM
How does one update and transfer values between cells and not the. JC Excel Discussion (Misc queries) 0 January 12th 05 08:29 PM
Transfer values from column to row using macro! aiyer Excel Programming 1 February 12th 04 12:21 AM


All times are GMT +1. The time now is 02:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"