Ask Your Question

Thomarse's profile - activity

2018-12-11 17:55:50 +0100 received badge  Famous Question (source)
2018-09-27 23:30:46 +0100 received badge  Notable Question (source)
2018-08-08 17:33:28 +0100 received badge  Popular Question (source)
2018-08-08 09:07:56 +0100 commented answer Calc - how to fill a series from multiple rows that all reference the same row

That's brilliant, thank you! It's only a few hundred rows, so shouldn't be a problem. It's for an automated invoice spre

2018-08-08 09:07:24 +0100 commented answer Calc - how to fill a series from multiple rows that all reference the same row

That's brilliant, thanks! It's only a few hundred rows, so shouldn't be a problem. It's for an automated invoice spreads

2018-08-08 08:58:08 +0100 marked best answer Calc - how to fill a series from multiple rows that all reference the same row

I have cells in a few rows that all reference one row on another sheet:

=Sheet2.A1
=Sheet2.B1
=Sheet2.C1

When I select these cells and drag the fill handle to fill the cells below, Calc fills them like this:

=Sheet2.A1
=Sheet2.B1
=Sheet2.C1
=Sheet2.A4
=Sheet2.B4
=Sheet2.C4
=Sheet2.A7
=Sheet2.B7
=Sheet2.C7
etc.

I guess it's doing this because each new row is three cells below the original row.

This is not the behaviour I want - I want to fill them in a series, like this:

=Sheet2.A1
=Sheet2.B1
=Sheet2.C1
=Sheet2.A2
=Sheet2.B2
=Sheet2.C2
=Sheet2.A3
=Sheet2.B3
=Sheet2.C3
=Sheet2.A4
=Sheet2.B4
=Sheet2.C4
etc.

Any ideas how to do this?

I'd like to use either a formula or a manual way of doing this - I'm not familiar with macros so would rather avoid if possible, please.

2018-08-08 08:58:08 +0100 received badge  Scholar (source)
2018-08-07 21:16:34 +0100 asked a question Calc - how to fill a series from multiple rows that all reference the same row

Calc - how to fill a series from multiple rows that all reference the same row I have cells in a few rows that all refer