Creating a form to enter data DanielWalters6 03.12.2005 17:05:01 I would like to be able to create a FORM on say sheet one. I would like to have about ten fields on the form I would like to then have a SUBMIT button which takes the data from the field and enters it into say sheet two. (Each column being a different field and each row being a seperate record.) Am able to do this in Access2003, but haven't used Excel for anything other than simple finances up-to-date. Hope you can help Daniel -- iPod's ROCK!

Re: Creating a form to enter data "Ron de Bruin" <rondebruin[ at ]kabelfoon.nl> 04.12.2005 16:14:18 Hi Look here http://www.rondebruin.nl/copy1.htm Use a row on the bottom of your form( you can hide that row) Add formula links (=c3) to the cells you want in that row and use this range to copy to sheet 2 -- Regards Ron de Bruin http://www.rondebruin.nl "DanielWalters6" <DanielWalters6[ at ]discussions.microsoft.com> wrote in message news:2DB91BCA-D751-462D-82B1-1918F0B1D8B2[ at ]microsoft.com... [Quoted Text] >I would like to be able to create a FORM on say sheet one. I would like to > have about ten fields on the form > > I would like to then have a SUBMIT button which takes the data from the > field and enters it into say sheet two. (Each column being a different field > and each row being a seperate record.) > > Am able to do this in Access2003, but haven't used Excel for anything other > than simple finances up-to-date. > > Hope you can help > > Daniel > > > -- > iPod's ROCK!

Re: Creating a form to enter data DanielWalters6 05.12.2005 17:33:02 Thankyou for your help :) -- iPod's ROCK! "Ron de Bruin" wrote: [Quoted Text] > Hi > > Look here > http://www.rondebruin.nl/copy1.htm > > Use a row on the bottom of your form( you can hide that row) > Add formula links (=c3) to the cells you want in that row and use this > range to copy to sheet 2 > > -- > Regards Ron de Bruin > http://www.rondebruin.nl > > > "DanielWalters6" <DanielWalters6[ at ]discussions.microsoft.com> wrote in message > news:2DB91BCA-D751-462D-82B1-1918F0B1D8B2[ at ]microsoft.com... > >I would like to be able to create a FORM on say sheet one. I would like to > > have about ten fields on the form > > > > I would like to then have a SUBMIT button which takes the data from the > > field and enters it into say sheet two. (Each column being a different field > > and each row being a seperate record.) > > > > Am able to do this in Access2003, but haven't used Excel for anything other > > than simple finances up-to-date. > > > > Hope you can help > > > > Daniel > > > > > > -- > > iPod's ROCK! > > >

RE: Creating a form to enter data JR 09.12.2005 18:52:02 I'll take Ron's idea on step further. Record a macro that when you hit the submit button, copies the hidden row, pastes it (as values) on the first row of sheet 2, then in the same place on sheet 2, inserts a row and returns to the form on sheet 1. This will allow users to just click a button and you will have the newest data always at the top of the page on sheet 2. "DanielWalters6" wrote: [Quoted Text] > I would like to be able to create a FORM on say sheet one. I would like to > have about ten fields on the form > > I would like to then have a SUBMIT button which takes the data from the > field and enters it into say sheet two. (Each column being a different field > and each row being a seperate record.) > > Am able to do this in Access2003, but haven't used Excel for anything other > than simple finances up-to-date. > > Hope you can help > > Daniel > > > -- > iPod's ROCK!

RE: Creating a form to enter data DanielWalters6 09.12.2005 23:15:02 Thankyou for your help. Futher comments are always greatly welcomed :) Have applied it, makes use of my database a lot easier (No scrolling down or END needed!) Thank's once again Daniel -- iPod's ROCK! "JR" wrote: [Quoted Text] > I'll take Ron's idea on step further. Record a macro that when you hit the > submit button, copies the hidden row, pastes it (as values) on the first row > of sheet 2, then in the same place on sheet 2, inserts a row and returns to > the form on sheet 1. > > This will allow users to just click a button and you will have the newest > data always at the top of the page on sheet 2. > > "DanielWalters6" wrote: > > > I would like to be able to create a FORM on say sheet one. I would like to > > have about ten fields on the form > > > > I would like to then have a SUBMIT button which takes the data from the > > field and enters it into say sheet two. (Each column being a different field > > and each row being a seperate record.) > > > > Am able to do this in Access2003, but haven't used Excel for anything other > > than simple finances up-to-date. > > > > Hope you can help > > > > Daniel > > > > > > -- > > iPod's ROCK!

RE: Creating a form to enter data Shine 20.07.2006 05:35:01 Hi, in relation to this discussion. I hope you can help me with this inquiry. The information in the Form (Sheet 1) is arranged vertically (row-type). I'd like to transfer the information to a database (Sheet 2) arranged horizontally (column-type). For new entries, I'd like the new entries to follow in the succeeding rows of the database. Need help. Not good with VB programming. Thanks. "DanielWalters6" wrote: [Quoted Text] > Thankyou for your help. Futher comments are always greatly welcomed :) > > Have applied it, makes use of my database a lot easier (No scrolling down or > END needed!) > > Thank's once again > > Daniel > -- > iPod's ROCK! > > > "JR" wrote: > > > I'll take Ron's idea on step further. Record a macro that when you hit the > > submit button, copies the hidden row, pastes it (as values) on the first row > > of sheet 2, then in the same place on sheet 2, inserts a row and returns to > > the form on sheet 1. > > > > This will allow users to just click a button and you will have the newest > > data always at the top of the page on sheet 2. > > > > "DanielWalters6" wrote: > > > > > I would like to be able to create a FORM on say sheet one. I would like to > > > have about ten fields on the form > > > > > > I would like to then have a SUBMIT button which takes the data from the > > > field and enters it into say sheet two. (Each column being a different field > > > and each row being a seperate record.) > > > > > > Am able to do this in Access2003, but haven't used Excel for anything other > > > than simple finances up-to-date. > > > > > > Hope you can help > > > > > > Daniel > > > > > > > > > -- > > > iPod's ROCK!