Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulae
Hi
Any help? I have formulae in column A4 A1 A2 A3 A4 In sheet1 and I want to copy it to sheet2 in column A3 Every time I should change the numbers of rows to match the A3 Any idea how I cam manage this since I want to copy this formulae up to 200 times Thanks in Advance Jam |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulae
Is your formula referencing 'absolute' or 'relative' values? In certain
respects it may not matter. If you enter it correctly in sheet 2, cell A3, by grabbing the bottom right hand corner of cell A3 (when the cursor turns into a cross), you should just be able to drag it down (this will copy it), for all of the rows it is required. -- Martin " wrote: Hi Any help? I have formulae in column A4 A1 A2 A3 A4 In sheet1 and I want to copy it to sheet2 in column A3 Every time I should change the numbers of rows to match the A3 Any idea how I cam manage this since I want to copy this formulae up to 200 times Thanks in Advance Jam |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulae
Hi Martin
May be I am not clear The formula is in A4, A8, A12, etc... in sheet1 I want to copy it in A3, a6, A9, etc...in sheet2 If I drag in sheet2 the result in A3 will not match giving 0 when it should give something else Thanks in Advance Jam Martin Panter wrote: Is your formula referencing 'absolute' or 'relative' values? In certain respects it may not matter. If you enter it correctly in sheet 2, cell A3, by grabbing the bottom right hand corner of cell A3 (when the cursor turns into a cross), you should just be able to drag it down (this will copy it), for all of the rows it is required. -- Martin " wrote: Hi Any help? I have formulae in column A4 A1 A2 A3 A4 In sheet1 and I want to copy it to sheet2 in column A3 Every time I should change the numbers of rows to match the A3 Any idea how I cam manage this since I want to copy this formulae up to 200 times Thanks in Advance Jam |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulae
So I take it there is a line of data in the Sheet 1 calculations that is not
required in sheet 2??? Please give me an example of what A4, A8 etc. have ,and what A3 should have. -- Martin " wrote: Hi Martin May be I am not clear The formula is in A4, A8, A12, etc... in sheet1 I want to copy it in A3, a6, A9, etc...in sheet2 If I drag in sheet2 the result in A3 will not match giving 0 when it should give something else Thanks in Advance Jam Martin Panter wrote: Is your formula referencing 'absolute' or 'relative' values? In certain respects it may not matter. If you enter it correctly in sheet 2, cell A3, by grabbing the bottom right hand corner of cell A3 (when the cursor turns into a cross), you should just be able to drag it down (this will copy it), for all of the rows it is required. -- Martin " wrote: Hi Any help? I have formulae in column A4 A1 A2 A3 A4 In sheet1 and I want to copy it to sheet2 in column A3 Every time I should change the numbers of rows to match the A3 Any idea how I cam manage this since I want to copy this formulae up to 200 times Thanks in Advance Jam |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulae
On Oct 21, 2:53*pm, Martin Panter
wrote: So I take it there is a line of data in the Sheet 1 calculations that is not required in sheet 2??? Please give me an example of what A4, A8 etc. have ,and what A3 should have. -- Martin " wrote: Hi Martin May be I am not clear The formula is in A4, A8, A12, etc... in sheet1 I want to copy it in A3, a6, A9, etc...in sheet2 If I drag in sheet2 the result in A3 will not match giving 0 when it should give something else Thanks in Advance Jam Martin Panter wrote: Is your formula referencing 'absolute' or 'relative' values? In certain respects it may not matter. If you enter it correctly in sheet 2, cell A3, by grabbing the bottom right hand corner of cell A3 (when the cursor turns into a cross), you should just be able to drag it down (this will copy it), for all of the rows it is required. -- Martin " wrote: Hi Any help? I have formulae in column A4 A1 A2 A3 A4 In sheet1 and I want to copy it to sheet2 in column A3 Every time I should change the numbers of rows to match the A3 Any idea how I cam manage this since I want to copy this formulae up to 200 times Thanks in Advance Jam- Hide quoted text - - Show quoted text - This is in AN11 cells in sheet work1 IF(AND(ISNUMBER(AF11);AG11=TRUE);"No";IF(AND(ISNUM BER(AF11);AG11=FALSE);AM11)) I want to copy the result to the other sheet called names, so I wrote that in AJ10 in sheet names should be the same results Work1!AN11 This should be for AJ13 in Sheet names to be as AN15 in sheet work1 Is there any idea Thanks in advance Jam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying formulae | Excel Discussion (Misc queries) | |||
COPYING FORMULAE | Excel Worksheet Functions | |||
copying formulae along rows. | Excel Discussion (Misc queries) | |||
copying formulae | Excel Worksheet Functions | |||
copying and pasting excel formulae | Excel Worksheet Functions |