Ok I have one wookbook that looks up over like 50 different other workbooks.
But when it finds the data it is looking for it doesnt update unless I do
DataEdit Linkssheet1 update values. Im looking for a way to auto update
for people who are not computer or excel smart.