My company produces an update of sales each day for a month to date overview using SAS to generate a html intranet page which we can all view.
Up until now I have been copying and pasting these SAS driven tables off the intranet, into excel and then linking the cells from the pasted table into a front sheet to exactly what our department needs.
This has been fine up until today where my manager is wanting me to produce something on a daily basis, rather than a weekly basis.
I have looked into the external data web query and while this in theroy works perfectly it can sometimes not.
For instance one month the SAS driven table is in a certian order and the next it could be slightly mixed up, therefore meaning that a generalised linked cell won't always work.
Is there a way, a formula maybe, that when linking cells it first looks at a 'pointer cell' within a range... something like
If a cell within this range = ABC then link that rows x,y,z cells data
Get what I mean? It would mean I could run the web query and it won't matter where the line of data is
Up until now I have been copying and pasting these SAS driven tables off the intranet, into excel and then linking the cells from the pasted table into a front sheet to exactly what our department needs.
This has been fine up until today where my manager is wanting me to produce something on a daily basis, rather than a weekly basis.
I have looked into the external data web query and while this in theroy works perfectly it can sometimes not.
For instance one month the SAS driven table is in a certian order and the next it could be slightly mixed up, therefore meaning that a generalised linked cell won't always work.
Is there a way, a formula maybe, that when linking cells it first looks at a 'pointer cell' within a range... something like
If a cell within this range = ABC then link that rows x,y,z cells data
Get what I mean? It would mean I could run the web query and it won't matter where the line of data is
