Jim Smith Posted September 11, 2017 Share Posted September 11, 2017 I think I know the answer is "sort of". Can data be shared between worksheets in the same file? The only way I can see doing this is to copy the formula from one to the other Worksheet. I would like to be able to take the SUM from one Worksheet & use it in another worksheet. Is there some way to reference the data from the cell of one worksheet into another? Quote Link to comment
Jonathan Pickup Posted September 11, 2017 Share Posted September 11, 2017 One worksheet can get the result from another. The code you need to use is: =('worksheetname':cell) so it might look like: =('Bracing Demand':B32) 2 Quote Link to comment
Jim Smith Posted September 23, 2017 Author Share Posted September 23, 2017 Thanks Jonathan, BTW, missed you at the VW Design Summit Quote Link to comment
Pat Stanford Posted September 29, 2017 Share Posted September 29, 2017 One small addition to Jonathan's answer. This only applies to worksheet cells, not database cells. There is no direct way to access the contents of a single database cell into a different cell, either in the same sheet of in a different sheet. 1 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.