Alright guys here is my newest problem. I have uploaded my excel

Import_Submittal_Template.xlsx

to make it easier this time.

What I want to do is to fill in cell C3 and V3 on Import Submittals with B and C on Sheet1 seperated by a comma respectively. The catch is that I only want this to happen if there is a value in column B and it needs to copy and paste not update or hold the cell value as the Sheet1 will be deleted before importing into the program.

For example with the uploaded excel, C3 would have: COMMON WORK RESULTS FOR FIRE SUPPRESION, IDENTIFICATION FOR FIRE-SUPPRESSING ON PIPE AND EQUIPMENT, WET-PIPE SPRINKLER SYSTEMS, ETC... and V3 would have: 210500, 210553, 211313, ETC.... This could either be a macro or formula.

My biggest catch at the moment is seeing if column B is empty then moving the value. What I previously had was that once it found the first value it would copy everything. (Got frustrated and didn't save it, I know stupid idea).


Thanks,

dsmith7610