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.

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

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