Moving all the cell content
 

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 ....

Moving all the cell content
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gane" wrote in message
...
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 ....

Moving all the cell content
 

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)


"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gane" wrote in message
...
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 ....