View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WBTKbeezy
 
Posts: n/a
Default Multiple Pastes Between workbooks

I have 3 workbooks, each contains the same 30 tabs, but each workbook
contains different information. There is a main workbook, and two extra with
information that I need to put all together on the main workbook. I am
looking for the easiest way to paste the info from the 2 workbooks into the
main work book without having to do it tab by tab and workbook by workbook.
Anyone have any suggestions?