autofill vba

Hi Guys I am stuck with a coda and was wondering if somebody could assist me please. I am selecting a call and entering value "77000" in cell E11. I then find next blank row, depending on the column F, then I like to copy value "77000" from E11 and paste value to last row found from column F...

I'm working my way down a worksheet collection information, so my starting point changes every time I run the code. Here is the example that is not working: irow = ActiveCell.Row Range("A" & irow).Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[16],'Cross Data'!C[-4]:C[-2],3,FALSE)" Dim...

Hi, Anyone knows how i can run a vba loop to autofill column A(Product) based on column b(Date)? Thanks a lot I've tried numerous methods but they dont seem to work. for instance, selection.autofill destination:=range(selection,selection.end(xldown)) <TBODY> Product Date Price Product...

Hello, I have been working on trying to identify the solution to this for the past day with little success. Any assistance or guidance would be greatly appreciated. I am copying data from one sheet (sheet A) and pasting into another sheet (sheet B). I can find the cell I need to paste the...

Hello everyone. I'm trying to automate Excel's autofill feature for attached Spreadsheet (As-is) so I can use a Pivot table to summarize my data. See link for TO-BE Spreadsheet. I don't even know where to start, so any help would be much appreciated. At the moment, I'm double-clicking the...

My macro code is doing a slow hang when I try to extend the formulas in I2 and J2 down through however many rows there are. It only does this when row 2 is the last row, i.e., when there is only 1 row of data below the header labels. By "slow hang" I mean the progress bar pops up, you can tell...