Or just use the DiRootsOne plugin, free and nicely advanced and allows importing excel files as well.
Yeh we tried the DiRoots plug in, can’t remember why but it didn’t work for us at all.
Example Building Model.rvt (6.7 MB)
Here’s a stripped project with the revisions left on the sheets…
Example BLANK.xlsx (95.9 KB)
Example DONE.xlsx (98.2 KB)
Excel Transmittal Sheet .dyn (20.2 KB)
Here’s the dynamo script, a transmittal template and an example after the paste is done.
and thank you for looking at this.