View Single Post
Old 08-25-2013, 05:43 PM   #16
broncosteven
Kranz Dictum
 
broncosteven's Avatar
 
Where is Amazon!

Join Date: Jun 2005
Location: Tranquility Base
Posts: 35,421

Adopt-a-Bronco:
CJ Anderson!
Default

Quote:
Originally Posted by bronco0608 View Post
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.
broncosteven is offline   Reply With Quote