Macro for copying and pasting cells with data

Hi,

This is part of my macro

Please Login or Register  to view this content.

I want to change 2nd row

Please Login or Register  to view this content.

So that it copies all the columns from A to F , till the last row which has data in it.(The last row with data in all the columns will be the same)

Also I want to change

Please Login or Register  to view this content.

So that Columns A to F are pasted to the first empty row in all columns from A to F.(The first empty row in all the columns will be the same)

PLEASE HELP.

Thanks

hI,

I tried what you said. It says subscript out of range. I dont know why. Also I dont know much about writing macros. I just record and copy paste.

HTML Code: 

Both of these are names of different WORKBOOKS. I am using sheet one of both these workbooks. Sec 2 sheet 1 is the source and New. sheet 1 is the destination

As i told you i know nothing about writing macros.Isnt there a simple way for

Please Login or Register  to view this content.

to select the entire first empty row from A TO J instead of just selecting first empty cell in A.