software

How do I copy the cells A9,B9,C9 and D9 to A16,B16,C16 and D16 when I
press the key (F9) ? Afterwards I type new data in the cells A9 till D9
and press again (F9), then I want that the stuff from A16 till D16 go to
A17 till D17 and A9 till D9 again to A16 till D16.
Sorry for my bad english and hope that anyone helps me.
Thanks--
Narkom
------------------------------------------------------------------------
Narkom's Profile: www.excelforum.com/member.php...oamp;userid=32642
View this thread: www.excelforum.com/showthread...hreadid=524486Start out by assigning F9 to your macro. Probably in the Workbook_Open
procedure.

Application.OnKey quot;{F9}quot;, quot;MyMacroquot;

Then have a macro called 'MyMacro' or whatever that does this...

Range(quot;A16quot;).EntireRow.Insert
Range(quot;A99quot;).Copy
Range(quot;A16quot;).PasteSpecial xlValues
Application.CutCopyMode = False
Range(quot;A9quot;).SelectHope this helps,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;Narkomquot; wrote:

gt;
gt; How do I copy the cells A9,B9,C9 and D9 to A16,B16,C16 and D16 when I
gt; press the key (F9) ? Afterwards I type new data in the cells A9 till D9
gt; and press again (F9), then I want that the stuff from A16 till D16 go to
gt; A17 till D17 and A9 till D9 again to A16 till D16.
gt; Sorry for my bad english and hope that anyone helps me.
gt; Thanks
gt;
gt;
gt; --
gt; Narkom
gt; ------------------------------------------------------------------------
gt; Narkom's Profile: www.excelforum.com/member.php...oamp;userid=32642
gt; View this thread: www.excelforum.com/showthread...hreadid=524486
gt;
gt;