data in worksheet 1 comes directly from data in worksheet 2. if data in worksheet 2 changes often, how…
data in worksheet 1 comes directly from data in worksheet 2. if data in worksheet 2 changes often, how should data in worksheet 1 be entered? linked cells copy/paste
Answer
Brief Explanations:
When data in Worksheet 2 changes often and data in Worksheet 1 is derived from it, linked - cells are used. Copy - paste creates static data and won't update when the source data changes. Linked cells ensure that any changes in Worksheet 2 are reflected in Worksheet 1.
Answer:
Linked Cells