Donate Now Goal amount for this year: 2500 USD, Received: 1627 USD (65%)

Results 1 to 7 of 7
Like Tree4Likes
  • 2 Post By Dave Jones
  • 2 Post By Chris Needham

Thread: Schedules - Editing multiple cells at once

  1. #1
    Member
    Join Date
    September 21, 2016
    Location
    Boston
    Posts
    184
    Current Local Time
    08:34 PM

    Schedules - Editing multiple cells at once

    I am working on a door schedule, and there are 150+ items. One of the categories has the same value throughout, I want to select multiple cells in the same column and choose the note from the dropdown and have them change all at once rather than having to do each individual cell

    Is there a way to do this like excel?

  2. #2
    Moderator
    "I am NOT a Revit tutor!"
    Dave Jones's Avatar
    Join Date
    December 7, 2010
    Location
    San Luis Obispo, California USA
    Posts
    4,489
    Current Local Time
    05:34 PM
    Quote Originally Posted by katewood1989 View Post
    I am working on a door schedule, and there are 150+ items. One of the categories has the same value throughout, I want to select multiple cells in the same column and choose the note from the dropdown and have them change all at once rather than having to do each individual cell

    Is there a way to do this like excel?
    go to the schedules View List Properties/Sorting & Grouping tab and uncheck Itemize Every Instance then go to the Filter tab and remove any filters. All of your doors are now on one line in the schedule. Make your change to the column you like and back up through the Filter and Sorting changes made to get back to where you were. All line items are now changed
    cganiere and GMcDowellJr like this.

  3. #3
    Member
    Join Date
    December 13, 2010
    Location
    Whangarei, New Zealand
    Posts
    177
    Current Local Time
    12:34 PM
    Quote Originally Posted by Dave Jones View Post
    go to the schedules View List Properties/Sorting & Grouping tab and uncheck Itemize Every Instance then go to the Filter tab and remove any filters. All of your doors are now on one line in the schedule. Make your change to the column you like and back up through the Filter and Sorting changes made to get back to where you were. All line items are now changed
    Or duplicate the schedule first, do the filter and sorting changes on the duplicate, which saves you having to redo stuff.
    Dave Jones and GMcDowellJr like this.

  4. #4
    Member J.Merlan's Avatar
    Join Date
    August 19, 2016
    Posts
    55
    Current Local Time
    05:34 PM
    CTC BIM Project Suite has a great tool called "Spreadsheet Link" which is essentially a database editor with an Excel-like interface. I highly recommend any power-user to learn this tool (or something like it).

    https://apps.autodesk.com/RVT/en/Det...en&os=Win32_64

  5. #5
    Member HansLammerts's Avatar
    Join Date
    April 22, 2011
    Posts
    451
    Current Local Time
    12:34 AM
    2019,
    manual enty one by one
    from top to bottom..
    [entry] [SHIFT+TAB] [ arrowdown]

  6. #6
    Senior Member Alex Page's Avatar
    Join Date
    December 13, 2010
    Location
    Wellington, New Zealand
    Posts
    649
    Current Local Time
    12:34 PM
    Quote Originally Posted by HansLammerts View Post
    2019,
    manual enty one by one
    from top to bottom..
    [entry] [SHIFT+TAB] [ arrowdown]
    hmm - can you explain a bit more - not sure on that method

  7. #7
    Member HansLammerts's Avatar
    Join Date
    April 22, 2011
    Posts
    451
    Current Local Time
    12:34 AM
    Quote Originally Posted by Alex Page View Post
    hmm - can you explain a bit more - not sure on that method
    A eyboard combination for keyboard ninjas. Ninjas hating mice and avoiding ribbon. Saving time. Doing things faster

Similar Threads

  1. Editing and Merging Panel Schedule Cells
    By Lkenshalo in forum MEP - General
    Replies: 5
    Last Post: November 18th, 2015, 05:36 PM
  2. Cells in other schedules
    By assem in forum Architecture and General Revit Questions
    Replies: 1
    Last Post: August 7th, 2014, 09:40 AM
  3. Editing schedules
    By byk3bep in forum Architecture and General Revit Questions
    Replies: 2
    Last Post: April 23rd, 2014, 02:26 PM
  4. Editing Multiple Families
    By Craig Howie in forum Architecture and General Revit Questions
    Replies: 12
    Last Post: October 6th, 2012, 06:18 AM
  5. Replies: 0
    Last Post: November 10th, 2011, 01:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •