autofil

  1. T

    Why am I unable to autofil this formula? =SUM('[AAL Contractor Statistics.xlsx]Summary Sheet'!$E$28:$E$87)/60

    Apologies for including the formula in the title. I was unable to paste I in here. Any advice as to why I'm unable to fill the formula? I've tried other formulas and they auto fill, but not this one. Do I perhaps need to do it as a vlookup? If so, any help would be greatly appreciated. T
  2. DPChristman

    Vlookup issue - Retail Environment

    I am currently trying to link data between a large data file and a fill in form that I have created. The source data is coming from an excel file that is over 34 MB and more that 177,000 lines. This data deals with inventory shrinkage. There are 7 columns that I am accessing on the source...
  3. J

    VBA - Fix auto fill issue when only 1 row

    Hello all, I have a bug issue on VBA when an auto fill formula can't be executed because only 1 row is available. I mean the next code can't be executed if I don't have at least 2 rows. 2 macros are impacted and here they are: <code style="margin: 0px; padding: 0px; border: 0px; font-style...
  4. J

    Vba code - auto fill previous last column to the new last column

    I am trying to create a macro which adds a new column to a table. I have recorded the macro to add a column but i need the contents of the previous last column to autofill into the new last column - this is where i have difficulty. Has anyone got any ideas which can help?
  5. M

    autofill macro

    Hi, For some reason the autofill is not completing all rows of the data ranges. I am using a work book and the range of rows can change once the report is generated and the rows can vary per sheet. I am using the code: lngLastRow= ActiveSheet.UsedRange.Rows.Count Selection.AutoFill...
  6. C

    VBA to Autofill instead of =formula

    Hello, I have a timetable where I have a reset button that wipes it all. In this wipe I need it to retain the formula that was once in it. The formula is =IF(definedTime=B2,"Do this", " ") this is then dragged horizontally B2, C2, D2 etc going horizontal that is the time, like 9:00 , 9:30...
  7. L

    Fill down formula to end

    Hi I know this question has been asked in many guises, but the answers don't seem to help and are all specific to the question. Basically, I am copying data from varying spread sheets into one worksheet. Each time I paste the data into the spread sheet I want to label each data set depending...
  8. A

    In each column autofill certain number of functions to reduce calculation

    Hello, to illustrate the question: In columns AA, BB, CC, etc. there are to be inserted only a given number of functions, which are specified in the small table on the right. This in order to reduce the overall amount of calculation as the actual table is rather large. Thank you!
  9. E

    Autofill with VBA

    Hello guys This is my excel file its at least 1000 rows. The textcontent in Column T example in this case "12" or "10" tells how many instances there is of same number in column A. I need now to autofil the the 12 and 10 so I get this result see picture: Could someone help me with a...
  10. H

    Data Segregation based on name criteria slide by slide in the selected sheet

    Hi Team, I'm looking for the below requirement can anyone help on this... <colgroup><col><col><col span="2"></colgroup><tbody> Name Date Sales1 Sales2 Daniel 01/18/11 4,907.00 2,038.00 Daniel 12/23/11 3,527.00 2,985.00 Daniel 05/14/12 1,495.00 1,529.00 Daniel...
  11. S

    Autofill cell based on other cell data

    <o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"></o:smarttagtype><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"></o:smarttagtype><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom>...
  12. L

    autofil contiguous cells

    Dear Smart people: i'm using excel 2007, and i've seen Bill select a rectangular group of cells with his mouse, then type a word in the upper-most top left cell (which is white), then all the other cells automatically populate with that same word. i can't get this and searching 'autofil' in...
  13. T

    autofill a column with large larger intervals than the selected range

    I have a 30 cell descenting list in Tab 1 (my input tab) ex: john terry michael ann fred etc..... However, on another tab I'm trying to create a series in column 1, but with 84 rows in between each entry. etc. A1: john a2: entry a3; entry a4: entry a5:a84:entry A85: terry...

Some videos you may like

This Week's Hot Topics

Top