+ Reply to Thread
Results 1 to 2 of 2

Google Sheets: how do you make multiple pages/versions without more sheets

  1. #1
    Registered User
    Join Date
    07-13-2021
    Location
    Sweden
    MS-Off Ver
    Google Sheets
    Posts
    1

    Question Google Sheets: how do you make multiple pages/versions without more sheets

    Quick explaination of what the idea is, this is a sheet to preview a song pack for a game called stepmania 5, the point of it is to show the contents of the pack and act basically like a wiki/showcase for what's avalible and what's being worked on.
    Here's the link to the live version: docs.google.com/spreadsheets/d/1getE7sTeXsnvHdOqXd7ifNyx4CYHaC6WFa2kOTxUr3Q/edit?usp=sharing

    Below is an example of how it looks like and how it should look like if you click something to make it go to the other page, since the way you change modes in the game hides other maps and that would make the maps likely go unnoticed
    This is more of a cosmetic upgrade from using a new sheet like currently but the problem is I'll need more than just this sheet later for other packs and it would look really weird and pretty bad to have to have separate packs scattered about.

    The things that needs to change is:
    The text under "Out" on "C",
    The text in "Type" on "F",
    All the difficulties from "Expert-Novice" and "edit" on "H-M",
    And the version text and download link also need to change independatly, all to specific things.
    If there's a feature that lets you have multiple versions of one page that you can flip through with a click that would likely be what I'm looking for.
    Also yes I'm aware I'm using sheets unlike it's inteded to be used but it works mostly and is convenient since it's easy to edit and can do a lot of things with conditional formating and other such things.
    Attached Images Attached Images
    Last edited by AliGW; 07-14-2021 at 01:52 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: how do you make multiple pages/versions without more sheets

    option 1: have different pages: right click the tab (at the bottom) of the sheet you want a new version of, click Duplicate, rename it to the new version number, then edit it to your liking.

    option 2: put the data in panels, below each other, similar to your image: just create new panels and add a hyperlink to them in a menu.

    option 3: (the closest to what you want) setup the data in either separate pages or separate panels, then create a new sheet and have Data Validation where the user makes a selection from a dropdown, then all other cells will use their appropriate values based on the selection made
    Last edited by janmorris; 07-25-2021 at 08:06 AM.

+ 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. Pasting formula to multiple sheets and then hard coding the #s
    By MatchaLatte in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2021, 07:36 AM
  2. Replies: 1
    Last Post: 12-13-2018, 09:34 AM
  3. [SOLVED] How to make PDF file with multiple pages?
    By StuCram in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-19-2017, 07:23 AM
  4. Replies: 4
    Last Post: 07-18-2014, 02:05 AM
  5. IF question for multiple pages
    By clair_g in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-24-2008, 03:28 PM
  6. Question on sheets with multiple pages
    By maxmil in forum Excel General
    Replies: 2
    Last Post: 02-22-2007, 10:07 AM
  7. Money 2005's home pages' URL should le me access to my hard disk.
    By Jacques DELIVRY in forum Excel General
    Replies: 0
    Last Post: 09-07-2005, 03:05 PM

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