adapt or redesign an existing excel spreadsheet
Budget: $30 – $250 AUD
ADAPT, AUTOMATE and FORMAT an Existing Spreadsheet (Excel).
I am looking for a freelancer who can adapt an existing excel spreadsheet to improve formatting and automation. The primary purpose of the spreadsheet is for bore log data and visual graphing and subsequent pasting into a word document.
I would like to see enhanced automation functionality in the adapted spreadsheet.
Specifically, I want to automate 2 tasks in the spreadsheet. I specifically require the following points:
1/. Allow imported data to populate certain identified spreadsheet cells.
2/. Automatically, generate the finished graph and import graph fill images.
3/. Format and Resize the final adapted Spreadsheet and Graph to a fixed standard and sized ready for importation to a word template document.
4/. Protect the spreadsheet from any format changes or any other changes apart from (point 1).
Please see my video link showing the existing use (run through): https://drive.google.com/drive/folders/1WVuvKlsWU3RK1rqKlqaScwJABHUgOZ8i?usp=sharing
Pdf Picture of existing spreadsheet (attached).
This is a simple process for VBA and Excel skilled Freelancers.
Ideal skills and experience for this job include:
- Advanced knowledge of Microsoft Excel
- Experience in graphing
- Proficiency in creating automation functions in Excel
-VBA
I am looking for a freelancer who can adapt an existing excel spreadsheet to improve formatting and automation. The primary purpose of the spreadsheet is for bore log data and visual graphing and subsequent pasting into a word document.
I would like to see enhanced automation functionality in the adapted spreadsheet.
Specifically, I want to automate 2 tasks in the spreadsheet. I specifically require the following points:
1/. Allow imported data to populate certain identified spreadsheet cells.
2/. Automatically, generate the finished graph and import graph fill images.
3/. Format and Resize the final adapted Spreadsheet and Graph to a fixed standard and sized ready for importation to a word template document.
4/. Protect the spreadsheet from any format changes or any other changes apart from (point 1).
Please see my video link showing the existing use (run through): https://drive.google.com/drive/folders/1WVuvKlsWU3RK1rqKlqaScwJABHUgOZ8i?usp=sharing
Pdf Picture of existing spreadsheet (attached).
This is a simple process for VBA and Excel skilled Freelancers.
Ideal skills and experience for this job include:
- Advanced knowledge of Microsoft Excel
- Experience in graphing
- Proficiency in creating automation functions in Excel
-VBA