autofill

Hello everyone! This is my very first post on mrexcel.com but I've been a site regular for many months now. You guys rock! I always find a thread of someone having the same doubt as myself, but I now have a somewhat specific query: I have a data sheet that is updated monthly where monthly...

I have a few inputs in A1:B3: months 20 Price per month 30 cost 180 then in: A5 =sequence(1,b1,1,1) A6 =sequence(1,b1,B2,0) A7 =If(A5#=1,b3,0) This gives me a useful and dynamic table. However, I would add a rolling P&L from A8 for the length of the number of months? Below is the result that...

Dear all i want to fill series with specific intervals for example auto fill with 2 interval auto fill with 3 interval 85 85 85 85 86 85 86 86 87 86 87 86 88 87 88 87 89 87 89 88 88 88

Sheet1, cell B2 is currently blank. I want it to auto fill with whatever is selected on Sheet2 in column A. So cell B2 is something like = active cell sheet 2 kind of formula? I'm assuming this will need to be a macro/VBA code to make it work? Also, if this matters, I have all of Sheet2 from...

Hi all, Worksheet_Change(ByVal Target As Range) The worksheet change event tells us which Range (Target) was edited but doesn't tell us how. As we know, the user can change a cell either, by editing it with the keyboard, by pasting a value into it ,by drag and drop or by using the autofill...

This is the code I am using: Sub Extract ' Extract the Contract Account Numbers and delete Column A FinalRow = Range("A" & Rows.Count).End(xlUp).Row Columns("B:B").Select Selection.Insert Shift:=xlToRight Range("A1").Select Selection.Copy Range("B1").Select...

I'm looking to use excel autofill to complete my formulas in a specific way. My formula is: =IF(Sheet1!E2<$A$2,$A$2,IF(Sheet1!E2>$A$3,A$3,Sheet1!E2)) I drag down to autofill all instances of E2 --> E3 and so on, as I'd like. I also want to drag right to make incremental formulae where all...

Hello, I have a VBA macro that will insert a new column (titled updated col..) to the right of the specified column name. Then I use a VLOOKUP and autofill in the new column to provide the updated values. The column location of the updated column is variable/dynamic. How can I make the autofill...

Hi all, I am trying to find two columns by their name in a sheet, viz. Column "Fruits" and column "Vegetables" and then trying to paste these columns's merged value in a new column. My code Sub Merge_B&C() Dim WrkBk1 As Workbook Dim WrkBk2 As Workbook Set WrkBk2 = ActiveWorkbook Set WrkBk1 =...

Hi guys! Long time reader, first time poster. Getting very frustrated with my VBA so any help is appreciated. In my worksheet "Paste Data", I have a string of text in column G and need to use the LEFT formula to find and copy the text before the character " - " into column H. My VBA code...

Dear All, Hello, I've just learnt how to use VBA and still new on it. I made a formula below, where it works perfectly for my sheet. Range("$AE$2").FormulaR1C1 = "=IF(RC[-25]=""V6"",LEFT(RC[-11],LEN(RC[-11])-1),RC[-11])" Range("AE2").AutoFill Destination:=Range("AE2:AE" & Range("F" &...

Hi there, My Name is Prathik. I'd like to apologize if this question has already been answered. I didn't find anything about this anywhere on the internet. So posting it here. Please assist. So I'm writing this code wherein my macro writes a formula in E2 (Range A To D already has data). Then...

I have the below vba to autofill the formula between J17 to ACP17 based on if there is data in column E. Range("J17:ACP17").AutoFill destination:=Range("J17:ACP" & Range("E" & Rows.Count).End(xlUp).Row) Works fine, but J17 to ACP17 hold formulas that relates to a row of sequential dates...

HI Excel Expert , Request your valuable help in solving the below error . PS: Am new to Excel VBA coding . I have got 3 Sheets in the attached workbook “Just combo V2” Download link : Just combo V2.xlsm Sheet 1 Sheet 2 =”School” in which Cell A1 : A14 Contains list of schools Sheet 3...

Hi all I am trying to do a few things here with VBA: Here's the source Worksheet named MoCMatrix ABCDEFGHIJKLMNOPQRSTUVW1HELPER ROW > Structural Integrity-MoCStructural Integrity-Substantiation DocumentStructural Integrity-StatementFlammability & Smoke-MoCFlammability & Smoke-Substantiation...

Hello, I want to fill cell e1 with value "GOLD" when I fill cell a1 with value "GL" Similarly if I fill a2 with value "SL" I want the cell e2 to be filled with value "SILVER" I WANT TO FILL A COLUMN CELLS WITH SOME PREDIFENED VALUES AND I WANT CELLS IN E CLOUMN TO GET FILLED WITH ASSOCIATED...

I'm trying to create some automation in a macro--see attached picture. The automation includes adding a formula in cell G2 =CONCATENATE($F2,"@gmail.com")--then autofill this formula down column G to the last cell or final row in column F. I don't know how to reference the adjacent column when...

The Column has entries as shown below. AA BB CC I want to auto fill entries like all cells in the column between AA and BB get auto filled by AA, all cells in the column between BB and CC get auto filled by BB and so on. This should continue till the end of last row...

Hello, I would like to find out how to autofill a column in another workbook. Here is my code so far: Sub Task1 () Set wb4 = Workbooks("Task1") Set ws4 = wb4.Sheets("Sheet1") 'code lines for copy and paste from Workbook "A" to Workbook "Task1" LstRow = ws4.Range("A" &...

Hello all, The form that I am working with requires me to pull the information from a different sheet. The information is stored with a gap of 38 rows, so standard autofill doesn't work. Is it possible to achieve this? thank you, Oksana