View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat Hughes Pat Hughes is offline
external usenet poster
 
Posts: 8
Default Edit 2 workbooks at same time

I want to edit 2 workbooks at the same time. They have same info except one
includes phone numbers and one doesn't. THey are lists of officers in
different divisions which change each month. I want to make the changes to
both workbooks at the same time so I don't have to do it twice. I feel this
should be easy. For example when you edit 2 worksheets you can press shift
and click on the tab of the worksheet you want to edit. I want to edit 2
workbooks at the same time moving the names of the officers around.
Any ideas?
Thanks