I have a spreadsheet that contains a roster of names and next to each name is a vlookup. Whenever I update the roster I run a macro that copies the updated roster to several of my employee's own workbooks. Worked fine except now that I've added the vlookup the formula points them all back to my workbook. Only method I know would be do a find/replace that exact text out. It will work but I just tried it on one workbook and it took 5 seconds. I need to do this to ten workbooks.
I've uploaded what my workbook. My team looks the same as well.
Please Login or Register to view this content.
Bookmarks