Originally Posted by That One Guy
Let us know if you're able to do what Broncobuster said. Hopefully you can but if not, I was once a self-taught master of horribly inefficient VBA back in my day. It got the job done, though. I just don't even wanna break out that part of my brain again if this up here worked.
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?