Macro for copying value
 

If at all possible...........
Insert a column in the "product" sheet so that all sheets have the same
layout.
select all sheets and enter or delete a value in the product sheet. The
same action will happen in the other sheets.

To select all sheets.......right click on the sheet tab and "select all
sheets"


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=401300