If anyone has a couple minutes to help, I would be very appreciative.I currently receive data that is sales orders. I am importing this data into myERP program. I just need something simple to most of you I am guessing. I amnew to VBA I have a excel sheet that I need to turn into a csv file. Ifirst need to fill a column only as far as how much data is in the row next toit. If that makes sense.
So I need to have column C filled with “Company A”. I willalso use the same to fill other columns. I will be able to figure out how tochange what column and what data it fills it with. I just wondering if someonecould help me with the main code.
In the attached sheet you will see the sales orders. I needcolumn C to have “company A” in all the cells until the end. In this case thatwould be line 36. They will all be different lengths.