copy formulas with fill handle
in [Functions]
|
Prev: to lookup data for 'today()'
Next: Rows to table
From: T. Valko on 31 Mar 2010 22:00 You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "bob" <rlabonte(a)myfairpoint.net> wrote in message news:OoYbvhS0KHA.3676(a)TK2MSFTNGP05.phx.gbl... > Thanks Biff, this worked great > "T. Valko" <biffinpitt(a)comcast.net> wrote in message > news:eOXDndC0KHA.6140(a)TK2MSFTNGP05.phx.gbl... >> Another one... >> >> Entered in Sheet1 B11 and copied down as needed... >> >> =INDEX(Sheet2!B$66:J$66,ROWS(B$11:B11)) >> >> Adjust for the correct end of range J$66. >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "Bob L" <rlabonte(a)myfairpoint.net> wrote in message >> news:BB9E88A6-B3B6-465B-870D-3F31E4687640(a)microsoft.com... >>>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. >> >> > > |