Click here to Skip to main content
15,744,304 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am trying to dragdown a formula which is

Currently it won't drag down column number to be F, G, H, etc. My current sheet I am doing this in is ReportOwnerQuery. The sheet I'm trying to dragdown from is SecurityLevels. Manually changing the Column letter works but is super inefficient as I have to do it to JF. The Security levels sheet has a list of names in Row 1 starting in Column C and going to JF. Could I make an Indirect that will help with this so I can just drag it down to change column letter? Will be a lot quicker than doing Find and Replace every line.

What I have tried:

Find and Replace every line, it works but is super inefficient.
Tried a Indirect() but I can't get it working quite properly. I got it working in the SecurityLevels sheet for part of the complex calculation I was doing. Here is one cells example:

Working manual solution: A solution from copy pasting would be what I am using until I figure out a formulated way was to switch to copy the formula to a an empty row, drag it to the right as much as I needed the go into Formula view mode (CTRL+`). Copy and paste the formulas with columns different into Notepad then paste where I wanted to originally drag down.
Updated 24-Apr-19 9:33am

1 solution


Is a conditional solution.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900