VBA to keep format when concatenating

[isasa74]

1 to 4: I can fix all that easily... Before you upload the request to the Mass upload tool.

Thanks!

WE can take those tasks away from the MUT and give them to Excel and VBA, But first let's get the request fixed as much as possible.

for the last three points, don't bother about because even when the Upload Template ( a MUT sheet where you put DATA in) would be perfect, there is always something getting lost/wrong when transmitted from the MUT to SAP, and to fix that I don't have either clue or authorization.

For example:

When too many conditions have been uploaded for the same part number funny IFR may be created like NL10 with import duties or wrong vendors.

that " many conditions" I'm talking about are those already in the system so , at that point, it is not only about the MUT but more about how the MUT and SAP are communicating.



I'm already super happy if we can have the first 4 points fixed by the First Step of the tool and then the second step comparing the request (sheet2) to the result of the upload that I get as an extract from the system (Sheet1).
that way I will have:

Step one:

Making the two sheets perfectly comparable (no blank, all same format, etc.).
Plus, if we fix the 4 points of the Business rules, spotting out those errors already coming with the request.(so not imputable to the upload)

Step two:

Actually Comparing the two sheets , Spotting out what went wrong with the upload itself (if anything goes wrong of course, errors are indeed very rare but too dangerous)

I wish to introduce a new Programming Term to you: "Business Rules."

thanks SamT I'm learning a lot from you, thank you very much.

Let me know what else you may need for your magic please.