software

I need a macro that will take whatever I highlight (left click) and
append it to another file. Can that be done?

Thank you for your help.

Ken--
sungen99
------------------------------------------------------------------------
sungen99's Profile: www.excelforum.com/member.php...foamp;userid=9144
View this thread: www.excelforum.com/showthread...hreadid=539344The macro recorder is your friend. Just modify
Sub Macro2()
'
' Macro2 Macro
' Macro recorded 5/5/2006 by Don Guillett
'

'
' Range(quot;A13:A14quot;).Select
' Selection.Copy
'Range(quot;D12quot;).Select
' ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

sub copyselected()
selection.copy range(quot;d12quot;)
end sub
--
Don Guillett
SalesAid Software

quot;sungen99quot; gt; wrote in
message ...
gt;
gt; I need a macro that will take whatever I highlight (left click) and
gt; append it to another file. Can that be done?
gt;
gt; Thank you for your help.
gt;
gt; Ken
gt;
gt;
gt; --
gt; sungen99
gt; ------------------------------------------------------------------------
gt; sungen99's Profile:
gt; www.excelforum.com/member.php...foamp;userid=9144
gt; View this thread: www.excelforum.com/showthread...hreadid=539344
gt;