Moving all the cell content

[gane]

Hai iam new to excel and programming..
I was preparing a standadr template for our company purpose. I prepared 10
rows and 3 columns for data entry by other user and put a macro for deleting
blank cells. My problem is I want to move only the remaining rows centents
to some other defined loaction after deleting blank rows.
Please any one help me ....

 

[Don Guillett]

As always, post your coding efforts for comments and suggestions along with
details of what ranges you want.

 

[gane]

yeh i was not clear

I prepared from row 82
S.No Site Name Territory
1 ABC XYZ
2 DEF PQR
3
4
5

After entering datas i am going to delete(using code) all the rows
containing blank cells . After that it looks like

S.No Site Name Territory
1 ABC XYZ
2 DEF PQR

Now my problem is i want to move these contents(after deleting blank cells)
to other cell say from F64 i.e

S.No(F64) Site Name(G64) Territory(H64)
1(F65) ABC(G65) XYZ(H65)
2(F66) DEF(G66) PQR(H66)