View Single Post
 
Old 03-14-2016, 12:26 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Couple of ways...

If it's just a one time thing, go to the sheet you want to copy from. Select column 1. Select the first tab to which you want to copy. While holding the shift key, select the last tab to which you want to copy. You will notice that these two and all intervening tabs are now highlighted. Select A1 in this sheet. This actually selects A1 in all the highlighted sheets. Press CNTL-v. Select any unhighlighted tab to unselect those tabs.

If you expect the data to be constantly changing and you want it to update automatically, you could just have formulas referring to the cells in the first sheet.
Reply With Quote