| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I fill a formula on another sheet that repeat every 50 cell
I am trying to set up a report to help me out. My problem is that i have to
input 300-500 sheets of information in so i am using formulas to help me capture that date that i need and i am sending it to another sheet. On the Other sheet I have formulas set up to capture everything and the formula is suppose to repeat every 50 cells. EX. Sheet1!h1 then the next cell below it is Sheet1!h51 then the nest cell is Sheet1!h101. so is there a way that i can "repeat" these going down so that i don't have to go in and manually change the cell number. If any one could help it would be apprecitated. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I fill a formula on another sheet that repeat every 50 cell
see answer in your other post
"Chad Hable" wrote: I am trying to set up a report to help me out. My problem is that i have to input 300-500 sheets of information in so i am using formulas to help me capture that date that i need and i am sending it to another sheet. On the Other sheet I have formulas set up to capture everything and the formula is suppose to repeat every 50 cells. EX. Sheet1!h1 then the next cell below it is Sheet1!h51 then the nest cell is Sheet1!h101. so is there a way that i can "repeat" these going down so that i don't have to go in and manually change the cell number. If any one could help it would be apprecitated. Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I fill a formula on another sheet that repeat every 50 cell
In Other Sheet A1 enter =Sheet1!A1
In Other Sheet A2 enter =OFFSET(Sheet1!$A$1,50*ROW()-50,0) Drag/copy A2 down as far as you wish. Gord Dibben MS Excel MVP On Mon, 31 Dec 2007 09:31:02 -0800, Chad Hable wrote: I am trying to set up a report to help me out. My problem is that i have to input 300-500 sheets of information in so i am using formulas to help me capture that date that i need and i am sending it to another sheet. On the Other sheet I have formulas set up to capture everything and the formula is suppose to repeat every 50 cells. EX. Sheet1!h1 then the next cell below it is Sheet1!h51 then the nest cell is Sheet1!h101. so is there a way that i can "repeat" these going down so that i don't have to go in and manually change the cell number. If any one could help it would be apprecitated. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat formula on second sheet? | Excel Discussion (Misc queries) | |||
| looking for a way to repeat a formula pattern within a cell | Excel Worksheet Functions | |||
| Repeat Cell Formula w/out copy/paste? | Excel Discussion (Misc queries) | |||
| Repeat Section and Auto Fill | Excel Worksheet Functions | |||
| Conditionally Fill a sheet row if cell value in another sheet 0 | Excel Worksheet Functions | |||
Linear Mode
