Excel Gurus?????

[b.latiolais]

then yeah, its going to be long, but it will work. I have an example with 4 options if you want to see it. it shouldnt take you very long to write one for 40.

My problem is eventually this would be something I would want to standardize and the menu options could grow to about 500.

Thank you for the help though.

[Loneaggie]

You have much experience with Access?

Not recently, I did a bunch with it back in the late 90's..... geez I'm old lol. Fundamentally it hasn't changed much. If you want PM me with what you're trying to accomplish overall and I'll see if I can provide a little more guidance.

[BSOB]

My problem is eventually this would be something I would want to standardize and the menu options could grow to about 500.

Thank you for the help though.

no problem.

[PSD Ryan]

What exactly are you doing? If it's going to keep expanding, you may want to just script it all in PHP and set up an SQL database. No programs to buy. It would be like looking at a web page. Dunno if that would be the best way for you or not.

[Loneaggie]

What exactly are you doing? If it's going to keep expanding, you may want to just script it all in PHP and set up an SQL database. No programs to buy. It would be like looking at a web page. Dunno if that would be the best way for you or not.

About half the "organization" windows desktop applications are quite literally .NET hitting embedded versions SQL Server Express... makes me sick. Yeah depending on what he needs it for a small web app with CRUD could work.

[Lynda]

What exactly are you doing? If it's going to keep expanding, you may want to just script it all in PHP and set up an SQL database. No programs to buy. It would be like looking at a web page. Dunno if that would be the best way for you or not.

Yup - what he said. Especially if you need to consider access to or data entry from multiple users. Intuit offer an incredible online, easily customizable database if you don't want to get too technical.

We're probably not helping much are we. lol!

[b.latiolais]

Yup - what he said. Especially if you need to consider access to or data entry from multiple users. Intuit offer an incredible online, easily customizable database if you don't want to get too technical.

We're probably not helping much are we. lol!

Actually very helpful. Making me realize I need to go ,"bigger" should I say? I knew excel was not the answer to what I'm trying to do, I was simply trying to make it work for now.

I do need something that would be more data entry based by multiple users in several locations. So the recommendations on which programs are the best/easiest to use is greatly appreciated.

I'm gonna look into Intuit. Any others I should consider?

[Lynda]

It's been a few years since I used Intuit's db. It's called Quickbase. I developed a huge, multi-level, multiple user db. It cost $250 a month, but there are smaller packages and things have probably changed since then. They offer a 30 day free trial. You'll be able to import your existing data.

Google other online databases too. There's probably all sorts available these days. I do everything in the cloud and couldn't imagine going back to local server based solutions.

Hope you find something to fit your needs and pocket!

[PSD Ryan]

AAAH I hate the term cloud
Edit: I also hate upgrading my OS and have proprietary driver problems that make me have to do all kind of extra stupid coding to make it work again. I don't know why I upgrade...it's fixing what ain't broke.

PHP/MySQL on his company web host will fit everything he needs and not cost a penny extra.

[Casey]

I bet you can pull it off with an index/match combination. It will take the value you select and pull data from another table based on that value. I do it all the time. Give me more particulars.

I also use access and it's certainly cut out for this, but you'd be surprised what you can do with excel.

[Eagles1181]

If you can put the data into a table, you might be able to use VLookup and HLookup. Not sure if it will work or not, but it is an idea.

Eagle

[Lynda]

If you can put the data into a table, you might be able to use VLookup and HLookup. Not sure if it will work or not, but it is an idea.

Eagle

I tried those formulas earlier and couldn't get it to work Someone else prolly could.

At the end of the day, it gets dark, AND, the resources and skill sets at your disposal will dictate your way forward. The good news is there are plenty of solutions, as the TBH brain trust has demonstrated.

[ecallarman]

its pretty simple actually... You actually use a VLOOKUP formula. It looks at your selcetion that you have made from the drop down list and returns information you designate as associated with that selection. Let me know if you need more help and I will send you a sample formula from my estimating speadsheet that I use.

[Snakelover]

If I understand your question correctly, you can use Excel's VLOOKUP function for that. All it does is makes it where you can enter data in one cell and the VLOOKUP or HLOOKUP function drops data that corresponds to that into other cells of your choosing. For instance, you can make a table of thousands of inventory parts numbers, descriptions and pricing. Then you can create a page where you can enter a parts number in a cell and VLOOKUP will drop the corresponding description and pricing in adjacent cells so that you don't have to go look them up on the table manually. Hope that makes sense.

You can also use it for things like names, addresses, phone numbers... any data that can be listed in table format.

[Snakelover]

its pretty simple actually... You actually use a VLOOKUP formula. It looks at your selcetion that you have made from the drop down list and returns information you designate as associated with that selection. Let me know if you need more help and I will send you a sample formula from my estimating speadsheet that I use.

You beat me to it! I actually just recently learned about VLOOKUP by helping my daughter do her college homework!