# How to duplicate the profile sheet? **URL:** \ **Category:** Ask for Help\ **Created:** [March 13, 2021, 10:16pm UTC](https://community.glideapps.com/t/how-to-duplicate-the-profile-sheet/24218 "2021-03-13T22:16:07Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Arsenii\_Sokolovskii](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arsenii_sokolovskii/32/9144_2.png) [@Arsenii\_Sokolovskii](https://community.glideapps.com/u/Arsenii_Sokolovskii)\ **Post date:** [March 13, 2021, 10:16pm UTC](https://community.glideapps.com/t/how-to-duplicate-the-profile-sheet/24218/1 "2021-03-13T22:16:07Z")
How to double the profile sheet? If i have a profile tab + i need to make a new tab with (Add admin), so for that i need somehow to double the profile sheet + make it always synchronized with the original profile sheet, how can i make my goals real? P.S. The original profile sheet has a “User-specific” collumn ---
**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\ **Post date:** [March 13, 2021, 10:26pm UTC](https://community.glideapps.com/t/how-to-duplicate-the-profile-sheet/24218/2 "2021-03-13T22:26:09Z")
> [@Arsenii\_Sokolovskii](#): > > profile sheet? Is your profile sheet on Google sheet or Glide tables ? ---
**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\ **Post date:** [March 13, 2021, 10:32pm UTC](https://community.glideapps.com/t/how-to-duplicate-the-profile-sheet/24218/3 "2021-03-13T22:32:20Z")
If it’s coming from google sheets, you may want to read this article : > **[IMPORTRANGE - Google Docs Editors Help](https://support.google.com/docs/answer/3093340?hl=en)** > > Imports a range of cells from a specified spreadsheet. Sample Usage IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10") IMPORTRANGE(A2,"B2") Syntax IM > [@Arsenii\_Sokolovskii](#): > > double the profile sheet + make it always synchronized with the original profile sheet, how This will be an issue for you, the update is not automatic, the sheet has to be opened to get all the latest datas. More on that in the link above. Let us know ! ---
**Author:** ![Arsenii\_Sokolovskii](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arsenii_sokolovskii/32/9144_2.png) [@Arsenii\_Sokolovskii](https://community.glideapps.com/u/Arsenii_Sokolovskii)\ **Post date:** [March 13, 2021, 10:37pm UTC](https://community.glideapps.com/t/how-to-duplicate-the-profile-sheet/24218/4 "2021-03-13T22:37:04Z")
Glide tables P.S. Understood. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 21, 2021, 10:18am UTC](https://community.glideapps.com/t/how-to-duplicate-the-profile-sheet/24218/5 "2021-03-21T10:18:33Z")
So you want a read only copy of your User Profiles sheet, which is a Glide Table, yes? Here is what I would do: - Firstly, ensure you have a Row ID column in your User Profiles table (that’s obviously the case if you already have User Specific columns) - Create your second table, and add a Row ID column - Add a second (text) column, and call it User ID. - Use that second column to create a single relation back to your User Profiles table, matching on User Profiles → Row ID - Now you can add Lookup columns through that relation, one for each column that you want a copy of. To initially populate the User ID column, you’d either have to copy/paste manually, or if there are many existing rows you could adapt [this](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/18) technique. Dealing with new users could be a bit tricky, and it depends what your app privacy settings are and how new users are added. But it would probably need to be a two step process. The first step would be adding a new user to the User Profiles table, and the second step would be adding a row to the second table, using the Row ID of the newly created user (you could probably identify this using a Single Value or Rollup column) ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/how-to-duplicate-the-profile-sheet/24218/6 "2024-01-17T16:52:50Z")