autofill

I'm trying to make an automate script for my worksheet and having problems with the autofill function. I have 2 columns of data A and B...i have a formula (=TEXTJOIN(", ",,A2:B2) at the top of column C (cell C2) that i would like to have fill down to the last row of data from column B. The...

Good afternoon, Is it possible to create and auto-populate comments in Excel? If for example I have two sheets and sheet 2 is pulling values from sheet 1 that meet certain criteria, can I automatically create a comment for any values pulled over and then populate it with values from sheet 1...

Hi - is there a way to get the "AutoFillFormulas" property to be turned off for a specific column(s) in a Data Table? My table is called "Cash_Analysis_Revised" and I want the formulas to stop auto-filling just for that specific column. I tried the macro below, but I get the 438 error shown.

I am using JotForms for data collection of names addresses and a short response. I am able to export those responses to a CSV or XLSX. I need to be able to take the responses exported and import it to a Fillable PDF form that was created. I was thinking the only way to do this easily is using an...

Hello All, I need a script that cycles through all the sheets in a workbook and adds 2 (or more) columns at the end of the table of each sheet (except the first sheet). In this case I have a YES and NO column to be added. The added columns YES and NO need to be autofilled all the way down to...

Hi Guys i have the following formula which I need to autofill down to 3800 rows A1 ON PORTAL SHEET has a code which referes to a tab sheet name A2 refer to the cell from that particular sheet I wish to retrieve the data. the cell the first formula is in is X1, there the formula will autofill...

Morning All, Im looking to autofill a column from the last used row, this will vary day by day so im struggling with what the range should be as this will be variable each time? Sorry if this is a silly question I'm very new to VBA! This is the code i have currently Range("K1").Select...

I have a table that I am inputting data into. I am using the Forms built into Excel. I have three columns, Y, Z, and ZZ that have static numbers. I mean that each column has a specific number that does not change. I would like to have Excel automatically enter the data into the next row if...

Hi, How can I create macro which can autofill numeration in row. It have to end this macro at the end of this table. I was trying to make it in this way: Sub formuly_cena_zakupu_dziala() ' ' formuly_cena_zakupu Makro ' ' Range("J18").AUTOFILL Range("J18:J" & Cells(Rows.Count...

Hi! Unfortunately, my xl2bb still refuses to work (blanked out in the excel toolbar) but I'll save that for another post and just attach images here. I also previously posted the same thread but with very unclear and messy parameters so I'm redoing that here, apologies for that. The Sales...

Hello Everyone, Can I get help with this problem? I would like help with an auto-formula? I’d like to input data in A1 to E1 and auto-fill the relevant data from the data from information on the right. The range is 1 to 43. I’m sorry I don’t know the Excel terminology, but I hope you understand...

Basically, I want autofill to skip reference columns at a static rate. I have the formula "=SUM('FPY Data'!K5:K54)-SUM('FPY Data'!L5:L54)" in column E. When I drag autofill across column F is "=SUM('FPY Data'!L5:L54)-SUM('FPY Data'!M5:M54)" but I want it to be "=SUM('FPY Data'!R5:R54)-SUM('FPY...

I have the below VBA which: 1. Makes a copy of an existing sheet 2. Inserts extra columns 3. Adds column headers 4. Adds a formula to the new columns in row 2 5. Auto-fills the formula down to the last row (based on column A) 6. Repeats the above for a number of other columns. It works...

Hey Guys - Stumped on something and hope someone can help. I just finishing filling out a flat ton of data on a sheet and am trying to populate additional sheets with the same data just displayed a bit differently. Attached is a spreadsheet similar to what I'm working. Note row 2 of the...

Howdy dear Excel specialists, This is my first time on any Excel forums. I've tried to look at other threads before posting this one, yet I don't seem to be able to apply it to my own situation, nor can I understand a thing of that VBA witchcraft. So I have this main table that regroups all...

For instance, when I drag a numbered cell (1, 2, 3, etc), how do I make it so that instead of continuing the numbers (4, 5, 6, etc), I can have it copy the same thing respectively. (123, 123, 123). Thanks.

Looking for some help with autofilling using VBA I have a table and would like to add a drop-down list (using data validation) in column B until the last row using VBA. I tried the VBA code below but unfortunately couldn't get it to work. Any insight or pointers will be super appreciated...

Hi folks, Is there a way to auto-fill laterally across columns like there is down rows perhaps using a macro? I was thinking this might be handy in some instances I've run into, but I'm not sure how to make the ActiveCell part work. Sub FormulaFill() ' Dim rng As Range Dim y As...

I am trying to create a macro that will autofill three columns worth of formulas until the end of that range and then repeat those formulas for each range below it. For context, the file is a compilation of thousands of different series that could have as little as one line, or as many as...

Hello guys, I have a problem regarding a database. For my master thesis, I have to analyze about 1110 companies categorized into their industry and their headquarters countries: The dataset: Now for the analysis part, I created a separate sheet (which I linked to Capital IQ database to...