How to copy down a formula down following a sequence ( in this case skipping a row)

[milkychips]

For example

A1 equals Data!A1
A2 equals Data!A3
A3 equals Data!A5

When I highlight A1:A3 and drag down
A4 becomes Data!A4
A5 becomes Data!A6
A6 becomes Data!A8
A7 becomes Data!A7
A8 becomes Data!A9
A9 becomes Data!A11

where as i would like it to do

A1 equals Data!A1
A2 equals Data!A3
A3 equals Data!A5
A4 equals Data!A7
A5 equals Data!A9
A6 equals Data!A11
A7 equals Data!A13 etc etc

Any help would be appreciated

[BadlySpelledBuoy]

How about something like:

Please Login or Register  to view this content.

See attached.

BSB

[milkychips]

Wow

Thank you very much

[BadlySpelledBuoy]

Only easy when you know how... Happy to help!

Thanks for the rep point and don't forget to mark the thread as SOLVED if you're happy you have a working solution.

BSB