vba autofill

  1. 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 <>...
  2. 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'...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...

Some videos you may like

This Week's Hot Topics