autofill

Dear all, I have the following table and what I want to do is: When I start typing the offer number (or when I finish typing it), the macro automatically copy all the information recovered from the correspondent line previously input in the table. For example: If it type 45658552,it...

The code below has the range defined and says pull down a2:a as far as column A on the sheet called data goes. Range("a2:a" & Sheets("Data").Range("A" & Rows.Count).End(xlUp).Row).filldown I have selected a column by the header contents not the position and then offset the selection by 1 so I...

Hi, Need to autofill the characters ONLY with a number value staying the same. example. E48A E48B E48C etc. through "Z" without the letters I and O thank you and God bless, Craig

Hello, I am trying to find a way to build on the basic IF function. IF(logical_test, [value_if_true], [value_if_false]) I want to have a few options rather than just one, such as: if A1 = 1, B2 would autofill with Good if A1 = 2, B2 would autofill with Maybe if A1 = 3, B2 would autofill with Bad...

In example below I need to add quotes around the last cell reference and to same formula across columns. I didn't add quotes because autofill doesn't work with quotes. Thank you in advance =SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!"&"$B$35:$B$1000"),$A2,INDIRECT("'"&SheetList&"'!"&M$35:M$1000)))

Hello, I have built a sales report dashboard which is to be updated monthly with around 2000 rows of input. The data I input has the following categories/columns: Date | Sales rep | Product | Quantity | Value | Product category | Brand. Sadly, the company's software does not export the...

Hi newbie to VBA here, I am trying to create a macro that takes a formula created in Cell G3 drags it to M3, and then auto fills to the bottom of the last row. The way I was working on it was previously recording and making some adjustments, I cannot find a way to have it auto fill to the last...

Currently creating a Database in Excel for Jobs, Purchases etc. For Jobs side, I want to be able to type in the Client ID (e.g. AAABBB01) then for it to automatically fill in: Surname First Name Business Name Address Town Postcode Home # Mobile # Work # Email I want to put all of the...

Hello I have the code: Selection.AutoFill Destination:=Range("C2:C159800") Range("C2:C159800").Select But I want it to fill the column dynamically, corresponding to the next column's rows. E.g., if the file has 100 rows, it should autofill up to 100, etc. How can I do that? Also, do...

Please could someone tell me why the Autofill destination does not work with single rows? i am using Range(“h2”).Autofill Destination:=Range(“H2:H” & last row) It works perfectly for multiple rows, but gives me an Autofill method of range class error if there’s only one row of data.

Greetings I'm a vba beginner and trying to make a macro for my monthly Excel tasks. Every month i get a report. I add a colum but can't do that with vba cause the report has a merged cell in the first row over half of our sheet. So i solved that with adding cells. Got 3 sheets open while...

I have horizontal table that I want to link to another page which is in vertical order. And to auto fill vertical to horizontal. Example: ='Adam'!O5 -next cell on page would be 'Adam' !O6 Need to autofill across the Main Page: Main Page ADE -Column headers are horizontal Group1, Group2...

Hi I have a column like the one below. I highlighted the cells and then dragged the autofill down. I got all cells value as = "red". Why is that? is it because they are color words. Thank you so much. <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> red black...

Hi, I am working on a spreadsheet to increase efficiency at work but I have ran into a problem...I have filter column F and then inserted a new column I and input a concatenate formula. I then have tried extending this down to all the other filtered cells and then remove the filter. This seems...

Hello, I'm trying to autofill some cells but I do not want to autofill from the top of the column I need to only fill from the first empty cell in column C down to the last used cell in column A. I've tried several different iterations the following is currently what I've attempted but it is...

Hello... I'm hoping this post will be understandable.... I have a problem regarding pasting rows from one workbook to another, where I want the pasted row to be become a part of a table with autofilled formulas in the end of the table. However, I have stumpled upon a problem, which I cannot...

Hallo good people I am doing a project and the line below autofill a range for me (it works just fine) with weekdays. ActiveCell.AutoFill Destination:=Range(ActiveCell.Address & ":" & "B" & Days + 4), Type:=xlFillWeekdays However, I have a table somewhere called Holidays (with dates) and I...

In my worksheet I have continuous rows with data in D7:D726. I column E I have data from E7:E24. I need to copy the data in range E7:E24 and autofill the remaining rows in col E (i.e. E25:E726) with that range of values. The ranges in both col D and the initial range to be copied in col E...

I created a simple sum formula, in which the rows remain the same, but the columns move one place to the right. (so first the formula is SUM(E37+E53+E54+E55+E56), and then it becomes SUM(F37+F53+F54+F55+F56) and this process is repeated a lot of time.) I tried to do this with autofill but I...

Hi, i have a column with formulas but sometimes manual entry is required to these cells. I have a formula which restores the formulas in the column, but i want it to skip any cells with raw data Range("N2").AutoFill Destination:=Range("N2:N2500"), Type:=xlFillDefault Currently if for example...