Forum Discussion
Transposing data from a column in one table to another on a different sheet
Hi, I am having issues trying to get the formula to copy across the references in the direction I want them to. Please could you assist. I have a table ("stock") that has the names of stock it...
I've been having a quick look at Pivot Tables and I can't see how they would help. I need the end product to have three tables that can actively have data added into them on a daily basis. From what I understand pivot tables are a convenient way to group and view data not update and maintain. Forgive me if I am misunderstanding how they work.
Maybe I was mistaken. It looks to me like the 3 'calculations' tables and the 'stock' table are all lookup values from the projects table. So each of those tables/tab could be separate pivot tables based on the data in the projects table.
The three calculation sheets do pull data from the projects tab and consolidate it to post into the stock sheet. However, both the projects and adjustments sheets also pull data from the stock sheet. The name of the stock, the description, and the price information is all entered directly into that table and should a new stock item be added it would orginate there.
I need to be able to entre data into all three but I want them all to be able to pull information from each other.
- IMHO that is poor structure. You want to consolidate your data entry. It appears to me that all data entry could be consolidated to the Project table + Adjustments table. BTW you can create a data model using the 2 tables and then pull the pivot table from the data model that has the combined information.