auto fill macro

  1. J

    Excel VBA adding lines and copy formulas

    I have a template worksheet built with formulas that I regularly copy and modify its size to fit necessary input- meaning I add/delete rows and copy formulas as needed. I have finally decided to develop a macro so it's easier for my coworkers to modify. It's a fairly complex set up that's...
    • jacqu
    • Thread
    • auto fill macro copy & paste data rows table
    • Replies: 3
    • Forum: Excel Questions
  2. F

    Deleting Blank Rows below data using a macro

    I'll try and explain this as best as possible. I am pulling external data into Excel in order to run some pivots off it. This data will start in cell B1. Column A contains a key, made up of the contents of this data. (e.g. =B2&F2&H2). This is then used to match against another tabs. I would...
  3. T

    Autofill for dynamic range

    Hi. My problem seems simple but I'm having a lot of difficulty getting my Macro to work properly. I have a sheet with a Column (A) of Dates and a Row (1) of Column Headers. Count of dates and Column headers change every day. I'm placing a lookup formula in B2 and I'd like it to do two...
  4. N

    Marco Using Find Last and Autofill Function

    I am trying to write a marco to automate a tedious process. The data is set up as follows (just showing the first few sections, it goes on for all states) <TABLE style="WIDTH: 641pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=852><COLGROUP><COL style="WIDTH: 48pt"...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top