I'm doing this on Google Sheets as the final product would have to be collaborative so the .xlsx file might not work unless uploaded back into sheets.
I'm currently trying to find a way to better organize and access our client data instead of having one tab for each of them which can get very messy. My first thought was to have a user input at the top with all client names that creates a filtered view with all relevant data. The problem with this is that I can't find a way to add data at the end of the 'Clients' tab and have it be added permanently to the 'Data' tab. The idea is to have the Clients tab be the only one visible and a manager can come in, add data, and it gets automatically and permanently added to the relevant section in the consolidated data tab. They can then filter to another client, new data disappears, then comes back when the original client is re-selected.
Does anyone know of a good way of doing this or is this not something that is viable/ advisable on Sheets?
Any and all help would be appreciated!
Bookmarks