B
bn2wild
I have an excel template with 3 worksheets that I created
for others to input information into certain cells on each
sheet on a daily basis, and resulting save with similar
file names. I want to compare the information between
workbooks (plotting) to see if the trend results are going
up or down.
Is there a way to plot a chart, based upon the information
in one specific cell (or same specific group of cells)
within multiple sheets (excel 2000 or 97)?
I can present the information in various ways.
1) Same cell or group of cells within same named
worksheet, over many workbooks (files).
or I can combine the workbooks into one with each workbook
becoming a worksheet tab, then:
2) Same cell or group of cells within different named
worksheets, in one workbook (file).
Any ideas?
Thanks,
bn2wild
for others to input information into certain cells on each
sheet on a daily basis, and resulting save with similar
file names. I want to compare the information between
workbooks (plotting) to see if the trend results are going
up or down.
Is there a way to plot a chart, based upon the information
in one specific cell (or same specific group of cells)
within multiple sheets (excel 2000 or 97)?
I can present the information in various ways.
1) Same cell or group of cells within same named
worksheet, over many workbooks (files).
or I can combine the workbooks into one with each workbook
becoming a worksheet tab, then:
2) Same cell or group of cells within different named
worksheets, in one workbook (file).
Any ideas?
Thanks,
bn2wild