VBA, pasting formulas into a specific column, filling down until data rows are empty

    Howdy, this is probably really easy for you guys, but I'm having a devil of a time with it.


    Have an ever-changing dataset that I get snippets of from a database and then add a bunch of search formulas to check whether the data in column "AM" meets a number of criteria.


    Currently, I store the formulas I need in my personal workbook with the formulas inactivated. I then paste the ten formulas I need into the new workbook starting in column "BK", add the "=" sign and fill down.


    This is a repeatable task and I hate doing it 4 times a week. The main thing that changes time-to-time is the number of rows that I need to fill down for. And obviously the row references that the search formulas point to in column "AM".


    Can someone help me get started on what to do step by step to figure out how to automate this task using VBA?


    Unfortunately, I can't post the data in a public forum, nor can I send it privately.


    Also, I'll gladly donate $50 to the Dave Hawley Foundation in honor of the person who helps the most.

    Re: VBA, pasting formulas into a specific column, filling down until data rows are em


    A generous offer.


    We don't need actual data, just a workbook with representative dummy data will do - you are more likely to get help if you can do this.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login