Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a spreadsheet
I need to know where I may find information on creating a
spreadsheet for my business. What I need it to do is automatically enter information to selected cells by typing in a 9 digit number. This would be nice if it could be used in conjunction with an address book. I know that Quattro Pro could be set up this way but I have no idea how to start or if Excel can do it. My main problem is I know what I need it to do but do not have the knowledge of the correct language and terms that are used in the books or articles I have read. I work with Excel every day but very very generic spreadsheets. If anyone could help me find this information I would appreciate it. Thanks Naomi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a spreadsheet
In excel, unless you are going to write code/do programming, you would need
to create a table with your 9 digit numbers on the leftmost column and the remainder of the data in columns to the right. This would essentially represent you address book. Then in your worksheet where you want to enter the 9 digit number and return data, you would put in formulas similar to (assume 9 digit number is enter in C9): =if(C9="","",Vlookup(C9,Table1,2,False) Where Table1 is the range reference to your Address book data such as DataSheet!A1:Z500 This formula would look down column 1 of the sheet named Datasheet, find the 9 digit number and return the corresponding value in that row found in column B (the 2 as the third argument of the vlookup function, a 3 would get the data from column 3 as an example). So look in Excel help for Vlookup. -- Regards, Tom Ogilvy "Naomi" wrote in message ... I need to know where I may find information on creating a spreadsheet for my business. What I need it to do is automatically enter information to selected cells by typing in a 9 digit number. This would be nice if it could be used in conjunction with an address book. I know that Quattro Pro could be set up this way but I have no idea how to start or if Excel can do it. My main problem is I know what I need it to do but do not have the knowledge of the correct language and terms that are used in the books or articles I have read. I work with Excel every day but very very generic spreadsheets. If anyone could help me find this information I would appreciate it. Thanks Naomi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Spreadsheet Reports | Excel Discussion (Misc queries) | |||
Creating a master spreadsheet | Excel Discussion (Misc queries) | |||
Creating a spreadsheet | Excel Discussion (Misc queries) | |||
Creating a spreadsheet that will filter | New Users to Excel | |||
Creating Consolidated Spreadsheet... | Excel Discussion (Misc queries) |