I am using a Spreadsheet as a form. Currently my people are printing out the form and hand writing the data in to the cells. I was wanting to speed things up.
We have 2 exported reports that could be used to fill in the data fields and ranges. Currently I've been cutting and pasting the data into the Workbook.
I was wondering if I could reference the active sheet in my formulas to gather the data without cutting and pasting. I have some pretty elaborate if formulas such as:
=IF(AND(CopyRM!$AA15="REPORT",CopyRM!$Z15="Within Limits"),CopyRM!$V15,"")
another one is:
=IF(CopyRM!AA9="REPORT",(VLOOKUP("SPECIFIC GRAVITY",CopyRM!E4:AH20,14,FALSE)),"")
What is the best way to have it gather the data? The auto file name is quite long or could I save it as a predetermined file name?
People are fighting me on the automation but it drives me nuts to manually hand write these fields.
Thanks in advance
We have 2 exported reports that could be used to fill in the data fields and ranges. Currently I've been cutting and pasting the data into the Workbook.
I was wondering if I could reference the active sheet in my formulas to gather the data without cutting and pasting. I have some pretty elaborate if formulas such as:
=IF(AND(CopyRM!$AA15="REPORT",CopyRM!$Z15="Within Limits"),CopyRM!$V15,"")
another one is:
=IF(CopyRM!AA9="REPORT",(VLOOKUP("SPECIFIC GRAVITY",CopyRM!E4:AH20,14,FALSE)),"")
What is the best way to have it gather the data? The auto file name is quite long or could I save it as a predetermined file name?
People are fighting me on the automation but it drives me nuts to manually hand write these fields.
Thanks in advance
