Auto Data Fill Question? Newbie
I have a workbook to invoice customers. In the workbook I have multiple invoice sheets, a totals sheet, and a custname sheet. The custname sheet contains columb headings of Cust#, CustName,Address,and city_st_zip.
My question is: May I fill in or look up from a list in a cell (say c7) on the customer invoice sheets and fill (C7)with the customer number (Unique) found in another sheet called (Custname). After excel fills in this information I would like excel then to fill in the custname, address and city_St_zip.
Sheet 1 called Custname
A1- Cust#
B1- Custname
C1- Address
D1- City_St_zip
Sheet 2 called Invoive
Cell on Invoice sheet C7 would lookup from a list or be entered manually the cust# found on Sheet Custname.
Excel would then find data from the Custname sheet and copy it to cells on Invoice sheet.
G10 would contain the Custname based on the Cust# found inC7
G11 would contain the address
G12 would contain the city_St_zip all based on custnumber in C7
I have excel 2002 but need this to work with Excel 97.
I am really new at this and it has been driving me nuts Thanks in advance.
Thanks in advance
Chet
I have a workbook to invoice customers. In the workbook I have multiple invoice sheets, a totals sheet, and a custname sheet. The custname sheet contains columb headings of Cust#, CustName,Address,and city_st_zip.
My question is: May I fill in or look up from a list in a cell (say c7) on the customer invoice sheets and fill (C7)with the customer number (Unique) found in another sheet called (Custname). After excel fills in this information I would like excel then to fill in the custname, address and city_St_zip.
Sheet 1 called Custname
A1- Cust#
B1- Custname
C1- Address
D1- City_St_zip
Sheet 2 called Invoive
Cell on Invoice sheet C7 would lookup from a list or be entered manually the cust# found on Sheet Custname.
Excel would then find data from the Custname sheet and copy it to cells on Invoice sheet.
G10 would contain the Custname based on the Cust# found inC7
G11 would contain the address
G12 would contain the city_St_zip all based on custnumber in C7
I have excel 2002 but need this to work with Excel 97.
I am really new at this and it has been driving me nuts Thanks in advance.
Thanks in advance
Chet