Ivory
New member
- Joined
- Jul 28, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Location
- Williston, ND
- Excel Version(s)
- 2016
I have been quite literally STUCK on this issue for the last month. Hopefully someone will be able to point me in the right direction:
PROBLEM: Everyday, my site takes in trucks hauling salt water. Each load comes from one specific oil well location and is never in the same order on any given day nor the same amount of barrels hauled. At the end of each month, the state requires us to complete a form that includes how many barrels we in took for that month, by each individual well pad. As seen in (Sample_MasterList), each one of these wells have legals (file number, location) determined by the state that also must be included in this form. Due to the horribly formatted form provided and required to use per the states requirements (FORM16TEMP), I am not able to just simply copy and paste neither rows or columns of data together; the form has merged multiple cells together and it is also password protected.
WHAT I HAVE DONE SO FAR: Prior to me signing on, this process took DAYS to complete. I've revamped the excel spreadsheet (Sample_DailyLogs) used to input the daily logs so that now it includes a pivot table at the end of the month's workbook that automatically tallies these totals. I also put together a "master list" of well locations with their corresponding legals (Sample_MasterList). This list included roughly 8000 wells and their legals. By running a macro, I was able to retrieve the password for the state's form yet trying to reformat it in a way which allows simple copying and paste, lets just say has turned into a nightmare.
WHAT I NEED HELP FIGURING OUT: Is there any way I could type in the well's name on the form and have its corresponding legals auto populate from the master list I have created? Or even better, have the form populate itself from the pivot table in the daily log workbook we use to calculate the monthly total's individually? I'm open for ideas on how to make this work where I am not having to copy and paste 5 times in order to input one row of data in a list of 80-100 rows of data.
PROBLEM: Everyday, my site takes in trucks hauling salt water. Each load comes from one specific oil well location and is never in the same order on any given day nor the same amount of barrels hauled. At the end of each month, the state requires us to complete a form that includes how many barrels we in took for that month, by each individual well pad. As seen in (Sample_MasterList), each one of these wells have legals (file number, location) determined by the state that also must be included in this form. Due to the horribly formatted form provided and required to use per the states requirements (FORM16TEMP), I am not able to just simply copy and paste neither rows or columns of data together; the form has merged multiple cells together and it is also password protected.
WHAT I HAVE DONE SO FAR: Prior to me signing on, this process took DAYS to complete. I've revamped the excel spreadsheet (Sample_DailyLogs) used to input the daily logs so that now it includes a pivot table at the end of the month's workbook that automatically tallies these totals. I also put together a "master list" of well locations with their corresponding legals (Sample_MasterList). This list included roughly 8000 wells and their legals. By running a macro, I was able to retrieve the password for the state's form yet trying to reformat it in a way which allows simple copying and paste, lets just say has turned into a nightmare.
WHAT I NEED HELP FIGURING OUT: Is there any way I could type in the well's name on the form and have its corresponding legals auto populate from the master list I have created? Or even better, have the form populate itself from the pivot table in the daily log workbook we use to calculate the monthly total's individually? I'm open for ideas on how to make this work where I am not having to copy and paste 5 times in order to input one row of data in a list of 80-100 rows of data.
