Bee hive problem for zbor

[355tttransam]

I tried adding that line and it didn't work.

The data in column Y is for column A
The data in column AA and AB is for columns T and U

When entered the fill input table button works perfect, but when you hit the sort hive button all data after row 134 is not transferred and you will see that there are extra entries recorded for hive R44 other then its one box.

Thanks for your swift replies.

[Kaper]

shall this post really go to this subforum? Or may be to commercial services one?

[zbor]

This is a CS but user can't access to old post so I've told him to open it here.

[zbor]

I've found a problem.. There was no need to limit string.
I've fix it now.
However, there is another problem now that it looks only for numeric values in column A...

Please Login or Register  to view this content.

I can't remember original criteria why this was important but it doesn't transfer now R.. and F..'s

Should it look for next row?

[355tttransam]

The alphanumeric r's and f's are important because I have 10 separate lots of alphanumeric numbers 1 to 100.
That new file transfers the first part ie. the r's and f's, but it doesn't transfer the box and box kg data now when you press the sort hive button?

[Kaper]

This is a CS but user can't access to old post ...

I suspected something like that

[zbor]

The alphanumeric r's and f's are important because I have 10 separate lots of alphanumeric numbers 1 to 100.
That new file transfers the first part ie. the r's and f's, but it doesn't transfer the box and box kg data now when you press the sort hive button?

Because they are not define in the VLOOKUP table (T-U).

In this scenario, what would be output you expect?
can you fill First 2-3 rows (G2:P4)

[355tttransam]

sorry for not replying sooner, had to get some sleep!
This is what I would expect.

Wayne.

[zbor]

Check this out and let me Know if thre would be some problem with your other data:

[355tttransam]

Fixed!!!!!

It works perfectly in all respects.

Thankyou very much. Can I send you another 50 points for your time and effort, you have no idea how much this has helped me out.

[zbor]

Fixed!!!!!

It works perfectly in all respects.

Thankyou very much. Can I send you another 50 points for your time and effort, you have no idea how much this has helped me out.

Thanx.
You must open new thread in CS service for that

[355tttransam]

One more tiny thing.......
With the original when you hit the extract and delete data button it would delete all the data, including the weight data in columns T and U.

Would it be possible to make it do this again. Sorry I didn't pick up on it when I first looked.

[zbor]

No problem.
I don't see that in original code but here, added at the end:

Please Login or Register  to view this content.

[355tttransam]

Worked perfect, only needed to add the T2 cell line. Thanks again.

[355tttransam]

I opened a new thread in the commercial section with the title you suggested.