- Excel Data Copy
- Transfer data from one excel worksheet to another automatically - Guide
- Excel date format dd.mm.yyyy - Guide
- Digital data transmission - Guide
- Number to words in excel - Guide
- Vba code to search data in excel - Guide
I loathe to say that it cannot be by formula only as I am sure some one would know how. But from my limited knowledge, I think this all can be done via macro very easily.
Thanks rizvisa1, yes sorry should have said macro - yes agreed shouldn't be a hard one - I just don't know the answer :-)