vba autofill

Hi I have data in columns A - C and the number 1 in cell D1. Does anyone know how I can drag the numbers from cell D1 to the rest of the column D (up to the last row of the data in column A) in consecutive order? So my data would initially look like this: A D G 1...

Can someone please explain why my code doesn't work? I want the VBA module to automatically fill certain cells (F,S,..,CS) and their corresponding formulas depending on whether cell in the column left of them is blank or not. Sub test() For Each sh In ActiveWorkbook.Sheets If sh.Name <>...

Im new to VBA so i would very much appreciate any help. I want to autofill a formula until a value change on an adjacent column. example: <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono'...

I feel like this should be simple, but I don't know the language needed. In Excel 2010, I need VBA code to run according to the number of rows. Rows will always be grouped together at the top of the sheet, so there will be no blank rows in the middle of the data. Something like this: create R...

I am attaching the files for your reference. MASTER FILE http://www.box.net/shared/dat9pgal4o PAF FILE http://www.box.net/shared/itz4dbg48h PSI FILE http://www.box.net/shared/cdj0szqhj3 My datas are in the path "C:\Temp" I have three files named 0001.PAF, 0002.PSI & Master File.xls...

Hi, Need some help with either an XltoLeft or XltoRight Autofill I have a userform where the user selects their shift start time and then their shift end time both from inbuilt combobox to ensure uniformity. For example: Shift Start Time 9 Shift End Time 17 On pressing submit, in this...

I need to create a button that will ask the user whaere a file is allow them to select it and update the currently open sheet. I have got as far as working out it will be like a match and index, but I do not want to use formulas, if possible as it restricts the name of the datafeed file. The...

Hi, I have 20 sheets in a work bookwith up to 12 that will be hidden depending on the number of sheets that a particular site will use (i.e. small sites may only need to use 4 sheets, whilst larger ones may need all 12). I already have VBA that give me a TRUE/FALSE result if a sheet is hidden...

Hello - I am currently trying to run a macro and I need a formula autofilled to the end of my data set and the data set will be a different length each time. I'm trying to enter a formula in cell P2 and I want it to copy down all the way until the data ends. Here's what I've tried: Dim...