Forum Discussion
How to import 2 blocks of data from a single Excel File?
Hi All, I was wondering if anyone had a challenge like mine and managed to success. We receive customer forecast in a weird format. It is an Excel spreadheet, data is pivoted and in two block of...
Many thanks for your suggestion, however this does not resolve my issue, I should have been more precise.
I need to pick these files up from a folder, therefore need a solution that will work without manual intervention.
I want use the created date as a forecast date and then compare.
The ony thing I fail on is how to 'split' these two blocks of data where amount of line items within are variable.
thanks
Bish