Forum Discussion
Trying to make data input from another sheet
mathetes https://docs.google.com/spreadsheets/d/1VidJJPsgs3bn5in5iuvk0ctv4qN7Fw-_/edit?usp=sharing&ouid=117311209734897984757&rtpof=true&sd=true
So I want the data in the master tab that says true to be pulled and placed in the dashboard tab where the corresponding white boxes are. I only need the login and the three rates. Everything else will be manually input. If there is also a way to not clear out the data in the first image without making a new sheet that would be good too, but I have a feeling I will need to make a new sheet for each week. TIA.
OK, I got access. But I'm sorry to say that there is far too much going on there for me to try to sift through. Also, nothing was showing as TRUE in the Master tab, so there wouldn't be anything to test. It's also a macro-enabled file, and I'm not a person who works with macros and not sure what you're trying to do in the bigger picture.
My sense from having looked at it still is that the FILTER function might well achieve what you want. Did you look at the video I linked to before? Did you try FILTER out? It does need the most current version of Excel, but for something like your workbook, given how extensive it is, I would think your organization would benefit from upgrading if you haven't already.