autofill range auto fill

Hello. Would appreciate any help. I have a workbook that has multiple sheets with similar data in each sheet. For this problem, let’s presume there is a cell (A1) that contains the TITLE for each sheet, and a group of information that needs to be captured (G4:K?)(ranging from 32-65 rows)...

Hi, I want to use AutoFill function. In destination value I start in point E13 but END values is dynamically counted, so I can't use Range-> Range("E13:E" &....). Selection.AutoFill Destination:=ws2.Cells(13, s), Type:=xlFillDefault My autofill destination is like: E13:AA13, or E13:CC13.....

Hi All,<o:p></o:p> <o:p></o:p> I am using this autofill code for my macro.<o:p></o:p> <o:p> </o:p> Sheets("Data").Select<o:p></o:p> 'This counts the # of Rows in the Coulmn A<o:p></o:p> IngoMaxRo = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row<o:p></o:p> <o:p> </o:p><o:p>...

I was wondering how - if possible - I can go about using the autofill method to fill to the end of the column if the column isn't necessarily specified, but referenced. It's harder to explain than it is to see so here's what I'm working with right now. I just started using VBA a couple of...

Can someone guide me in the right direction: I have a master List that has 5 columns the uniqueness of one of the columns is that it is the SS Number, what I like to do is this: If I type the SS No. in a New workbook or a new sheet, is it possible to auto fill the whole row to the left and right...

Hi, I am importing data from an access table into a spreadsheet. It is a different number of records each time. The macro I have will add and name a new column and find the last cell. What I need to do is have the series 1 -11 repeated in the column to the last cell. I have this macro...

I'm working on a VBA that will autofill a formula (cell C3) based on the last row in column B, and last column in row 2. The number of rows and columns is dynamic, however the formula will always be in C3. This part works... but it only fills the first row and column: LastCol =...

Hello, I have some data set up in a table like fashion. (not a table) B7:L17. I am working on a macro to insert a row at the bottom, format as above, and the fill the formulas down. Sub a() Range("B" & Rows.Count).End(xlUp).Offset(1, 0).EntireRow.Select Selection.Insert Shift:=xlDown...