Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have an excel which have sales data week wise.
Each week a new week column will be added and the number of columns will not be constant.
I am using a cross table in order to get the sales in single column.
Now the problem is the new columns,so each week i have to add the new week field in the script to get the latest data Manually.
Is there any way to automate it so that the the script can load the newly added field by itself.
Thanks in advance..
Regards,
Reena
Simply Use Load * from Xls it will automatically adds newly added columns.
Vikas
Yes,
i tried.but the new columns were not loaded when using a cross table.
Hi,
You could load the table without pivoting it and create columns on the number of values in Month and Week column.
Hope thats useful.