I am trying to create a macro to populate another worksheet. I did m
subtotals, but when I do a link from the subtotal page in the ne
document, it gives me a specific cell number...I want it to be dynami
and find the cell number.

For example, on the subtotal page, there are 3 columns and 3 rows fo
the totals...and I want to pull the total #1 without specifiying th
row "C2204". Is there a code/command that will do a find on a key wor
and then use the cell that is to the right or left of it?

Sorry so confusing....this is new to me. Thanks much

--
luvsun2
-----------------------------------------------------------------------
luvsun27's Profile: http://www.excelforum.com/member.php...fo&userid=3149
View this thread: http://www.excelforum.com/showthread.php?threadid=51173