Copy paste from workbook to another workbook

[drop05]

Using VBA, i want to copy values from entire row F, then when thats done move to G and do the same, then H and so on. With that paste into another workbooks worksheet and paste the values in F then G then H and so on, the shell for both worksheets are the same just workbook 1 has the values and workbook2 has the empty shell of it. Is there a way to do so in vba?

 

[johnnyL]

@drop05 What does "and so on" mean to you? All the way to the farthest right column of data?

You also need to provide the name of the workbook and sheet name that will be receiving the information. Are both workbooks located in the same folder? Will both workbooks be open, or will the workbook that is receiving the information be closed initially?