Interesting idea, have to be careful not to get caught in a catch 22 scenario, when I try to automate this. But you have given me an idea, maybe if...
Thank you, I have made the header column one row and moved the year sheets into one sheet with a column that designates the year of the project. Wh...
Mynda, Thank you, I'm still learning all of this, I believe I understand what you have suggested to do. I will let you know how I do. Doug
I know, but the information in the workbook is confidential to the company, I will change the the data to get by this, let me work on it, thank you fo...
I made the change and get a Run-time error '1004': Application-defined or object-defined error Attached is the code and error message. ...
Well, good question, on present additions x 2 to the file, that will take about 50 years, I hopefully wouldn't have to worry about it by then. That...
Thank you Sunny and Velouria. Here are my formulas: Cell B2 =LEFT([@[RT Line Code]],1)&[@[Auto Incremtal ]]&[@[Trait_ID]] Cell E2 =IF...