DDD Posted December 10, 2020 Share Posted December 10, 2020 (edited) Hi I got a question, please see attached snapshot, The column F is linked to existing tree info field X Column E is automatically calculating the correct field X value Is there a way to make column F automatically replicate column E, so all the tree info field X can be updated quickly instead of me typing them manually. Thank you! Edited December 10, 2020 by DDD Quote Link to comment
Pat Stanford Posted December 11, 2020 Share Posted December 11, 2020 If I am understanding you, then no there is not a way to do what you want. My understanding of your question is that what you want to do is have column F be a Record.Field plus also pull data from somewhere else and store it into that record.field. If that is correct, then there is not a simple way to do that. You could COPY the data from Column E and PASTE into Column F, but no way to simply do it by formula. It might be possible to do with some of the new Worksheet Script functions in VW2021, but I have not played with them yet to see. 1 Quote Link to comment
Peter Vandewalle Posted December 11, 2020 Share Posted December 11, 2020 Worksheet scripting should allow that. I think Julian had some scripts that work both ways. Quote Link to comment
DDD Posted December 11, 2020 Author Share Posted December 11, 2020 @Pat Stanford Thank you Pat! Quote Link to comment
DDD Posted December 11, 2020 Author Share Posted December 11, 2020 @Peter Vandewalle Thank you Peter, I'll check that out. 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.