Moving data from one worksheet to another whilst removing the data
 

I am trying to construct a form where using a button would allow information
from cells A5:E5 in sheet 1 to be copied over to Cells A6:E6 in sheet2, then
the data in sheet 1 would be romoved to allow the form to be used again.
when new data has been added to the form in sheet 1 it would then be copied
over to shhet 2 but placed in the next row down A7:E7.

I think this is possible with VBA but not sure where to start. i tried to
record a macro but this kind of went badly wrong!

Any help if it can be done or not would be greatly appreciated.

Moving data from one worksheet to another whilst removing the data
 

Maybe you could look at Debra Dalgleish's site:
http://contextures.com/xlForm02.html

Dobbin0_4 wrote:

I am trying to construct a form where using a button would allow information
from cells A5:E5 in sheet 1 to be copied over to Cells A6:E6 in sheet2, then
the data in sheet 1 would be romoved to allow the form to be used again.
when new data has been added to the form in sheet 1 it would then be copied
over to shhet 2 but placed in the next row down A7:E7.

I think this is possible with VBA but not sure where to start. i tried to
record a macro but this kind of went badly wrong!

Any help if it can be done or not would be greatly appreciated.

--

Dave Peterson

Moving data from one worksheet to another whilst removing the
 

Thank you very much Dave, this does the job and more!.

"Dave Peterson" wrote:

Maybe you could look at Debra Dalgleish's site:
http://contextures.com/xlForm02.html

Dobbin0_4 wrote:

I am trying to construct a form where using a button would allow information
from cells A5:E5 in sheet 1 to be copied over to Cells A6:E6 in sheet2, then
the data in sheet 1 would be romoved to allow the form to be used again.
when new data has been added to the form in sheet 1 it would then be copied
over to shhet 2 but placed in the next row down A7:E7.

I think this is possible with VBA but not sure where to start. i tried to
record a macro but this kind of went badly wrong!

Any help if it can be done or not would be greatly appreciated.

--

Dave Peterson