How can I copy parts of one sheet to another

mrclean

Good morning! I am hoping someone can please assist me. I have two sheet. Sheet A is a Master Staffing Roster PM's maintain. They use this everyday. There are times when information from the Master Sheet needs to be inputted into Sheet B. Rather than the PM's typing it out I would like to automate it so only specific cells are copied from Sheet A to Sheet B. I have tried using Data Shuttle but it doesnt seem to work despite me watching videos, etc. Any help or guidance would be appreciated.

Zachary Ziegler

This seems more like a use case for standard cell references. You can access the feature by clicking on the cell you want to reference, then clicking this button and selecting the cell within the master sheet you would like to reference. Then you can repeat this for any other cells that need to be live-updated on an automated basis, since the Sheet B cell will read directly from the master sheet whenever it is updated.