Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert contents of variable cell address
I have a spreadsheet with same income/expense line items (rows) for each of
the 12 months. Each sheet has the same row line items and each sheet has the same 12 columns for months. I have 3 years of data : 2007, 2008, and 2009. Each year is its own sheet. I want to make a summary sheet where a month/year is entered and 3 columns are displayed: the same line items for month A 2009 adjacent to the same line items for month A 2008, and the same line items for month A 2007. Since sheet name and row are set the only real variable is month. I can compute the column portion of cell address by using char(65) + month(selected month/year) but what I get is a cell whose contents are the computed address rather than the contents of the computed cell address. I tried using cell("contents", with computed address but I just get errors). Am I violating an Excel law by computing a cell address and trying to load the contents of that cell into the same cell where the address was computed? Does this require a macro? Our local expert is stumped. Office 2007 Excel Vista |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a specific address from a list if the contents of cell A1=x | Excel Worksheet Functions | |||
Insert Cell Contents in middle of web address | Excel Discussion (Misc queries) | |||
How do I use cell contents as an address in a formula | Excel Worksheet Functions | |||
Can the column index in a cell address be made variable? | Excel Discussion (Misc queries) | |||
Setting a variable cell address | Excel Discussion (Misc queries) |