Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Down
I want to copy the formula below down the sheet so that the week
increases. i.e. week 12 week 13 etc. (The week represents a different named sheet) =IF(Week12!L$3=0,"",Week12!L$3) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Down
Hi,
Try this =if(indirect(A2&"!L$3")=0,"",indirect(A2&"!L$3")) Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Yrrep" wrote in message ... I want to copy the formula below down the sheet so that the week increases. i.e. week 12 week 13 etc. (The week represents a different named sheet) =IF(Week12!L$3=0,"",Week12!L$3) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Down
in A1:
=IF(INDIRECT("Week"&(ROW()+11)&"!L$3")=0,"",INDIRE CT("Week"&(ROW()+11) &"!L$3")) adjust 11 to suit On 18 Mar, 14:10, "Yrrep" wrote: *I want to copy the formula below down the sheet so that the week increases. i.e. week 12 week 13 etc. (The week represents a different named sheet) =IF(Week12!L$3=0,"",Week12!L$3) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Down
Neither one worked
Will try to make it easier Have 52 sheets "week 1 through week 52" Box L3 has a number averaged on each sheet Another sheet has the formula =Week1!L3 starting in column C4 I want to copy down so the next row below says week2 l3 and so on all the way down TIA "Jarek Kujawa" wrote in message ... in A1: =IF(INDIRECT("Week"&(ROW()+11)&"!L$3")=0,"",INDIRE CT("Week"&(ROW()+11) &"!L$3")) adjust 11 to suit On 18 Mar, 14:10, "Yrrep" wrote: I want to copy the formula below down the sheet so that the week increases. i.e. week 12 week 13 etc. (The week represents a different named sheet) =IF(Week12!L$3=0,"",Week12!L$3) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Down
I like this technique:
Put this formula in C4: ="$$$='Week"&ROW()-3&"'!L3" Drag down as far as you need (51 more rows). Then convert these formulas to values. Then do an edit|Replace what: $$$ with: (leave blank) replace all If you're not sure you created the correct formula, you'll want to test it on just a few cells. If you've made a mistake, you'll be prompted to select the name of the workbook that contains the correct worksheet. And if you've done this 52 times, that means 52 dismissed dialogs or killing excel. Yrrep wrote: Neither one worked Will try to make it easier Have 52 sheets "week 1 through week 52" Box L3 has a number averaged on each sheet Another sheet has the formula =Week1!L3 starting in column C4 I want to copy down so the next row below says week2 l3 and so on all the way down TIA "Jarek Kujawa" wrote in message ... in A1: =IF(INDIRECT("Week"&(ROW()+11)&"!L$3")=0,"",INDIRE CT("Week"&(ROW()+11) &"!L$3")) adjust 11 to suit On 18 Mar, 14:10, "Yrrep" wrote: I want to copy the formula below down the sheet so that the week increases. i.e. week 12 week 13 etc. (The week represents a different named sheet) =IF(Week12!L$3=0,"",Week12!L$3) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel |