[Mitch Youngs]

Isaac or anyone else trying to figure out the VBA code feel free to ask questions.

One thing I did want to mention is that this specific code has logic to figure out if it is a Bid Item (100) or sub item (100.01) so it needs to create a new sheet because it has run out of available rows. Also, I tend to use tables in excel so I can reference data by column name instead of hard coding.

I have a simpler form with only adding a few cells of data and not much logic in it if you want me to share that one.