autofil

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

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

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

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

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

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

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

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

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

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?

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

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

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

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!

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

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

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

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

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