filldown

Hi Boys & Girls, Please, help me.. I have this: ColumnA ColumnB SN qtty ac227 3 cz122 2 7787 4 And i need this: ColumnA ColumnB SN qtty ac227 3 ac228 ac229 cz122 2 cz123 7787 4 7788 7789...

The code I have below works great if I am only selecting one cell. I need the sub to work on multiple cells at once. The current code allows me to select multiple cells but only does FillDown on the first selected cell. I have searched for a solution but have yet to find one. All solutions that...

I currently have a macro set up that loops through used rows to add a different formula to column A, B, C, D, and E. So it applies the formula to A3, then another formula to B3, etc. to E3. Then it loops and does the same to A4, B4, etc. to the end of range. Is this the fastest way, or would...

I need to use VBA to either filldown or copy and paste a cell that contains an array. I have to admit, I don't even know what an array is, I'm trying to clean up someone else's report. (Never again!) Anyway, when I try to use VBA to filldown, or to copy and paste, it "works" fine and pastes...

Hello, First time posting, long-time user. I have searched far and wide to find a solution to the issue below. I am a novice in VBA but I am trying my best to get better. I have a Pivot Table that will update based on the selection of the region. To the right of the Pivot Table are manual...

still learning VBA and frequently bumping up to some errors. I currently have the following issue: I have an excel with 2 worksheets (FORM and DATA). sheet DATA contains 2 colums of data: A = lookup value. B = value to be returned. Range (A:B) is named data. sheet FORM column B contains the...

Hello and thank you for viewing. I have an issue with a FillDown command in the following VBA code. The formula being entered into BX2 simply formats 3 columns of data into M/D/Y date format. The code is then designed to fill that formula down until the last row of data in the sheet. For some...

I am new and have searched endlessly for a couple of days to try and figure this out. Thanks in advance for any help and insight... sheets(1) has two columns; Column A is href links and Column B is FileNo Macro looks up href links on sheets(1) and utilizes a webquery to pull table...

Good morning, I have the following code which works but only fills down one row and I want it to fill down to the last row but I cannot work it out. Dim Col As Range For Each Col In Range("L:Q").Columns With Cells(Rows.Count, Col.Column).End(xlUp) .Offset(1).Formula = .Formula...

hi, i have the following Macro which is supposed to insert a formula in H2, I2, & J2 and copy it down to the last row of column H, I, & J which have data in column A. it places the formula in the correct cell, however then instead of copying the formula to the last row of column H, I & J it...

Hi guys, I need a macro that will filldown formula only to visible cells based on the formula in the selected cell. ColA is going to be filtered for chunks of data, and colB needs different formula depending on the results in colA, but the actual formula isn't what I'm stuck on... its the bloody...

In cell A13, I have the formula =U2 In cell A14, I have the formula =U4 I need A15 to =U6 and so on and so forth. I have over 1800 rows and I really don't want to have to enter the formula for each cell. If I highlight A13 and A14 and use the auto fill, I end up with something like this: =U2...

Hello, I have a worksheet that contains cells with VLookup formulas, however I need the actual values of the cells to be used by other formulas in the same worksheet. I decided to use FillDown to drag all formulas (including the Vlookup formulas) one line below and after that copy and special...