need to build a "form" that dumps data entered into another worksh

  • Thread starter Thread starter ccreed61
  • Start date Start date
C

ccreed61

I know this is possible in Access however not everyone in our office has
Access. So is it possible to use worksheet 1 to build a "form" that dumps
entered data into a database on worksheet 2. The "form" in worksheet 1 needs
to be printable and data in worksheet 2 needs to be stored. Thanks for your
help in advance :)
 
Hi,

You could do this with VBA but we would need to know which cells in the form
sheet need to go to which cells in the Database sheet. If sheet1 has the
form and sheet2 the database then a lot of lines such as this. Where you are
sending the data from cell C12 on the form to first empty cell in column A of
the database sheet.

Sub DumpData()
Sheets("Sheet2").Range("A2").End(xlDown).Offset(1,0) =
Sheets("Sheet1").Range("C12")
.....
End Sub
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying data in a form into an alternative Workbook 1
Hide cell unless value entered into any cell on a row 3
Need your help Excel Worksheet/Form 1
VBA - retrieve data on last create named range from previous inserted named range 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Create a yes no message on a command button on click 0
How to insert new worksheet based on # of rows in a data sourch 2

Back
Top