1. I

    Copy and Paste Filtered data from another file & autofill month in pasted data

    Sub Manpower() Dim lastRow As Long Dim Wrkb1 As Workbook Dim Wrkb2 As Workbook lastRow = Worksheets("Manpower Details").Range("C" & Rows.Count).End(xlUp).Row Set Wrkb1 = Workbooks.Open("D:\DU\MIS.xlsm") Sheets("Manpower").Select If ActiveSheet.AutoFilterMode Then...
  2. B

    Excel Online Data Validation Autofill Not Working

    Hey All, I have created data validation fields in several worksheets. When using them in Excel Online, I used to be able to start typing and have an auto filtered list popup based on what I had input to that point. Suddenly, this autofill feature is no longer there. Is anyone else having this...
  3. W

    Autofill not working properly

    Hello, I am working on a large data set but recently started receiving smaller quantity of data. I used to use autofill a lot with filtered data but it seems if I have only 1 row of filtered data and use autofill it gives me the old image(I am changing the value inside the cell). Is there a way...
  4. W

    VBA to find missing data in column and complete the series of info

    Hello, All. I need help. I have an excel sheet with data that pertains to product being shipped out for delivery. Most items are being shipped in multiples. I need help creating a VBA that will find these multiples and complete the series of missing numbers. as seen in the attached photo...
  5. M

    Selecting specific columns to according to last row value by VBA

    Dear All: I'm working on a project and I need your help I need Vba code to Auto filter and count items based on multiple columns based on uploaded dynamic dara from another sheet For example I have So the result should be And so on for all the range I tried Auto filter then select case code...
  6. B

    Autofill Numbers In Merged Cells

    I know there are some topics about autofill in merged cells, but I couldn't find what I need. I don't even know if it's possible. Is there a way to autofill numbers in this kind of table? (see image bellow). There are cells merged in rows and columns. Numbers with 2 or 3 digits, depending on...
  7. 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
  8. 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...
  9. 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...
  10. 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?
  11. 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...
  12. 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...
  13. 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...
  14. 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!
  15. 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...
  16. 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...
  17. 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>...
  18. 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...
  19. 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...

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