Do you mean you want to add the data from one worksheet to the same row of
another based on that common key.

It sounds like =vlookup() or =index(match()) would work ok.

Visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
for nice instructions.

"funky via OfficeKB.com" wrote:

I am trying to match two seperate excel sheets into a new excel sheet. The
two sheets have a common column which is numberic. How do I append one
sheeet to the other sheet, based on the common column. Thanks.

--

Dave Peterson