I want to create a master workbook with data entered for multiple divisions
and create a summary page that will auto update when the master is updated.
I have tried a simple =, but it will only bring 1 cell at a time. When I
drag from the right corner it just repeats that first cell or if I pull a few
cells and high all and drag it repeats those cells. How can I copy multiple
rows and columns?