B
Bodster
Thank you so much for that, it'll save loadsa time. I adjusted the formula
as the original sheet contined 11 columns of data.
Can you help with this part now?
The original sheet had dates in Column E (in the form Jan-03). Thay have
come through on the new sheet in the single column as 5 digit figures such
as 37622. Is there any way of getting
the original form of the date back, affecting just rows 5, 16, 27 etc...of
the new sheet? Perhaps I need to format just these rows on the NEW sheet.
A similar problem exists with column I of the original where the £ sign has
been lost. Again is there any way of getting this sign back in the new sheet
just on rows 9, 20, 31 etc..
Cheers,
Bodster
Say data is on Sheet1, from A1 to H3000.
Enter this formula *anywhere* you wish on another sheet, and copy down 3000
rows:
=INDEX(Sheet1!$A$1:$H$3000,ROWS($1:8)/8,MOD(ROWS($1:1)-1,8)+1)
as the original sheet contined 11 columns of data.
Can you help with this part now?
The original sheet had dates in Column E (in the form Jan-03). Thay have
come through on the new sheet in the single column as 5 digit figures such
as 37622. Is there any way of getting
the original form of the date back, affecting just rows 5, 16, 27 etc...of
the new sheet? Perhaps I need to format just these rows on the NEW sheet.
A similar problem exists with column I of the original where the £ sign has
been lost. Again is there any way of getting this sign back in the new sheet
just on rows 9, 20, 31 etc..
Cheers,
Bodster
Say data is on Sheet1, from A1 to H3000.
Enter this formula *anywhere* you wish on another sheet, and copy down 3000
rows:
=INDEX(Sheet1!$A$1:$H$3000,ROWS($1:8)/8,MOD(ROWS($1:1)-1,8)+1)