First, Sorry if this is meant to be in the programming forum, I'm not to sure if it requires programming or just some addtionally settings.

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