I need to create a data base

I am setting up a data base, I want to have a single page where i input data.
When i get a new shippment in i want to click an 'add new' tab and enter data
such as. order number, Period, Delivery point, customer costs that sort of
thing. And this one data entry page will then input the info onto the
relevant worksheet/book.

I have seen it but i dont know how to do it, i am able to use excel can
anyone help please

What you want requires VBA. What entry do you make that determines the name
of the "relevant worksheet"? You must provide specifics about the layout
(what columns, what row(s) of the source data. The source data is what you
type. Also the destination layout and where you want the data put (first
empty row perhaps?). If you wish, send me your file or an example of your
file. I need just the locations and layouts, and I'll help with it.
Specify the version of Excel that your are running. My email address is
ottokmnop@comcast.net. Remove the "nop" from this address. HTH Otto
"Kernow1962" <Kernow1962@discussions.microsoft.com> wrote in message
news:78FBF30F-B9F7-4637-93BF-50F69405D0E4@microsoft.com...
>I am setting up a data base, I want to have a single page where i input
>data.
> When i get a new shippment in i want to click an 'add new' tab and enter
> data
> such as. order number, Period, Delivery point, customer costs that sort of
> thing. And this one data entry page will then input the info onto the
> relevant worksheet/book.
>
> I have seen it but i dont know how to do it, i am able to use excel can
> anyone help please

Plan your fields for the data and you can probably store it all in one
worksheet. Use the Data Form function as an easy data-entry screen. Label the
fields (names) as the first row of the data. Study the Data Form function and
you will find it an easy way to enter and retrieve data.

P.
--
Overcome Sales Barriers
http://salesbarriers.typepad.com/


"Otto Moehrbach" wrote:

> What you want requires VBA. What entry do you make that determines the name
> of the "relevant worksheet"? You must provide specifics about the layout
> (what columns, what row(s) of the source data. The source data is what you
> type. Also the destination layout and where you want the data put (first
> empty row perhaps?). If you wish, send me your file or an example of your
> file. I need just the locations and layouts, and I'll help with it.
> Specify the version of Excel that your are running. My email address is
> ottokmnop@comcast.net. Remove the "nop" from this address. HTH Otto
> "Kernow1962" <Kernow1962@discussions.microsoft.com> wrote in message
> news:78FBF30F-B9F7-4637-93BF-50F69405D0E4@microsoft.com...
> >I am setting up a data base, I want to have a single page where i input
> >data.
> > When i get a new shippment in i want to click an 'add new' tab and enter
> > data
> > such as. order number, Period, Delivery point, customer costs that sort of
> > thing. And this one data entry page will then input the info onto the
> > relevant worksheet/book.
> >
> > I have seen it but i dont know how to do it, i am able to use excel can
> > anyone help please
>
>
>