Tables and Queries

ktobiano

New Member
Joined
Jul 6, 2004
Messages
8
I have several tables in separate workbooks that different users populate based on the stage that a project is in.
MainTbl: holds basic info on a project
QuoteTbl: info on status of the project's quote info
EnggTbl: info on engg for projects
FabTbl: info on fabrication for projects
AdminTbl: info on admin paperwork for projects
MoneyTbl: info on income/expenses for a project (PnL)
ShippingTbl: delivery info for projects
and others

I want to use MainTbl to populate basic project info in other tables - not all projects will have data recorded in ever table.
For example, when we enter the QuoteID in MainTbl with customer and project info, I want to be able to select the QuoteID in the QuoteTbl and have it populate select info in 2 or 3 other columns into the QuoteTbl.

Finally, I want to be able to run a query in another separate workbook combining ALL table info into one comprehensive table for posterity.

I have never used queries in excel and I have no idea how to do this I just know it's possible and need help understanding how the relationships work.

I'm hoping with this info I'll be able to figure out how to run custom queries (reports) for various division managers only showing the info that they need.

Ultimately, I'll have to figure out how to purge old project info so the files don't get exceedingly large and full of completed job info.

All suggestions are greatly appreciated. If this is too simple and I'm just being a nerd, can someone point me to a very easy to understand tutorial on what excel queries are and how to create and manipulate them?

I do have experience using access and could work magic with it, but I just can't seem to figure this out on my own.

Thanks! Karen
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Do I need to reword my question to get a response? Any suggestions on where I can go to get the help or training I need would be greatly appreciated.
 
Upvote 0
To simplify my question, where can I go to understand Excel Queries? I'm not able to find tutorials that explain how queries work. They all seem to assume there is already a basic understanding and my frustration is growing exponentially!

I really just need someone to point me in the right direction Please!
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top