Moving Cell up, down, left or right thru Macros
 

Hi,

I Want to use copy paste from one sheet to another thru Macro and when I use
the Macro it should copy after the end portion of the previous paste. The
cell should move down two places and then the home key to go to the A column
and then paste the text again. Everytime it should check the last row and
column where the text is and then go three rows down and then to A column. I
can use CRTL+END key thru Macro to go to the last used Cell, but do not know
the command to move the cell down three and then to A column.

Pls. suggest at the earliest.

Thanks in Advance.

Mustafa

Moving Cell up, down, left or right thru Macros
 

If you give us more detail about your source/destination sheets/ranges you
can get a much better solution but
this will go to the last cell in col A and down 3

Sub godownthree()
Range("a65536").End(xlUp).Offset(3).Select
End Sub

--
Don Guillett
SalesAid Software

"Mustafa S N" wrote in message
...
Hi,

I Want to use copy paste from one sheet to another thru Macro and when I
use
the Macro it should copy after the end portion of the previous paste. The
cell should move down two places and then the home key to go to the A
column
and then paste the text again. Everytime it should check the last row and
column where the text is and then go three rows down and then to A column.
I
can use CRTL+END key thru Macro to go to the last used Cell, but do not
know
the command to move the cell down three and then to A column.

Pls. suggest at the earliest.

Thanks in Advance.

Mustafa

Moving Cell up, down, left or right thru Macros
 

Guillett,

Thanks a lot for your help. It really worked.

Mustafa

"Don Guillett" wrote:

If you give us more detail about your source/destination sheets/ranges you
can get a much better solution but
this will go to the last cell in col A and down 3

Sub godownthree()
Range("a65536").End(xlUp).Offset(3).Select
End Sub

--
Don Guillett
SalesAid Software

"Mustafa S N" wrote in message
...
Hi,

I Want to use copy paste from one sheet to another thru Macro and when I
use
the Macro it should copy after the end portion of the previous paste. The
cell should move down two places and then the home key to go to the A
column
and then paste the text again. Everytime it should check the last row and
column where the text is and then go three rows down and then to A column.
I
can use CRTL+END key thru Macro to go to the last used Cell, but do not
know
the command to move the cell down three and then to A column.

Pls. suggest at the earliest.

Thanks in Advance.

Mustafa

Moving Cell up, down, left or right thru Macros
 

Glad to help but what you are trying to do could probably be done more
efficiently.


--
Don Guillett
SalesAid Software

"Mustafa S N" wrote in message
...
Guillett,

Thanks a lot for your help. It really worked.

Mustafa

"Don Guillett" wrote:

If you give us more detail about your source/destination sheets/ranges
you
can get a much better solution but
this will go to the last cell in col A and down 3

Sub godownthree()
Range("a65536").End(xlUp).Offset(3).Select
End Sub

--
Don Guillett
SalesAid Software

"Mustafa S N" wrote in message
...
Hi,

I Want to use copy paste from one sheet to another thru Macro and when
I
use
the Macro it should copy after the end portion of the previous paste.
The
cell should move down two places and then the home key to go to the A
column
and then paste the text again. Everytime it should check the last row
and
column where the text is and then go three rows down and then to A
column.
I
can use CRTL+END key thru Macro to go to the last used Cell, but do
not
know
the command to move the cell down three and then to A column.

Pls. suggest at the earliest.

Thanks in Advance.

Mustafa

Moving Cell up, down, left or right thru Macros
 

Guillet,

I will explain to you what I m trying to do.

Preparing a Job Order form using some fields. I want to copy the data of
the Job Order to another sheet or database and print the form when required
and save the form after each data.

I m also trying to prepare the same for the other department, so that they
can view only some details from the main database instead of all i.e. Price
factors and any remarks.

I have prepared a template file for the Job Order. If required I can send
you the file for your reference and thru which I can get more help from your
side.

Kindly let me know how I send you the file. Pls. reply me on any of my
email ID - , , .

Waiting for your response.

Thanks & Regards.

Mustafa

Moving Cell up, down, left or right thru Macros
 

Feel free to send a SMALL file directly to my address below.

--
Don Guillett
SalesAid Software

"Mustafa S N" wrote in message
...
Guillet,

I will explain to you what I m trying to do.

Preparing a Job Order form using some fields. I want to copy the data of
the Job Order to another sheet or database and print the form when
required
and save the form after each data.

I m also trying to prepare the same for the other department, so that they
can view only some details from the main database instead of all i.e.
Price
factors and any remarks.

I have prepared a template file for the Job Order. If required I can send
you the file for your reference and thru which I can get more help from
your
side.

Kindly let me know how I send you the file. Pls. reply me on any of my
email ID - , , .

Waiting for your response.

Thanks & Regards.

Mustafa