How to auto fill cells with information from database in another sheet

Hi,

Im having trouble figuring out how to do some excel formatting to make my life a little easier. I actually have two questions. First, I have a database of info in the format as follows:

A B C D E
1 v w x y z
2 v w x y z
3 v w x y z

I have created an order form in another sheet and it requires the five pieces of data in each row. I would like to set the order form up so that I can manually enter v and then the remaining four pieces of data will automatically populate in the next four cells in the same row. Any help with this would be greatly appreciated!

I also am interested in a thread I read about an excel 2002 Template Wizard with data tracking. It is exactly what I have been looking for. Is it possible to create a form in excel 2010 and once i fill in the data, from say an order, it will automatically send the data to a database in another sheet and then somehow reset the order form back to blank?

Thanks
Jon

HI.

Regarding the first question you, than I see, the only difference are the three lines you use in your example, are the numbers in column A. All other elements are identical.
So the evidence presented to us, I think, that you can not do what you ask.

. But you can do what you ask with identifier numbers in column A. (See the sample ι send you)
If the data in cells are different, then it can be done using v, as you ask.
. On your second question, I do not think this can be done without using VBA.

Regards

yuyis, welcome to the forum

Thanks like those are always appreciated