View Single Post
  #1  
Old March 30th, 2010, 01:39 PM posted to microsoft.public.excel.newusers
Bob L[_2_]
external usenet poster
 
Posts: 9
Default copying formulas with fill handle

I have two spreadsheets and want to link info from one sheet to another. I
have totals at the bottom of columns and I want to be able to put those
totals into another spreadsheet. I want to do this with the fill handle
instead of entering one by one.

I have totals in lets say B66,C66,D66 and so on. I want to be able to put
those numbers in the next spreadsheet in cells B11,B12,B13 and so on. B11
should equal B66 , B12 should equal C66 and so on.

Any help would be appreciated.