All I want to do is have cells in one sheet (tab) in a workbook auto-populate with data and formatting of a different sheet (tab) in the same workbook. I know how to do this one cell at a time, BUT is there a way to do this so that I can select a range of cells all at once? Example:
Tab A, Range A3:D36
would automatically populate with data fromTab D, Range A2:D35
.