Suwarin

Version 1.0.3

Japanese README

GitHub

Table of Contents

1. Introduction
2. Features
3. Installation
4. Usage
5. Notes
6. License

Introduction

Excel macro to make a seating chart. This is not for changing the seating arrangement, or changing the seating order, but for making a seating chart with a specified order of participants. It will be helpful when you are making several sheets of onetime seating charts.

Features

• Making a seating chart only by copy and paste participants and clicking twice.
• Using this macro from the context menu.
• Specifying seats not to be used.
• Designing the chart as you like to some extent.

Copy and paste participants to the column next to the seating chart, then click button in the context menu. Then the participants will be input to the chart.

You can specify the seats to skip. Enter lowercase "x" to the upper left cell of the seats to skip.

The range of the seating chart range and each seat are specified by the ruled line instead of cell address. So if you draw lines according to the rules, you can design the chart as you like to some extent.

Installation

1. Download main.bas
2. Import the module, or copy & paste the second line and below.
3. To Thisworkbook module, add the code below:

   Private Sub Workbook_Open()
       Call AddToContextMenu
   End Sub
   

4. Save the file as .xlsm (any name is OK)
5. Reopen the file

Usage

1. Draw the ruled lines to make a seating chart
2. Enter participants into the cells two cells away from the top right cell of the seating chart
3. Right click on a cell (anywhere) and click a buttom in the menu

Notes

• The range of the seating chart range and each seat are specified by the ruled line instead of cell address. Make sure that the lines are within the rules below:
  • Draw a ruled line on the outer frame of the seating chart without interruption.
  • Do not draw extra ruled lines beyond the range of the seating chart.
  • Separate each seat with a ruled line without interruption.
  • Do not draw a ruled line inside each seat.
  • Make the number of rows and columns of each seat the same.
• The range to enter the participants into is designated. The top of the range is two cells away from the top right cell of the seating chart. If the chart range is B3:M16, the top right cell is L3, so enter the participants into O3, O4, O5 ....
  
• Each participant will be entered into the top left cell of each seat. Nothing will be done to the other cells. You can enter functions.
• Make sure that only one seating chart exists on a worksheet.

License

Copyright 2022 taidalog

Suwarin is licensed under the MIT License.