Quote:
Originally Posted by saurabhlotankar
Hi Guys,
NoSparks, I tried your code it works perfectly fine. But i have 80000 rows in my data so it takes lot of time to complete the task.
excelledsoftware, I tried your code but could not write it properly. If you could provide me the worksheet function code then that will be great coz it will save lot of time.
Thnaks guys. |
Yes I will have this complete for you later tonight. Please keep in mind that 80000 rows will still take a little bit of time but it shouldn't be bad After it is done. We may want to consider additional options if you find it still takes too long. I will write it up for you later tonight