Logo

Pro Tips for Renumbering Sheets

Ideate BIMLink can be utilized to batch rename and renumber sheets in your Revit project.


The Revit interface has limitations in terms of editing large amount of data. Ideate BIMLink allows you to edit model data by exporting it to Excel and pushing it back into Revit. The basic steps for this process are covered in our Help topic: How to Batch Rename or Renumber Sheets.


If you need to tackle some more complex challenges, in this blog post I’ll highlight the power of Excel functions and formulas when utilizing Ideate BIMLink for sheet renumbering.


Here is an example: 

Pro Tips for Renumbering Sheets
  1. Utilize the adjacent column to enter the following formula, then drag down to autofill the values.

    =LEFT(A1,1)&"."&TEXT((RIGHT(A1,3)+10),"000")

    List of Excel functions utilized in this function:
Pro Tips for Renumbering Sheets

2. Copy the resulting information from column B and use the Paste Special>Values function to move the data back into Sheet Number column, save Excel, and import it back into Revit via Ideate BIMLink.

Pro tips for renumbering sheets

This is the result:

Renumbering Sheets

Explore recent posts

Automation Workflows for Server Based Projects in Revit
February 5, 2025
Are you managing server-based projects or government contracts that can't rely on cloud solutions? Watch this webinar recording, as Olivia Morgan gives an insightful webinar on Automation Workflows and discover how to keep your projects efficient, compliant, and stress-free. Key Topics: - Model Metric Tracking for contract verification - Automated Model Checks for compliance - Workflow Automation for backups, exports & printing Start saving time with Ideate Automation today.
Enhancing Revit Model Performance Through Model Maintenance
January 17, 2025
TRAINING - VIDEO | Struggling with sluggish Revit models? Watch Olivia Morgan as she shares expert tips on model maintenance using Revit and Ideate Software tools. Learn how to boost model performance with industry best practices, maintain optimal element thresholds with clear guidelines, streamline workflows using Ideate Software add-ins, and keep your models healthy with a detailed BIM maintenance checklist.
Maximize Your Revit Productivity with Strucsoft and Ideate Software
January 10, 2025
VIDEO - TRAINING | https://youtu.be/SAbwNTrLnYw Explore how Ideate Software’s powerful Revit plugins streamline data management, improve model health, and enhance documentation workflows. In this webinar, we also highlight how Strucsoft tools complement Ideate solutions to boost efficiency for framing and construction projects.
Managing Revit Parameters with Ideate Software
December 19, 2024
TRAINING - VIDEO | With Ideate Software, creating and managing parameters in Revit becomes a streamlined and efficient process. Our Revit add-ins allow users to easily define, organize, and control project parameters. Extract parameter data across Revit linked models allowing you to create new parameters which ensures consistency.
Show More
Share by: