Hello. i have this formula in a cell =O$13*O$6 in the row below I have =O$14*N$6 and then it follows this pattern going down the column. I want to be able to change the O13 to a different starting point and then copy it down, for example, O20, O21, etc. The problem is that I don't want to change the second part of the reference (which goes backwards and is fixed on row 6). Is there any way to do this other than manually?
Maybe this thread may give you an idea for using VBA code.
http://www.excelforum.com/excel-prog...-formulas.html
For how many columns backwards in row 6 does this go?The problem is that I don't want to change the second part of the reference (which goes backwards and is fixed on row 6).
With the understanding that they go all the way back to column A (15 columns) try this formula and fill down.Formula:
Please Login or Register to view this content.
Last edited by FlameRetired; 12-10-2015 at 11:35 PM. Reason: clarification
Dave
@flame. That worked. Thank you.
Glad to hear it. You're welcome and thanks for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks