
VBA macro to fill down formulas for several columns via a loop
- or -
Post a project like this1032
£20(approx. $27)
- Posted:
- Proposals: 24
- Remote
- #3862716
- Awarded
Quick Graphic Designer + Animator + Video Editor + Photo Editor + Logo Designer + Autocad Designer

Data Consultant (Expert in Excel, VBA/Macros, Google Sheets, Fillable Pdf services, Data Entry)
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator

87847656476906778773070268173213974387349175393988108961237383478098745411838596
Description
Experience Level: Entry
I need a freelancer to write a very small macro that will fill down my formulas column by column and copy and paste the values in each column in a table. The macro must be written as a loop as I will be applying the macro to a very large table with volatile formulas. The macro must not do all the columns at once as this will make the macro run far too slow. The size of the table may vary so the macro must be able to adjust itself according to the size of the table. The starting point of the macro will always be in the same cell, which I have specified in the recorded macro.
Step1) Start at the specified cell
Step 2) Fill down formula in column
Step 3) Copy and paste values in the same column
Step 4) Repeat this process until the next cell is blank.
I have recorded the macro for the freelancer to see how the macro should perform.
Step1) Start at the specified cell
Step 2) Fill down formula in column
Step 3) Copy and paste values in the same column
Step 4) Repeat this process until the next cell is blank.
I have recorded the macro for the freelancer to see how the macro should perform.
James L.
100% (13)Projects Completed
12
Freelancers worked with
8
Projects awarded
65%
Last project
12 Aug 2025
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies