I have a spreadsheet with specific sets of cells that I would like to be able to just tick a checkbox (or something similar) which ones I need to make a one full set on a main sheet.

Example (width/amount of cells in a row is fixed to 6 at all times):

  • Sheet 1 has 6x7 cells
  • Sheet 2 has 6x3 cells
  • Sheet 3 has 6x12 cells
  • Sheet 4 has 6x9 cells

On main sheet I would like to just select #1, #3, and #4 and it would make a nice set of 6x28 cells. Formatting needs to be kept since different sheets have different colours

  • you want this in desktop MS Excel? (not Google Sheets?) – user0 Apr 25 '19 at 23:35
  • 1
    Exactly, MS Excel – Marek Marhoul Apr 26 '19 at 6:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.