We receive a spreadsheet from a vendor twice a month in the same format. It
includes 6 tabs in sheet. I need to pick out specific data from each
sheet....amount, account, etc. and put it in a separate sheet formated to
upload to our ERP system. Would a macro be the most effecient way to
accomplish this? Any suggestions? thanks.