Using a macro to copying data from 1 sheet, and pasting into next empty cell

[Varial]

Hi,

I know that there are a few examples on how to do this but trial and error and proved to frustrating on this one.

I need to enter data into specific cells and when the macro is run, it copies this data and pastes into the next available(empty) row in my database sheet.

I copied the codebelow code from another thread, however i can't seem to be able to incorporate it into my specific example.

Please Login or Register  to view this content.

Please see below complete code i'm working with, the action needs to be completed twice for different data and then pasted into the emply cell Range for columns B and H:

Please Login or Register  to view this content.

Any help is greatly appreciated.

[AB33]

I do not know this line Acti

Please Login or Register  to view this content.

, but try this line

Please Login or Register  to view this content.

[AB33]

This is recorded macro code, so I have removed the selelction bit of the code, but have not tested it.

Please Login or Register  to view this content.

[Varial]

Thanks AB33,

The second line helped a treat....works perfectly.