I am just getting started with Excel Macros I have learned a great deal from
the help files and the record feature. Is there a way to copy the information
of a cell in one sheet and paste it into another based on the point the row
and column meet?

For example:

I have a worksheet named €œDataSheet€� that contain all my info. The sheet
contains various amounts and totals. I am looking to select the cell that
align with the row Total and the Column 2009. Can this be done? The locations
of these cell are different from sheet to sheet. Same structure but some
might be longer. The cell content should be insert into a blank worksheet
named "sheet1".


2007 2008 2009 2010 Total
Labor x x x x x

Rate 2 5 4 5 2

Total Price $200 $459 $300 $756
$1715


I would like to select the cell that has the total price for 2009 as an
example.