.xls linking

M3mPh1z · 04-29-2009

Hey guys, me again.

So I was thinking about the solution I was trying to build, and access didn't seem like the right fit, now I have come up with something that would actually be simple and perfect IF it were possible, thats where you guys come in, lol.

Would it be possible for me to keep info in a .xls file as a database, then in another xls file, have a sort of form that can look into another excel file for information. e.g. I have a .xls with all my sales guys in it, and then in the form .xls I can have a drop down with a lookup of those guys.

Would something like that be possible? please say yes lol.

Yes I know the most simple way of doing it would be to program something small myself, but I have very basic experience and haven't done anything like that in over a year.

DIIRE · 04-29-2009

Hi M3mPh1z,

A pivot table in Excel based on the original form would do exactly what you want.

You just select the sales person and it would display the information for that person.

Please see the links below for how to use pivot tables.

Microsoft Excel Pivot Tables
http://peltiertech.com/Excel/Pivots/pivotlinks.htm

M3mPh1z · 04-30-2009

Thanks DIIRE, that seems to be what I was looking for, I cant yet see a way to actually use a drop down to navigate between records but I am still busy reading through those tutorials.

M3mPh1z · 04-30-2009

Disregard that, figured it out

M3mPh1z · 04-30-2009

With the drop down list it gives me, it allows me to select multiple records, but I will only need it to select single records, is there a way to change it to a normal single select type drop down? just for ease of use

DIIRE · 04-30-2009

I'm not actually sure without seeing the pivot table.

Generally though if the records all have a unique reference you could put this with your other drop down field and would be able to view specific records. Sorry that's so vague but without seeing the table and knowing exactly what you do, it's a little difficult.

M3mPh1z · 04-30-2009

Yea I understand, Thanks for your help.

04-29-2009	#1
M3mPh1z Bronze Member Join Date: Apr 2009 Posts: 66 PC Experience: l337	.xls linking Hey guys, me again. So I was thinking about the solution I was trying to build, and access didn't seem like the right fit, now I have come up with something that would actually be simple and perfect IF it were possible, thats where you guys come in, lol. Would it be possible for me to keep info in a .xls file as a database, then in another xls file, have a sort of form that can look into another excel file for information. e.g. I have a .xls with all my sales guys in it, and then in the form .xls I can have a drop down with a lookup of those guys. Would something like that be possible? please say yes lol. Yes I know the most simple way of doing it would be to program something small myself, but I have very basic experience and haven't done anything like that in over a year.

04-29-2009	#2
DIIRE Tech Support Team Join Date: Jan 2008 Posts: 2,362 PC Experience: Very Experienced	Re: .xls linking Hi M3mPh1z, A pivot table in Excel based on the original form would do exactly what you want. You just select the sales person and it would display the information for that person. Please see the links below for how to use pivot tables. Microsoft Excel Pivot Tables http://peltiertech.com/Excel/Pivots/pivotlinks.htm

04-30-2009	#3
M3mPh1z Bronze Member Join Date: Apr 2009 Posts: 66 PC Experience: l337	Re: .xls linking Thanks DIIRE, that seems to be what I was looking for, I cant yet see a way to actually use a drop down to navigate between records but I am still busy reading through those tutorials.

04-30-2009	#4
M3mPh1z Bronze Member Join Date: Apr 2009 Posts: 66 PC Experience: l337	Re: .xls linking Disregard that, figured it out

04-30-2009	#5
M3mPh1z Bronze Member Join Date: Apr 2009 Posts: 66 PC Experience: l337	Re: .xls linking With the drop down list it gives me, it allows me to select multiple records, but I will only need it to select single records, is there a way to change it to a normal single select type drop down? just for ease of use

04-30-2009	#6
DIIRE Tech Support Team Join Date: Jan 2008 Posts: 2,362 PC Experience: Very Experienced	Re: .xls linking I'm not actually sure without seeing the pivot table. Generally though if the records all have a unique reference you could put this with your other drop down field and would be able to view specific records. Sorry that's so vague but without seeing the table and knowing exactly what you do, it's a little difficult.

04-30-2009	#7
M3mPh1z Bronze Member Join Date: Apr 2009 Posts: 66 PC Experience: l337	Re: .xls linking Yea I understand, Thanks for your help.

Similar discussions...
Thread	Thread Starter	Forum	Replies	Last Post
Solved: Problems with Javascript and linking	Satyricon	Web Design	3	01-21-2009 01:40 AM
Solved: Dreamweaver -- Site Map Linking	scunco	Web Design	7	10-30-2008 08:42 PM
Solved: linking two video cards on one moniter	Zantutzuken	Graphics	5	07-16-2008 05:32 AM
Solved: Linking ur PC to your laptop	TheGrimReaper	Laptop Support	2	02-02-2006 06:11 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode