Moving data from one worksheet to another whilst removing the data

  • Thread starter Thread starter Dobbin0_4
  • Start date Start date
D

Dobbin0_4

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying data from one workbook to another dependent on user select 1
automatically move data to another file 1
Copying Data from One Worksheet to Another 2
From Rows to column 3
Moving data from one sheet to another 5
Moving data from one sheet to another 2
Gathering Data using excel 1
Transfering of data from 1 worksheet to another 1

Back
Top