Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a set of Excel-files, all with the same column headers but with a vairable amount of rows which contain data. Below the rows with the data I want to retreive, some other calculations are performed.
An example is given in the uploaded file:
If I load the whole sheet, I become rubbish in the tables because I only need the base data (product names and amounts = yellow cells) but all data (also the calculations) are imported and shown in my table.
Extra information on the source-files: The structures is always the same.
The only variable is here "X" (=amount of products), but is unknown at time of executing the script.
Can someone help me to create a LOAD-statement that can perform the above ?
Thanks in advance !
Message was edited by: brugst13 upon request from Deepak Vadithala
I'm glad it's working. You are welcome.
Cheers,
DV