| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Fill help
I am creating a continuous form to use to print data from another
spreadsheet. What I need to do is copy a formula to paste various cells on a spreadsheet. For example in Sheet1: U2 I have the following formula: =IF('Sheet2'!A2<"",'Sheet2'!A2,""). I need to copy that formula into Sheet1: U15 as =IF('Sheet2'!A3<"",'Sheet2'!A3,"") and into Sheet1: U28 as =IF('Sheet2'!A4<"",'Sheet2'!A4,"") and so on. Is there a simpler way to do that than manually correcting each formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Fill help
Assuming that your cells increment consistantly (U2, U15, U28, U41, U54, U67,
etc...), you could use this: =IF(OFFSET(Sheet2!$A$2,(ROW()-2)/13,0)<"",OFFSET(Sheet2!$A$2,(ROW()-2)/13,0),"") HTH, Elkar "Josh O." wrote: I am creating a continuous form to use to print data from another spreadsheet. What I need to do is copy a formula to paste various cells on a spreadsheet. For example in Sheet1: U2 I have the following formula: =IF('Sheet2'!A2<"",'Sheet2'!A2,""). I need to copy that formula into Sheet1: U15 as =IF('Sheet2'!A3<"",'Sheet2'!A3,"") and into Sheet1: U28 as =IF('Sheet2'!A4<"",'Sheet2'!A4,"") and so on. Is there a simpler way to do that than manually correcting each formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro or Custom button to fill in the same formula | Excel Worksheet Functions | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Trend using the same formula as the fill handle does | Excel Worksheet Functions | |||
| Excel formula fill. Help needed... | Excel Discussion (Misc queries) | |||
Linear Mode
