Hello everyone,

I'm looking for an Excel Expert to help me with an important question concerning VBA creation. I work for a Manufacturing company in the West Texas area and I've recently started using Solidworks Inspection for the task of exporting Inspection Drawing Data into an Excel Spreadsheet. Okay, I'm of course able to do that relatively easily, but my question then becomes how do I modify Excel to limit the number of row entries per worksheet automatically? Specifically, how do you limit a custom report template list in MS Excel to around 30 row entries? With any extra entries after row 30, that would automatically be transferred to a new WorkSheet i.e. "Worksheet #2". Also maintaining consistent format in terms of row and column size etc.. across both Worksheets is also vital. I've attached a example file of what I've been working on below. My Worksheets in the following project file are named HM&M In-House Inspection Sheet1 & HM&M In-House Inspection Sheet2, respectively. In my file, I've created a patch work of VBA code but need help working out all the issues. Any assistance would be greatly appreciated. Thanks

Sincerely,

Christian