Hello,
I want to quickly copy data between two worksheets within the same work book - one contains the source data and another acting as the summary sheet. In the source data I record cost entries by type and by month with Cost Type as column headers and a row for each month. E.g
A B C D
1 Travel Telephone Petrol
2 Jan £10 £5 £4
3 Feb £5 £23 £7
4 Mar £4 £7 £21
In the summary sheet I want to replicate this but am recording months it horizontally - so it should look like this:
A B C D
1 Jan Feb Mar
2 Travel =Book1!B2 =Book1!B3 =Book1!B4
3 Telephone =Book1!C2 =Book1!C3 =Book1!C4
4 Petrol =Book1!D2 =Book1!D3 =Book1!D4
I can link the dat for one cell easily enough (i.e. "=Book1!B2") but when I try and drag across to the other cells I get the next increment of letter rather that number e.g cell E2 for Travel in April becomes =Book1!C4 not =Book1!B5.
I often struggle with this and wondered which formula and syntax I need to use please - I looked at transpose() but do not think it is the right one. I need to do this for loads of data help much appreciated!
Thanks
Bookmarks