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

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 :)

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

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

--
Thanks,
Shane Devenshire


"ccreed61" wrote:

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 :)