Data Collection with forms

[MinerExcel]

I have a repeating excel form that I fill out everyday. I am trying to create a page in the workbook that will collect all the data from each form and create a table by dates and particular cells on forms. If anyone has any ideas I would greatly appreciate any advise or suggestions.

Thank you,

 

[chrism216]

I have a repeating excel form that I fill out everyday. I am trying to create a page in the workbook that will collect all the data from each form and create a table by dates and particular cells on forms. If anyone has any ideas I would greatly appreciate any advise or suggestions.

Thank you,

This is an extremely vague question...

You should consider Access for this. If you do it in Excel, you will have to do a lot more work.

Cheers,
Chris

 

[MinerExcel]

chrism216,

Will Access let me make graphs? I've never used Access before. What I currently have in my workbook is "Graphs" for the Sheet 1, Sheet 2 is "Data" its list of temperatures taken at different location of my plant each day. All following pages are repeats of the same form named for their date in mm-dd format so the sheet name for 8/22/16 was "08-22". Im trying to find a formula or macro that will let me fill out my data list easier to form my graphs.

Thank you,

 

[chrism216]

chrism216,

Will Access let me make graphs? I've never used Access before. What I currently have in my workbook is "Graphs" for the Sheet 1, Sheet 2 is "Data" its list of temperatures taken at different location of my plant each day. All following pages are repeats of the same form named for their date in mm-dd format so the sheet name for 8/22/16 was "08-22". Im trying to find a formula or macro that will let me fill out my data list easier to form my graphs.

Thank you,

No, it wont. But you can easily set up a link between an excel workbook, where you do the reporting, and Access, that stores the actual data.