Excel Adding Information in Multiple tables

[damaruk]

Could any one please tell me how you can transfer information from one sheet in a workbook to another so that the information is transfered to the next free cell, row or column in the selected sheet.

ie) I want to be able to transfer information for certain cells in a sheet via a macro so that informationn is recorded in another sheet for a different porpose.

Thanks

mark [sig][/sig]