Hello,
I am trying to split cell values in a single excel row into multiple cells rows to the bottom through VBA automation.
Attached the data workbook-
Sheet1 - Original Data set
Sheet2 - Desired Data Set
Thanks,
Vik
Hello,
I am trying to split cell values in a single excel row into multiple cells rows to the bottom through VBA automation.
Attached the data workbook-
Sheet1 - Original Data set
Sheet2 - Desired Data Set
Thanks,
Vik
there are 3 names in cell E2, there are 4 values in cell I2, why ?
If solved remember to mark Thread as solved
I guess you are referring to Cell R2. It was a Typo error, it should have only 3 values (Cell R2 - is the Sum Total for the resources)
Re-posting the corrected file...
try this code
![]()
Please Login or Register to view this content.
Thank you ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks