I am trying to use the Indirect formula to copy across my worksheet data that appears down the page. I am having trouble figuring out what arguments I would need to tell the formula to ignore its orginating cell but copy all other cells across in the range. Here is my example

A1 B1 C1 D1 D2 D3 D4 D5 D6

1 C100 C101 C102 C103 C104 C105 C106

2 C101 C100 C102 C103 C104 C105 C106

3 C102 C100 C101 C103 C104 C105 C106

4 C103

5 C104

6 C105

As you can see the data going across will ignore the orginating cell from the INDIRECT formula (A1,A2,A3 etc) but include the rest. Is this possible?

Thanks