J
jra1031
I am using Excel 2000. I have a workbook with 100 worksheets. All of the
worksheets have the same column and row headers. The data is 100 different
pricing situations. I want to make another worksheet that will be able to
gather the data from a cell of one of 100 worksheets by specifing ( on the
new worksheet) the row, column and worksheet. Can Excel look at three cells
to determine the date needed for the fourth?
I do not even know if Excel is the program I should use.
Please help.
worksheets have the same column and row headers. The data is 100 different
pricing situations. I want to make another worksheet that will be able to
gather the data from a cell of one of 100 worksheets by specifing ( on the
new worksheet) the row, column and worksheet. Can Excel look at three cells
to determine the date needed for the fourth?
I do not even know if Excel is the program I should use.
Please help.