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 think you should look into PivotTables. All those lookups will be slow and cumbersome and PivotTable may expand the way you want. They are a little hard to learn/get used to/format to make them look the way you want, but once you get them right they work well.
- 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.
- I hadn't looked into Pivot Tables before, but had thought there must be a more efficient way to run the calculations. Been self teaching as I've been going.
Thank you for the suggestion.
