Hello!
I have a spreadsheet that is sent to me from one of my colleagues. I take this spreadsheet and format it a certain way to utilize further. The spreadsheet that I am sent has 39 differnt columns in it. Each column has its own respective field name that is SUPPOSED to be the same each time the file is sent to me. I would like to have some VBA code that goes through each cell in the first row to ensure the fields are correct. If the fields are correct, then have a msgbox pop up after the code has ran saying all fields are correct. If there is a cell that contains the incorrect field name, then the Msgbox should say STOP, FIELD NAME INCORRECT.
A1 = "Team"
B1 = "Single"
C1 = "Other"
D1 = "Month"
E1 = "Year"
F1 = "Day"
etc.....
Bookmarks