| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula issue
I have a formula that I'm using to pull data from a cell on multiple sheets...The formula is =SUM(Week1!$L$52) This formula I want to use across the same row, changing the week number in each cell, but not the cell reference...In other words...the cell next to it would be =SUM(Week2!$L$52), next one would be week 3, and so on. Is there a shortcut to doing this so that It will update across the row all the way to 14?? I have 60 rows of formulas, and it would be easier to just enter each one ONE time, and copy and paste somehow across the sheet but keep the formula reference correct. -- AlienBeans ------------------------------------------------------------------------ AlienBeans's Profile: http://www.excelforum.com/member.php...o&userid=32352 View this thread: http://www.excelforum.com/showthread...hreadid=546580 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Formula Issue | Excel Discussion (Misc queries) | |||
| Formula issue | Excel Discussion (Misc queries) | |||
| imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
| formula SUMIF or whichever one will work for my issue | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Threaded Mode
