Hi guys,
This may seem like a strange idea but I will tell you what I need to do. Basically we have a "master" spreadsheet that people type in all day. During the day we have another team which send us a seperate "upload" spreadsheet inputs some of the cells for us, and I need to vlookup these values and ensure that all this information is input in.
Now a vlookup would be quite easy to do but I wont be able to use that as the cells would be full of Vlookups - and I would end up with a load of #N/A errors. The workbook is also shared and any macro would have to work with other users in the sheet.
Does anyone have an idea of what I could do? It should be quite simple but its not in my mind....
Regards
Mike