I am working on a single page report that needs to show data from multiple sheets..
Say.... I type in cell a1 "Project No.1" & in cell A2 the month, say "Nov.04".
The cell in a3 will have the account ( Say Utility GAS).
(Please note that cell A1 and Cell A3 will be keyed in with several project names and months.The workbook has number of actual project data.)
The question is what formula need to be used in cell "B3" to get the
amount from the worksheet Project No.1 and coloumn Nov.04 .
Thank you.
Nanda
Say.... I type in cell a1 "Project No.1" & in cell A2 the month, say "Nov.04".
The cell in a3 will have the account ( Say Utility GAS).
(Please note that cell A1 and Cell A3 will be keyed in with several project names and months.The workbook has number of actual project data.)
The question is what formula need to be used in cell "B3" to get the
amount from the worksheet Project No.1 and coloumn Nov.04 .
Thank you.
Nanda