1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is there a way to convert a formula reference to text for sharing?

Odd question, not sure if this is possible or not.

I’m working between multiple spreadsheets, and pulling info into a summary spreadsheet. This spreadsheet will be sent to a customer who does not have access to the other spreadsheets. I’m curious if there is a way to pull an equation from one spreadsheet to another, without actually pulling the equation. I want to pull the final number, not the formula, as the customers won’t be able to access the info.

I’m certain there’s a way to do this, but I’m not sure how.

TLDR:

Want to pull references to other spreadsheets without actually referencing the spreadsheet for sharing purposes.

submitted by /u/ComfortableNo6851
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article