It is a complicated explanation, but I have about 20 similar macro
written. Each of the macros are initiated by pressing an object in
table. Then the corresponding values for what you have selected ar
entered in the cells.

For Example: Our company has offices in CA, CO, and NM. Each offic
uses different wages for each of their employees. Each office is usin
the same worksheet and I want each office to be able to select thei
office in the table and their wages to be used in the spreadsheet. Whe
the office selects their office in the table by pressing the butto
their wages are pulled from a large table with the info from all th
offices

--
mgmcdevit
-----------------------------------------------------------------------
mgmcdevitt's Profile: http://www.excelforum.com/member.php...fo&userid=2659
View this thread: http://www.excelforum.com/showthread.php?threadid=39860