Hello everyone.
I have an Excel workbook that I use to record a set of daily observations. Each day I copy a template worksheet I have and use that copy to log that days observations and repeat. I would like to create a worksheet containing a column of entries that come from a unique cell in each daily worksheet.
i.e., I would like to know how to use a formula to access the data in another cell in another worksheet, so that I don't each day, have to compile that data by hand. Or at least have a way to use Excel's autocomplete function to do 30ish days worth of observations relatively quickly.
Attached is a sample workbook that might better explain what I'm trying to achieve. The sheet "Entry1" contains a typical set of entries. I have a workbook containing around 300 or so of these sheets, and I would like to take the contents of cell D3 in each one and populate a list of them on the sheet "Summary" so that I might do statistics on them. I've gathered from a lot of searching that the solution probably involves some combination of the INDIRECT and/or CELL functions, but I am not quite sure how to implement them.
Thanks,
tb
Bookmarks