How to display data from one worksheet onto another when it updates?
How to display data from one worksheet onto another when it updates?
I have a spreadsheet (Inv) that records my purchases, detailing each item and its type.
On another sheet (Fan Data), I aim to display specific details like Brand and Model for items categorized as "Fan". Non-relevant data from Inv will be excluded. The Fan Data section holds technical specifications for fans, while Inv remains a simple inventory with brand, model, description, price, quantity, and type.
Since the content of Inv changes over time, I require the Fan Data tab to update automatically so I don’t have to manually adjust or paste information.
What formula should I use to set this up?
Eventually, another sheet will merge data from several files (Inv, Fan Data, Fan Test, etc.) for creating comparison graphs.
What is the ideal approach?
Thanks in advance!
Oh, this will involve using different spreadsheets based on the platform—Excel, Open/Libre Office, online tools for sharing with patrons only, etc.
If all the sheets are contained within one spreadsheet file, methods exist to reference other sheets. Refer to the provided link for details.
It seems you're considering a database instead of several spreadsheets. You might want to explore open source SQL options such as MySQL for the backend and free web templates for this purpose. Alternatively, you could develop a solution using a cloud provider like Azure, Microsoft, or Amazon. Personally, I'm more comfortable within the Microsoft ecosystem, which would probably lead to a Power App or Power BI application.
You need to understand that all the information is contained within a single file, though it is organized across multiple tabs.
Instead of creating a standard database and web application customized for their needs, it could be more effective to look for inventory management solutions that handle all the tedious tasks for others. This is especially true if using spreadsheets becomes too burdensome. Unless the project has a dedicated IT department, it's better to opt for software that fulfills the requirements rather than building it from scratch.
I'm a one-man operation on a shoe-string budget. Any suggestions?