delect values in Sheet1 and copy values from Sheet2 and then paste in Sheet1 in place of the deleted

[drniranjan]

Hi Guys,
I have data in rows in excel sheet1.

Say the data sets in Sheet1 are:

12 11 23 4 1 44 9 10 21 10 13 23 19 44 5 8

I need to delet the content from 7th column onwards..then I have the values in A, B, C, D, E, and F columns and remaing are deleted. Here I deleted 10 points from '44' onwards..

I need to add some new values (not neccessarily the same 10 number of values that I deleted) in the delected portions i.e. from col G onwards from Sheet2.

But thing is, the data in Sheet2 are not in one row. I have data in two rows like this:

1 3 4 2 0 5 4 1 4
2 4 6 7 7 2 0 3 6

I want to place them in a single row by just copying the bottom line and pasting besides the top row.

Means, this should look like:
1 3 4 2 0 5 4 1 4 2 4 6 7 7 2 0 3 6

Now I need to copy the above line of the Sheet2 and to paste them besides the remaing of the row in Sheet1.

Which looks like:

12 11 23 4 1 44 1 3 4 2 0 5 4 1 4 2 4 6 7 7 2 0 3 6

Can please help me guys..I shall be thankful to you if could come up with a macro to do the above........

Regards, NP