Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to transfer values and log the transfer
Try the below which works on the active sheet
Sub Macro() Range("D11").Value = Range("D15").Value Range("E19:E39").Value = Range("G19:G39").Value Range("E11") = "Last Transferred on " & Format(Now, "hh:mm AM/PM dd mmm yyyy") End Sub If this post helps click Yes --------------- Jacob Skaria "Max" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to transfer values and log the transfer
Many thanks, Jacob.
That does it well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to transfer values from one column to a big table? | Excel Discussion (Misc queries) | |||
t-shit transfer - transfer | Excel Discussion (Misc queries) | |||
How does one update and transfer values between cells and not the. | Excel Discussion (Misc queries) | |||
How does one update and transfer values between cells and not the. | Excel Discussion (Misc queries) | |||
Transfer values from column to row using macro! | Excel Programming |