edkawy79
07-10-2020, 05:49 AM
Hello,
I am working with large file everyday ( more than 50000 rows and increasing day by day ) and sample of this file attached
The movement of work start in column FROM ( which contain name of team ) and that team most of time has to reply to the request number mentioned in column named “ Trn Number”.
Always the reply appear in the row below ( not necessary in the row below but sometimes it may appear many rows than row contain same information in row named :FROM”.
My request is that I want the reply to be in same row corresponding to row named From not in the below rows.
I made manual example for the result of data that I wish to be automatically generated using VBA since formula will not work very fast with this amount of data .
Thanks a lot for your support
I am working with large file everyday ( more than 50000 rows and increasing day by day ) and sample of this file attached
The movement of work start in column FROM ( which contain name of team ) and that team most of time has to reply to the request number mentioned in column named “ Trn Number”.
Always the reply appear in the row below ( not necessary in the row below but sometimes it may appear many rows than row contain same information in row named :FROM”.
My request is that I want the reply to be in same row corresponding to row named From not in the below rows.
I made manual example for the result of data that I wish to be automatically generated using VBA since formula will not work very fast with this amount of data .
Thanks a lot for your support