I assume you are using the VLOOKUP formula .....which does not transfer
CommentBoxes or Formats, only cell values.....you could put the comments in
an adjacent cell and bring them in with an additional VLOOKUP formula.

hth
Vaya con Dios,
Chuck, CABGx3




"hitesh" wrote:

iam using a vlookup formula.

i have 2 sheet, in one sheet i have database in second sheet i type the
entry but in some entry i have to use comment, but this comment does not
reflect in the sheet 1 (original data base) only the entries reflect pls help.