I was wondering if anyone here knows how to somehow 'link' rows in one
worksheet to a row in another worksheet, almost as if they were pegged
together. I have a worksheet that has a list of inventory: one worksheet is
all the buying details (date paid, amount paid, etc), while the other is all
of the selling details (date sold, amount sold for, etc). Right now, I have
the names of the merchandise in the second sheet (which is the selling sheet)
copied and pasted via formula (i.e. A1 on the selling sheet=BUY!A1), so that
I don't have to enter the namesing twice and so that all the information on a
row in either sheet relates to the same item. However, if I wanted to delete
a certain row (or even worse, add one), in the middle, I'd have to manually
do the same thing on the other sheet as well. And forget about re-sorting
everything without a whole lot of work.

So, basically what i want to know is if there is a function or formula that
'pegs' the rows in one sheet to the respective row in another sheet, so that
if I delete a row or change the items location on the list (or want to sort
based on all parameters of both sheets), it will change on the other sheet as
well.

Essentially, I need it so that two worksheets acts as one, while still
having separate worksheets (if that's possible).

aaron