If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Working with Excel and Microsoft Groove to have a database of cust
Hi, I have just started with a company which uses Excel and Microsoft Groove
for all their database & forms. I am looking to create a database of customers' name, address, & ID # in excel and then find a way to create a form in excel that will pull all the customer's info stated above and put them into their respective cells. So, when I pull a form, I start typing a customer name and excel goes to this database finds a matching customer and fills in the address, City, State, & ID on the form. Does anyone know if this is an easy thing to do in Excel? Can anyone show me how? Thanks! |
#2
|
|||
|
|||
Working with Excel and Microsoft Groove to have a database of cust
katiapro93,
Sounds like you meant to post to the Excel newsgroup. In the Microsoft interface scroll a bit further down, you landed on the Microsoft Access newsgroup a relational databse software. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "katiapro93" wrote in message ... Hi, I have just started with a company which uses Excel and Microsoft Groove for all their database & forms. I am looking to create a database of customers' name, address, & ID # in excel and then find a way to create a form in excel that will pull all the customer's info stated above and put them into their respective cells. So, when I pull a form, I start typing a customer name and excel goes to this database finds a matching customer and fills in the address, City, State, & ID on the form. Does anyone know if this is an easy thing to do in Excel? Can anyone show me how? Thanks! |
#3
|
|||
|
|||
Working with Excel and Microsoft Groove to have a database of cust
On Mon, 2 Feb 2009 19:56:00 -0800, katiapro93
wrote: Hi, I have just started with a company which uses Excel and Microsoft Groove for all their database & forms. I am looking to create a database of customers' name, address, & ID # in excel and then find a way to create a form in excel that will pull all the customer's info stated above and put them into their respective cells. So, when I pull a form, I start typing a customer name and excel goes to this database finds a matching customer and fills in the address, City, State, & ID on the form. Does anyone know if this is an easy thing to do in Excel? Can anyone show me how? Thanks! I would suggest that if you want to do this in Excel rather than in Microsoft Access (the subject of this newsgroup) that you post in an Excel forum. The webpage can be confusing and may have misled you - scroll down the subject areas and find an appropriate Excel group. That said... you really should consider using Access for this purpose. Excel is a spreadsheet, a very good one; Access is a database development environment. "You can drive nails with a crescent wrench but that doesn't make it a hammer" - and you can create databases in Excel, in a sense, but that doesn't mean that it's the best program for that purpose! Here's some resources for Access if you decide to pursue this option: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|