I have an excel worksheet that has 2500+ contacts w/ address. This list gets reviewed by roughly 17 different people in order for them to select the names they want to invite to an event or to receive a holiday card. So my excel sheet has 3 columns A,B,C, where the user needs to mark if they want a contact in 3 different categories. Say they use their initials to mark, when i combine 17 of these worksheets into one, i want the columns A,B,C to have multiple data, i.e, (worksheet 1 initials, worksheet 2 initials, etc.).
My guess is i need to import this data into a sql database or access - i would prefer sql. Once i have an updated database with all this info i can take it from there and put it back into excel.
Any guidance on the sql script is appreciated. Also, if this can actually be done in excel, that would be great but i'm doubtful.
I just had a thought of adding all the sheets into one workbook and making a master sheet that combines all the worksheets#.columnA and so on - however i would need to make sure all these sheets are in the same order. it is possible that some users may add or delete contacts from the initial 2500+ (but i might just lock them out of doing that)