Originally Posted by bronco0608
Thank you so much for asking, That One Guy. Bronco Buster's suggestion was sweet and got me going on the right track -- I think. I should be able to get the names right from there. I am definitely making progress on that front.
Now I need to figure out how to take three different excel invoices, and make them consistent with the same fields on one worksheet. This is what three invoices on the same spreadsheet looks like after pasting them:
And I want to be to automate it to standardize the fields so it looks like this:
I know some of it has to be manual entry. Any suggestions on how to accomplish this?
Standards are a good thing. Have your boss demand that everyone uses the same formatting of their spread sheets moving forward. It will make life easier for you or the guy who replaces you in the long run.