Thread: Copy formula

Hello, I want to copy the formula stood in my Sheet1 A3, A4 to A. .. The number of cells to be copied depends on the number recorded in D1 of Sheet2 and Sheet3 the K1, I explain:IF (D1 <K1) then copy the formula from A4 according to the number listed in K1
IF (D1> K1) then copy the formula from A4 according to the number listed in J1 IF (J1 = K1) then copy the formula from A4 according to the number listed in K1. Thank you in advance for your help .

Hello,It does not seem very difficult Many son deal with this particular issue it . See especially my reply of 20.05.2011 (This is the easiest way to copy the formula) yapuka record a macro that does what you want with the condition "<=" and then you adjust this macro with the settings that you gain in J1 and K1 .To finalize I recall that I do not work for you: there are enough specialized forums for that. Ii I suggested that ways to help you improve or correct a fault code (provided you have a workbook template attached).

Hello Thank you for your answer but in the meantime I managed to find something that suits me so. Range (A3). AutoFill Destination: = Range (A3: A & [Z3] + 2) , A3, I copy my formula to Z3 and the number of rows that need to copy the formula (A3 and Z3 are on the same sheet) , I just have one quick question, I would like to know how to tell him I want to take the value of Z3 but on Sheet2. Thank you for your help.

You can do it like this: i = Worksheets ("Sheet2"). Range ("Z3") 2
Range ("A3"). AutoFill Destination: = Range ("A3: A" & i) A +