If your data is in A1 thru A3, then in B3 enter:
=A2
--
Gary''s Student - gsnu200907


"Bklynhyc" wrote:

Hi,

Would like to fill in a blank cell with something, it located in another
area of the list,

it looks like this, **** means blank cell

merchant
1234
Totals ****

I would like to put the merchant number next to the total cell.