How to display data from one worksheet onto another when it updates?
How to display data from one worksheet onto another when it updates?
But when saving the file for the target spreadsheet, those formulas are converted, right?
Right now I use Excel 2010 on my laptop for testing, but it’s slow and sometimes I switch to my desktop, which lacks Office. OpenOffice doesn’t function well on W11, so I’m either using Libre or Google Sheets.
Also, I think I need the file to include only items matching what I’m working on, so I imagine that would require an if statement?
Unknown, without thorough testing.
Choose one and proceed.
Google Sheets is likely the top choice. You and others can reach it via a web browser. It’s not "Office" or "Libre."
Without clear understanding of your goal, creating a full design is unfeasible.
to be more precise in assisting as requested, we require additional clarity on each step. what details are included on every sheet? why is some information transferred to another sheet? exactly what is the function of each one? how do I use them? what outcomes am I aiming for? why and in what context.
i’m not just looking for a basic guide like “how do i ____”; i’m trying to understand the complexity behind my tasks. even simple tools like access can help organize multiple pages of information, create tailored forms to extract needed data, and keep everything neatly structured. this is exactly what access is designed for—easy to grasp, yet powerful enough for more involved projects.
it’s not as advanced as sql, but it’s sufficient for a single person handling complex work. if this matters to you and you’re willing to invest time, it’s worth considering.
i spent several weeks learning access and building a database for a non-profit organization to manage thousands of records. i created custom input/output forms and reports, allowing anyone to enter data or retrieve contact lists quickly.
I know exactly what you're going through. Even though I use Access, I still prefer Excel and enjoy learning. I remember learning Access long ago and have since forgotten, so I’ll need to revisit it. Do you have any suggestions for a solid, free course that covers creating custom forms and setting up relational databases?
I’m also reviewing fans and, later on, other topics. Right now I’m searching for a good anemometer and manometer that fits my budget. It’s tricky because cheap options often lack accuracy, while top models start around $1,000 or more.
At the moment I have a spreadsheet for inventory (over 100 items), another for detailed specs, and a third for fan test results. I’d like to be able to copy the make and model from inventory into specs and tests without moving them, so they auto-populate as my inventory grows. Inv’s fields include make, model, description, price, quantity, and type.
MS Access, both the latest and older editions, comes with a pre-designed template for managing inventory.
I made a Google Sheet similar to a master spreadsheet, and used software (Unito) to connect Excel with Google Sheets. There have been no issues keeping Inventory current. You can adjust the flow as required (one-way or two-way) and apply rules to exclude unwanted rows. I also synced the main sheet with Google Calendar, which generates an event when stock replenishment is needed.
I'm still figuring things out. I'm focusing on using a single app or package since I work with data analysis and graph creation as well.