I hope I can explain this well enough. I have Sales Orders from customers that come in Excel format. Every SO is in the exact same format. The only difference is the SO # and the line items on the SO (qty, part and price). So there are two parts to this. The first is the SOImport spreadsheet. The 2nd part are the individual SO's, SO-1, SO-2, SO-3, etc. We are then taking the individual SO's (SO-1, SO-2, etc) and manually putting them in the spreadsheet, "SOImport". We then take the SOImport spreadsheet and import it into our software.
I am trying to figure out a way we can put these individual SO's in a folder, run a script and have the SO#, part #, qty and price from all the SO's populate on the SOImport spreadsheet. I also need a way the SO Numbers can automatically be created when pushed to to the SOImport spreadsheet.
I have attached the SOImport spreadsheet template and also an example of 2 sales orders, SO-1 and SO-2. The individual SO's aren't named SO-1, SO-2, etc. I just did that so it hopefully makes sense.
Is there a way to put all these individual SO's (SO-1, SO-2, etc) in the SOImport spreadsheet template like you will see on my example?