Excel Automation with Macros
Budget: $10 – $50 USD
I need an expert in Excel macros to develop a tool for me that would allow me to automate some specific tasks as I work in Excel.
Key Specifications:
- The tool needs to be able to automatically format cell values. I will provide the existing format and the new format that I want.
- It should be able to add text boxes to specific cells in the Excel file. The content of the text boxes will vary depending on the content of the respective cells.
- The tool should allow me to delete specific columns based on the value in a particular cell.
Ideal Skills:
- Proficiency in Excel macros/VBA
- Prior experience in customizing Excel files
- Good communication to understand my needs and implement them accurately
I have an excel sheet with production data, the file has extra data that i do not need, so i need Macros to delete certain columns, change column widths, change column names, wrap text if needed, add several text boxes that will appear on the output file if filled in, have print preset done as well. i will provide actual files and examples if you're interested in this small project.
Key Specifications:
- The tool needs to be able to automatically format cell values. I will provide the existing format and the new format that I want.
- It should be able to add text boxes to specific cells in the Excel file. The content of the text boxes will vary depending on the content of the respective cells.
- The tool should allow me to delete specific columns based on the value in a particular cell.
Ideal Skills:
- Proficiency in Excel macros/VBA
- Prior experience in customizing Excel files
- Good communication to understand my needs and implement them accurately
I have an excel sheet with production data, the file has extra data that i do not need, so i need Macros to delete certain columns, change column widths, change column names, wrap text if needed, add several text boxes that will appear on the output file if filled in, have print preset done as well. i will provide actual files and examples if you're interested in this small project.