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