I've got 2 colums of data i'm pulling from a database and pulling into excel as a database sql qry.
What I want to do is on another spreedsheet create a new set of coloms that this would happen:
If I enter a number in Colum A and it ='s a cell in the column in other spreedsheet it will "copy" the data from spreedsheet 2.
Sheet 1- Colum A and Colum D
Sheet 2- Colum A and Coum D
If Sheet 1 Colum A = Sheet 2 Coum A then Sheet 1 Colum D = Sheet 2 Colum D
hope I explained that well enough.