MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto Filling

Posted by Chris Cantasano on January 31, 2002 12:08 PM

I have built a simple data base on a worksheet, on another worksheet i have built an invoice. Im wondering how could i enter just the style number on my invoice and have the description, price, etc fill in automatically in the remaining places? Can this be done without using macros?

Posted by anno on January 31, 2002 1:32 PM

if i understand what you want correctly you can do this without vba.
in the first cell that needs to be filled in on your invoice, refer to the cell with the style number with an if statement which will return a value from a list(ie. description, price,etc)when the style number is entered. do the same for each cell which requires an entry.
for example, assuming the cell to contain the style number is A1, the first item to be entered (description)is in B1 and your list is in C1-C3, in B1 put =IF(A1,C1). for the second item to be added (let's say it's in B2) do the same - =IF(A1,C2).
this is a simple idea but i'm not sure i've explained it that well so if it makes no sense let me know and i'll have another try.

Posted by Laertes on January 31, 2002 4:01 PM