Hi, I have an Access database that I have exported into Excel. There are
many fields for each record. One field is common to this sheet and to
another sheet that is I have generated from a delimited txt file produced by
running a batch query on a different non-microsoft databse. Is there any way
to combine the two sheets into one, using the common range, but individually
by the differnt values contained in that range. I.E. Col A = Name B=Age
C=Height D=weight and the next sheet Col A=Name B=Mass C=Color D=Birthday.
I want to produce a report that has all the fields combined and specifically,
the correct data attributed to the correct name. I have tried pivot tables
and looked at consolidation, but neither seems to work for me. Appreciate
your suggestions and assistance.