Update multiple worksheets

L

Lizz45ie

:confused: What is the simplest method to update several worksheets a
once. My report involves several steps where I create multiple pivo
tables and from there I update 2 different workbooks from the pivo
tables I've created. I use one set of data to create charts and fro
the other data I create a report in Excel that has 2 worksheets that
update manually. I currently link the worksheets but I'm concerne
that I might accidentally select the wrong cell. I'm sure there is
simplier way but I don't where to start
 
Top