+ Reply to Thread
Results 1 to 4 of 4

[GOOGLE SHEETS] Is it possible to add data to another sheet from a filtered view?

  1. #1
    Registered User
    Join Date
    11-01-2021
    Location
    Spain
    MS-Off Ver
    16.54
    Posts
    2

    Question [GOOGLE SHEETS] Is it possible to add data to another sheet from a filtered view?

    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!
    Attached Files Attached Files
    Last edited by Seabass12; 11-03-2021 at 08:45 AM.

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: [GOOGLE SHEETS] Is it possible to add data to another sheet from a filtered view?

    the first point to be made is that G-Sheets is a spreadsheet software for performing data analysis, NOT a database software, so that carries some limitations on how data can and should be input, filtered, referenced, etc etc.

    based on that, it seems that you want to alleviate the managers from having to enter in client name in favour of using a dropdown to create the filter and then add entries. overall this is just duplicating everything from one sheet to another, when it can just have a filter applied and data entered accordingly.

  3. #3
    Registered User
    Join Date
    11-01-2021
    Location
    Spain
    MS-Off Ver
    16.54
    Posts
    2

    Re: [GOOGLE SHEETS] Is it possible to add data to another sheet from a filtered view?

    Thank you for your response! I figured this wouldn't actually be practical so I think we will just migrate to a proper online database to store this info

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,343

    Re: [GOOGLE SHEETS] Is it possible to add data to another sheet from a filtered view?

    Please mark as solved if this thread is now defunct.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Google Sheets: Transfer data from one Sheet to another
    By LRadu12 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 10-02-2021, 12:34 PM
  2. Google Sheets: Condition formatting in Google sheet
    By cyee in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 02-18-2021, 05:35 PM
  3. Google Sheets Master Sheet that pulls in data from other sheets with the last edit date
    By Badvgood in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 12-19-2020, 12:04 PM
  4. Replies: 5
    Last Post: 07-08-2019, 02:46 AM
  5. Google Sheets: monthly budget in calendar view
    By militarymedic23 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 04-02-2018, 07:49 PM
  6. Filtered View With Formulas - GOOGLE SHEETS
    By Vilac7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2017, 12:09 AM
  7. Replies: 1
    Last Post: 01-25-2014, 02:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1