Good Morning,
I've got a small problem that I hope you can help me with. I have a list of clients in excel. I do a lookup based on the client number and I then populate a form based on the information found in the row that contains that client number. The formula that I use is as follows:
ClientName = Application.WorksheetFunction.Lookup(ActiveSheet.Range("A2"), Worksheets("Clients").Range("A:A"), Worksheets("Clients").Range("B:B"))
Recently someone updated the spreadsheet using a dynamic sql query linked to another database. This allows excel to always have an updated copy of the customer file in the worksheet titled "Clients". It appears that this data is in a table titled "Connection" which is the link to the database. My problem is that all my formulas that access the Clients worksheet no longer work. I am assuming that this is because the data is now in a table instead of actually being on the worksheet page in the cells.
If that is the case, can someone please explain to me how to convert the above lookup formula to access the data in the table? Your help in this matter is, as always, deeply appreciated.
Thank you,
JDeiley
I've got a small problem that I hope you can help me with. I have a list of clients in excel. I do a lookup based on the client number and I then populate a form based on the information found in the row that contains that client number. The formula that I use is as follows:
ClientName = Application.WorksheetFunction.Lookup(ActiveSheet.Range("A2"), Worksheets("Clients").Range("A:A"), Worksheets("Clients").Range("B:B"))
Recently someone updated the spreadsheet using a dynamic sql query linked to another database. This allows excel to always have an updated copy of the customer file in the worksheet titled "Clients". It appears that this data is in a table titled "Connection" which is the link to the database. My problem is that all my formulas that access the Clients worksheet no longer work. I am assuming that this is because the data is now in a table instead of actually being on the worksheet page in the cells.
If that is the case, can someone please explain to me how to convert the above lookup formula to access the data in the table? Your help in this matter is, as always, deeply appreciated.
Thank you,
JDeiley
