tables and relationships

Hello everyone, long time no post! I have a situation, which I would think can be solved rather simply, but I can't figure out a way to do it. I have several POS systems and how much they are able to sell. We also have the knowledge of how much volume we do every weekday, every month that...

Hello, The issue: At my company, we utilize SharePoint co-authored Excel workbooks to retrieve, store, and manipulate data. Aside from that being problematic in and of itself, users want to see populated data in one workbook based on data from another workbook. Essentially, a formula looks like...

So I have to create what will be in essence a small database in excel for reasons far too long to go into. My thought is to create 3 tabs with 3 named tables then create a power pivot to drill down and return the needed information. If there is a better way to do this PLEASE feel free to tell...

Context at the bottom. I am hoping you are able to assist me with an issue I am struggling to resolve. I have data collected in multiple separate SharePoint lists (identical structure) which can change dynamically which is causing me issues in consolidating all the data in to one table within...

I have several tables on one sheet stacked on top of one another. There is one (query) table in the middle of the other tables in which the properties are set to delete unused cells as information in the table changes. The tables below this table are filtered. I have never had a problem...

Hello Everyone, Really need an assist on this. I am building a workflow management tool tracking availability and workload of several workers across many projects. I need to build a table, without vba if at all possible, that automatically populates comparing to separate copies of a report and...

Hi Everyone,. I am working on creating an Earned Value workbook to track the progress of several projects. Each worksheet in my book represents a Project which usually has some subtasks with their own budget and schedule. I have a summary/input table setup at the top left of my worksheet...

Hey, I have a table as follows: <tbody> Activity Duration (days) Date Start Date A 2 today() today() B 4 today()+previous C 1 today()+previous D 7 today()+previous </tbody> There are a number of activities that require a set amount of days to complete and a...

I have two Excel tables formatted as tables, Table1 and Table2. They both have a field "Case Number." Some case numbers are the same in both tables, and some are different. I also have a field in Table1 called Table1Office and a field in Table2 called Table2Office. I want to create another table...

Hi, I have Table 1 and Table 2. Both have different data. I want to create a table 3 that includes both table 1 and 2. The end goal is for table 3 to automatically update when I update table 1 or 2. Below is a view Would appreciate all the help! thank you!

Hello Everyone, I am new to this so apologies for any bad form in Forum etiquette. I currently have a master table on one sheet and I am looking to create a couple of other tables on separate sheets. I am looking to link the tables so that the new one can extrapolate some of the existing data...

I have a table with contacts in it and a table of task I would like to assign to people. How can I use one form to update the name and email fields of task table with the information from the contacts table? I have the form for the task/investigation but cannot figure out how to pull the contact...

<tbody> G Accounts B Accounts AP Account AR Account Payables Rec Beg Balance 234 2345 Pmts Purchases Trad Other Grand Total Company Invoice 1234 1 100 $200 100 400 2 100 $250 200 3...

HI, suppose you hear this allot but I do not have an in depth knowledge of excel. I have search extensively for an answer to my problem but cant find one. Problem: I have a excel workbook which contains all the different products that I stock in my shops. I want this sheet to populate each...

Hello everyone. I’m creating a simple management tool for a number of teams in the form of a standalone Excel 2013 workbook for each team leader, working on a standalone PC. The tool comprises three tables, each on a separate worksheet. These tables are added to the data model and used as...

Hi, I have a table which a client is populating with information. The first column contains key information to identify the line of data. The summarized output will be in a second table designed to be more clean and printable than the data input table but the first column needs to correspond to...

Better question...I have a price list of 100 items can I make it so this data can be filtered by more than one column for ex. <tbody> Item price item price 1 2 5 5 2 2 6 6 3 3 7 7 4 4 8 8 </tbody> can I link both "item" categories so that they both can filter ALL of the info

Hi Guys, Thanks a lot for accepting me in this forum. Currently work with PowerPivot in Office2010. And i have some Questions i have 4 tables, 1 tables can control 3 table using slicer. see the tables below : Tables 1 Segment Segment_Desc A1 Coffee A2 Tea A3...

Hello, So I have a table with two columns: one with the year and the other with savings. The first year row is one formula: Cost Per Year - LED Cost Per Year. The rows following that are a different formula: Previous Row*Inflation Rate + Previous Row. However, the table wants all the rows to...

That description probably didn't help much. I have a PowerPivot of three tables - a roster, Data1, Data2. I have a connections between the roster and each of the data tables based on an employee alias. In Data1 and Data 2, the data looks like this. <tbody> Name Alias Data1 Month Bill...