Use the Workbook in Google Sheets — Auctions at Booth Ready

STEP 1 Upload the workbook to your Google Drive

Go to drive.google.com
Click + New → File upload
Select multi-item-workbook.xlsx (the file you downloaded with your purchase)
Once uploaded, right-click the file → Open with → Google Sheets

Google will convert it. Your Setup, Items, and Print Sheets tabs all carry over with formulas intact.

STEP 2 Save it as a native Google Sheet

With the workbook open in Sheets, click File → Save as Google Sheets
This creates a new file you can edit freely. Delete the .xlsx copy if you want.

STEP 3 Add the auto-hide button (the magic part)

In the Sheets menu, click Extensions → Apps Script
A new tab opens with a code editor. Delete anything that's already there.
Click the Copy code button below, then paste it into the editor:

// Auctions at Booth Ready — Auto-hide empty bid sheets
// One-time setup by Mike Vendetti. Edit if you know what you're doing.

function onOpen() {
  const ui = SpreadsheetApp.getUi();
  ui.createMenu('Auction Tools')
    .addItem('Refresh print sheets', 'refreshPrintSheets')
    .addItem('Show all 30 bid sheets', 'showAll')
    .addToUi();
  refreshPrintSheets();
}

function refreshPrintSheets() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const items = ss.getSheetByName('Items');
  const print = ss.getSheetByName('Print Sheets');
  if (!items || !print) return;

  // Count filled item rows (rows 6-35, column C = description)
  const data = items.getRange('C6:C35').getValues();
  let count = 0;
  data.forEach(r => { if (r[0] && String(r[0]).trim()) count++; });

  // Each item takes 30 rows on Print Sheets
  const visibleRows = Math.max(count, 1) * 30;
  print.showRows(1, 900);
  if (visibleRows < 900) {
    print.hideRows(visibleRows + 1, 900 - visibleRows);
  }
}

function showAll() {
  const print = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Print Sheets');
  print.showRows(1, 900);
}

function onEdit(e) {
  if (!e || !e.range) return;
  const sheet = e.range.getSheet();
  if (sheet.getName() === 'Items') refreshPrintSheets();
}

Press Ctrl+S (or ⌘S on Mac) to save. Name the project anything.
Close the Apps Script tab.
Go back to your Sheets tab and reload the page.
You'll see a yellow bar asking for permission — click Authorize → choose your Google account → click Allow.

STEP 4 Use it

From now on, any time you add or remove an item on the Items tab, the Print Sheets tab automatically hides empty bid sheets. Print Preview shows exactly the pages you need.

You'll also see a new menu: Auction Tools → Refresh print sheets (manual trigger) and Show all 30 bid sheets (if you ever need them all back).

Trouble?

Email mike@anumber1.com. I'll get you sorted within a few hours, usually faster.

If you'd rather skip all this and have me set up a branded version with your name and colors, that's the Branded Pro tier — and I credit your $29 toward it.

View Branded Pro →