Is there a way that I can extract data from one worksheet to another other than the lookup formulas? In other words if I had data in a sheet that the Lookup formulas is not set up to read, is there another function (or written macro) beside linking that I could use to bring this data into another worksheet?



thanks for your help