Ok, I've looked and looked, and so far no luck, so I'm hoping you can help. You'll also have to forgive my lack of the proper technical descriptions. So here we go:

I send out a weekly report that references a separate spreadsheet. The spreadsheet is basically a supply and demand broken out by weeks for thousands of items.

When I copy and paste from MY spreadsheet to the one I send out to my vendors (with their accompanying info), I get something that looks like this formula: ='[Ryan Purchasing.xls] Bulk Ingredients'!$P$20

Now, in order to drag this formula across several cells (by the lower right corner of the cell- not exactly sure what this is called) I have to remove the $ signs and then it will drag and continue to reference the corresponding cells. Gosh I hope this doesn't sound too confusing.

My question is this: Is it possible for the new spreadsheet to reference the cell VALUE of the other sheet, not the formula? The way it is now would work, but the recipients of the spreadsheet would have to have access to the first spreadsheet which they do not, and cannot for security reasons.

Again, I'm terribly sorry if this was written in an overly confusing manner. Just not sure what you may need to give me assistance.

Thank you for the help!! I hope my question makes sense!!