Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting content from cells by the cross point of the row and colum
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cross-referencing content of one worksheet with another | Excel Worksheet Functions | |||
Sum and Offset: to add from a point to the last entry in the colum | Excel Worksheet Functions | |||
Cell Content Cross Reference | Excel Worksheet Functions | |||
Why did my Excel insertion point change to a cross? | New Users to Excel | |||
Finding the value for the point two lines cross | Charts and Charting in Excel |