Hello
I receive numerous excel spreadsheets from vendors. Each provides
distribution by state, but not all vendors distribute in each of the 50
states. I enter the spreadsheets data into one spreadsheet to obtain total
distribution by state for an annual report.

I would like to import the data by state with a macro or formula that tells
Excel if state = empty then skip or enter zero.

I want to eliminate entering this data by hand.

Thank you