copy/paste data between worksheets
 

Hi,

A simple task, for those out there.

I have a workbook that contains 2 worksheets, worksheet 1 is a database of
info which is constantly being added to. What I want is a maco to select the
CERTAIN CELLS on the last row entered and paste this info into specific cells
ON THE NEXT AVAILABLE ROW in worksheet 2

For example, the next free line in worksheet 1 is line 34, so after the user
has input some data I want the macro to copy cells A34, G34, K34 and M34 . In
worksheet 2 the next available row is row 99, so I want this newly copied
data from workseet1 to be pasted into cells B99, H99, K99, and Y99.

This process will be repeated each time the user inputs new data into
worksheet 1 and clicks the macro.

Hope I have explained this ok, and thank you in advance

Rgds

Anthony