Copy Row To Another Worksheet

[Grof]

Hi,

I have a worksheet (products.xls) with products and prices, and
second worksheet (template.xls) is template for printing.

I want to select one cell in products.xls then press some shortcut
on keyboard (lke Ctrl+Shift+X, or something that is unssigned)
and copy that row to specified row in template.xls without
'Copy' switching to template.xls and 'Paste'.

If prices change in products.xls, template.xls must contains old prices.

Thanks in advanced.

 

[Paul Morgan]

you need all these codes to do what you want

Function LastRow(sh As Worksheet)
Sub copy_to_another_workbook()
Function bIsBookOpen(ByRef szBookName As String) As Boolean

here is the site for these codes


http://www.rondebruin.nl/copy1.htm#workbook