Transfering or extracting data

[Joey]

Hi

Is it at all possible to transfer data which is accumulated by tex
(reference number). The search should produce all the infomation wit
regards to the ref. number.

Thanks to Frank for the help earlier but I am still struggling to ge
all the data in the search.

I have attached the spreadsheets which demonstrate what I'm trying t
do.


Thanks
Joe

Attachment filename: timesheet test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56275

 

[Debra Dalgleish]

Assuming the entries on sheet 1 are sorted by Ref#, the following should
work:

On Sheet2, in cell B14, enter:

=IF(ROW()-13>COUNTIF(Sheet1!$A$2:$A$30,$D$2),"",
OFFSET(INDEX(Sheet1!$A$2:$A$30,MATCH($D$2,Sheet1!$A$2:$A$30,0)),ROW()-14,7))

In cell C14, use the same formula, changing the final number from 7 to 4
In cell D14, use the same formula, changing the final number from 7 to 5

Copy these formulas down to row 27

In cell C28, change the formula to: =COUNTIF(C14:C27,">0")

 

[Joey]

Thanks for the help Debra. The formula is spot on.
Weww, I was beginning to think there was no hope with this..

Thanks to the other folk who helped as well.

Cheers
Joe