I am trying to compare the data from a crystal report to the data in an excel sheet. I am attempting to have the spreadsheet compare a list of names from the spreadsheet to the ones on the crystal report. From this, data from the crystal report is supposed to flow into the spreadsheet. The process should do this with each name on the list. I will attempt to visually demonstrated below. I could do this via an IF statement but there are too many variables as the list contains 20 to 30 names. If this can't be done with a crystal report, I can convert the crystal report to excel if I must. I would be willing to do this either via VB script or within the cell. Thanks in advance for any assistance. Also, I apologize if this should be posted elsewhere....
CRYSTAL REPORT ..................................................SPREADSHEET
Column 1..........Column 2........................................Column A........... Column B
____________________________________________________________________
Billy Thomas..... 1405..............................................Aron Smith........ (false)
Steve Carr....... 990................................................Brian Long......... (false)
Cathy Roost..... 1202..............................................Billy Thomas....... (1405)
...........................................................................Steve Carr......... (990)
...........................................................................Cathy Roost....... (1202)
(the ....... are only for formatting purposes to show up correctly on the screen) Basically, the spreadsheet is to find a match from column 1 on the crystal report and then transfer the number from column 2 of the crystal report into the spreadsheet.
Bookmarks