autofill excel macro

  1. E

    VBA Transform Data into Excel Table(No Repetitive Header and Future Expandable)

    Dear All, I'm New to VBA excel and would like to write a Code whereby: 1) Convert raw data(another Workbook)(repetitive "supplier" and "type", f) to Non-repetitive table. 2) Result Table with autosum(New Workbook) as below: 3) The Result table will be expanded with Raw Data future key in...
  2. S

    Macro to extract data from another sheet based on specific criteria, then clear data after update. Repeat.

    Hello, I am not very good at VBA coding and need help putting together a macro that will allow me to do the following: 1. Extract milestones from another worksheet (titled "Workplan") based on a column titled Upcoming Milestones (column R) that is a drop-down selection (Yes or No). If yes...
  3. S

    Make sequential labels, 3 per page, for 50 pages faster/ easier

    Hello, I'm looking for some help. I want to print 50 sheets where each sheet has 3 labels that look like this (The right side is a copy): <tbody> Title Title LABEL# (M1, M2, M3...M150) LABEL# (M1, M2, M3...M150) Date Date Shift (Day / Night) Shift (Day / Night) Number Number...
  4. P

    vba to autofill the formula

    Hi, I am working on a project where I require a formula to be autofilled till the last row. I am facing one issue regarding the autofill. I have two columns (example Column A and B) where data exists and I am writing a formula on Column C (C2). In column A and B data are variable meaning if...
  5. E

    VBA Macro to fill in blank date cells with same preceding date?

    Hello all, I received an excel report that uses an unfortunate layout. Here's a sample: <tbody> 1/27/2014 Item 1 $10 Item 2 $20 Item 3 $50 Item 4 $40 1/27/2014 Total: $190 1/28/2014 Item 1 $50 Item 2 $40 Item 3 $70 Item 4 $100 1/28/2014 Total...
  6. S

    Excel VBA Help. Assigning Alternating Names to Alternating Rows in Range

    Hello, Very new to VBA writing but am catching on fast. Below is the link to a macro enabled spreadsheet that I have been working on. So far all that I have written works but now I am down to the last part where I essentially would like to take the names from a list and assign them to the rows...
  7. V

    Autofill Current/Active Column

    I have a workbook that will have over 20+ tabs and I am wanting to build a macro to do an autofill to last active cell in the current column I have selected. What is the correct code? I have this currently but it doesn't work (obviously :)) The only thing consistent will be that the formulas...
  8. T

    Macro fill cell based on value from another sheet - columns change

    Hi all, I could use a bit of help here. I have a file with a master list of data, titled "Values." In this sheet, I have specific identifying columns - Building #, Floor # and Unit. (Columns B, C and D, respectively). This sheet contains information for all units on all floors in 5 different...
  9. T

    autofill column based on a different column

    Hi, I have a macro I (with a ton of help) wrote a while ago to auto fill a column based on a value in another column. Here it is: ElseIf Not Intersect(Target, Columns("C")) Is Nothing Then Dim tmp As Range Set tmp = Sheets("Client No...
  10. Z

    Using the Autofill feature skipping calculated cells.

    Suppose I have data values from A1 to A6 and it consists of 2 sets of data, one of which is from A1 to A3 and the other is from A4 to A6. I want to simply the average of each set by inserting one formula and using the drag down feature. B1 = AVERAGE(A1:A3), however when I drag this formula...
  11. Y

    EZ: Autofill with a variable

    This should be an easy one for someone... I've managed to cobble together some code that does nearly everything I need, except for one lousy thing... I need to add a new field in (S1) lets say FileNm and I need to populate that field from the first record to the last in my file. I have looked...
  12. D

    Insert data from one worksheet into another

    I have two worksheets Star and Atlas. These two worksheets get updated daily so the number of rows change, but all the columns stay the same. There is information in Star that starts in column P2 and ends at a different place depending on the day the data is imported. What I need is to insert...
  13. B

    Help with VBA for Autofill

    I’m creating an Open Order Report from a Pivot table to supply to various branches for fulfillment. I have 5 different regions which I label Cust Name and place in the Row Label in the Pivot Table along with the Ord Unit which gets counted in the value field the Column Label is Due Date. The...
  14. J

    Column AutoFill Macro

    Hi anyone and everyone, I am first time poster and serious novice when it comes to VBA. I am using Excel 2007. I am building a weekly cashflow model that details the cash flows for up to 30 different magazines in a publishing company. For each mag, I have built a model that uses assumptions...
  15. M

    Autofill Macro

    Hi... I just wanted to create a macro to generate numbers sequentially(autofill) in a column. Ex:ID 1 2 3 . . This is to automatically generating numbers for a particular ID field.Pls guide me...
  16. B

    Problem with formula autofill code

    Hi, I'm currently using the following code for autofilling a formula via a macro: Dim rng As Range Set rng = ActiveSheet.Range("B9") rng.AutoFill Range(rng, rng.Offset(0, -1).End(xlDown).Offset(0, 1)) Basically, I run a standard weekly report and use a macro to automatically insert...
  17. M

    Autofill macro for multiple columns and rows

    In reading multiple threads, I am attempting to utilize the code but I am struggling as I am new to learning this. This is probably an Excel Macro 001 level question but would appreciate the assistance. Here is a sample of a pivot table copied into a worksheet with paste/spc/values. I require to...

Some videos you may like

This Week's Hot Topics

Top