Hello everyone
I have names in range("A2:A6") and in range("B2:C6") related date
In Columns D:H I need to convert the data related to each name to long format
I have attached the output
Hello everyone
I have names in range("A2:A6") and in range("B2:C6") related date
In Columns D:H I need to convert the data related to each name to long format
I have attached the output
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi,
Please Login or Register to view this content.
Regards
Thank you very very much for this effective and fantastic solution
You are excellent in using arrays ... It's very enjoyable using arrays in solutions .. fast and reliable
I could get most of the code .. thanks a lot Mr. Karedog
You are welcome, thank for the reps. When I first begin learning VBA, I start to coding by using GUI elements of Excel (cell by cell operation), but later when I try using array to solve the problems, I amazed on how fast and feasible using it, and since then I learn and experiment a lot of thing with array, it is something to good to be true.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks