vba autofill

  1. M

    How to auto-fill a column with consecutive numbers using VBA

    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...
  2. H

    Autofill down according to adjacent column

    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 <>...
  3. D

    VBA autofill until a value change on an adjacent column

    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'...
  4. J

    VBA - How to run code if only a certain number of rows are present

    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...
  5. F

    Luking for a VBA code to import datas of two csv files into excel sheet1 and sheet2 based on some conditions

    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...
  6. B

    Autofill XltoLeft

    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...
  7. M

    vba to import datafeed

    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...
  8. N

    Dynamic list with spaces removed

    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...
  9. Z

    VBA Formula Autofill

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top