G
Guest
I want to create a secondary excel sheet that combines information from a
primary sheet. The primary sheet contains an extract of data from Pastel
which is an asortment of data in rows and columns. However, the data is
repeated at regular intervals. Eg. Cell B4, B17, B30 contain same data for
different clients. I want a formula that I can drag and drop which increases
the cell reference from =sheet1!B4 to =sheet1!B17, to =sheet1!B30 etc. Sheet
2 will have all data in columns, the first row of which I have copied across
to sheet 2 as =B4; =B5; =A7;=D4; etc.
Hope this makes sense.
HELP
primary sheet. The primary sheet contains an extract of data from Pastel
which is an asortment of data in rows and columns. However, the data is
repeated at regular intervals. Eg. Cell B4, B17, B30 contain same data for
different clients. I want a formula that I can drag and drop which increases
the cell reference from =sheet1!B4 to =sheet1!B17, to =sheet1!B30 etc. Sheet
2 will have all data in columns, the first row of which I have copied across
to sheet 2 as =B4; =B5; =A7;=D4; etc.
Hope this makes sense.
HELP