Copying formatting while referencing cell

Occasional Visitor

Good Day, 


This may have a simple solution, which would actually be great! Without getting caught up in too much detail- I am managing a fleet of vehicles of over 180 pieces and am documenting relevant information (Driver's assigned, vehicle unit #, Equipment Type #, etc.). 


My first sheet contains the most extensive table displaying my information. I have created a second sheet to show a condensed version of sheet 1. 


Sheet 2 needs to reference the corresponding cells in Sheet 1- including formatting. So they will not overlap perfectly as sheet 2 has several columns removed from the sheet 1 template.  As tedious as it sounds, in sheet 2 I went cell by cell referencing the specific cell from sheet 1 one by one. 


How can I emulate sheet 1 onto sheet 2 so that when I change sheet 1, sheet 2 will follow in kind? 


Thank you so much!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies