LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default copy 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying formulas with fill handle Bob L[_2_] New Users to Excel 4 March 30th 10 04:49 PM
SET DEFAULT FOR FILL HANDLE TO COPY ONLY Mark Excel Discussion (Misc queries) 1 May 9th 08 01:20 AM
Help - copy a formula using the fill handle Lori Excel Discussion (Misc queries) 5 January 12th 07 03:20 PM
ROUNDUP copy/paste and fill handle not working Jason Southco Excel Worksheet Functions 1 October 10th 05 05:41 PM
3-d reference not adjusting when using Fill Handle to copy down gall Excel Worksheet Functions 3 November 24th 04 06:42 PM


All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"