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