I am trying to work a macro which will do the work for me (go figure).
Here is the easy example. I have a worksheet which has a 3 columns an
a bunch of rows: the column headings are " ", "total", "add-on"
the rows then consist of "mike","1,000","200"... then next ro
"cindy","1,230","23" etc
I would like a different worksheet to have a macro button that ca
take the data and put it into a new table and stuff.
I was thinking along the lines of creating labels on the top and left
and then referencing the numbers according to the labels.
For instance =intersect("total","mike") would produce 1,000
Any ideas on how to get this to work? Obviously using absolut
refernces like "B2" would work but the worksheets cell locations ma
vary thats why I was thinking making labels would work.
Thanks a bunch!
Mik
--
Message posted from
http://www.ExcelForum.com