Not incrementing cell reference

P

Picc

Is it possible to copy and paste a cell with a formula containing
reference to another sheet of data into a cell on another row withou
incrementing the cell reference?

Sheet1
1A(x)
2A(y)
3A(z)

Sheet2
1A(x)
2A
3A(y)
4A
5A(z)

So that the rows are shipped on sheet2 but the reference is not skippe
sheet1.

Thank
 
P

Picc

I should have been more clear. I need just one increment. The issue i
incrementing too many rows. I need it only to increment 1 row, as in th
next row down the column, instead of incrementing the number of row
that I have skipped in the formula sheet.

I'm trying to duplicate a formula and skip rows, but pull data from on
column with no rows skipped.

I have tried using the OFFSET() and INDIRECT() function but they seem t
only do the opposite of what I need. I haven't tried these with
though.

I need: (for a rough example)

B1=A1
B2=empty
B3=A2

Instead I get:

B1=A1
B2=empty
B3=A3

When I duplicate cell B1 into B3 (skipping a row) I get the referenc
skipped as well. This makes sense with the relative reference operation
I just want to get around to avoid skipping the references. So tha
B3=A2.

Please let me know if I'm even on the right track for this. If you hav
a moment, I appreciate you help very much.

Perhaps I can explain what I'm trying to with the data...let me know.
can send examples for more clarity.

Thank
 

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

Top