Hi,
Need help on this. I'm trying to somewhat automate this report using macro (hopefully). The attached file has 2 sheets.
- 1st sheet Input shows the data extracted from sharepoint2003. BTW, I'm using Excel2007. As you may see, Columns B, C, D and E are combined in one cell.
- 2nd sheet Output is what I need the outcome to be.
Thanks,
Need help on this. I'm trying to somewhat automate this report using macro (hopefully). The attached file has 2 sheets.
- 1st sheet Input shows the data extracted from sharepoint2003. BTW, I'm using Excel2007. As you may see, Columns B, C, D and E are combined in one cell.
- 2nd sheet Output is what I need the outcome to be.
Thanks,