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

Ideate Cares: Spreading Love to Seniors This Valentine’s Day
February 26, 2025
BLOG - ARTICLE | Outside of work, we all have activities that bring us joy—whether it’s hiking, fishing, traveling, or simply spending quality time with loved ones. Maintaining a healthy work-life balance means making time for what matters most, and for some, that includes giving back to their communities. Earlier this month, our Social Media and Marketing Specialist, Aleksandra “Ola” Golda, donated her time to a cause related to senior citizens: chronic loneliness. While loneliness can affect anyone, it is especially prevalent among the elderly, making efforts like hers even more impactful.
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.
Show More
Share by: