How do I copy an absolute column and relative row to the right?

F

Fusterated

I have 75 items in 1 column. The values for the 10 rows to the right are the
same column but different rows each 1 higher than the last.

For instance, C10, C11, C12, C13, etc...

I want to keep C as a constant but have the numbers increase.

Even when I mare the column as a constant and the row as an absolute $C10 it
won't update. It still say $C10 when I copy it.
 
G

Gary L Brown

If I understand you correctly, you want to copy C10 to D10, E10, F10, etc and
have D10 =C11 / E10 = C12 / F10 = C13, etc.
As far as I know that can't be done.
However, a workaround would be to Copy C10 DOWN as far as you need then use
Copy / Paste Special and select the Formula and Transpose options.

HTH,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to copy a formula to a 100 cells 3
IF argument limit - how convert formula to VBA? 2
Copy and Paste Conditional Formatting 3
Macro Relative Cells 3
Eliminate blanks while copy row and transpose 11
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Format column widths from one table to a separate table on same page 1
copy cells down a column (in order) to across a row (same order?? 1

Top