I need some custom formatting macros and tools for Excel written in VBA
- or -
Post a project like this$
- Posted:
- Proposals: 14
- Remote
- #1257073
- Expired
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
6148235042190162702693527604165904864956498651079205119279812373831347532
Description
Experience Level: Entry
General information for the business: We do excel spreadsheet modelling courses
Kind of development: Customization of existing program
Num. of modules: 6
Description of every module: Hi, below I have listed out the macros that I require creating. I know how to write VBA, however, it isn't my core skill and would prefer to outsource this work as it would take myself considerably longer than someone else.
Please ask my any questions if interested in the job.
1. First macro should copy an input or formula all the way to the right of the spreadsheet and stop when it either reaches the final column or reaches another object in a cell.
2. Second macro needs to copy a paste a link to another sheet and in doing so also row anchor the link. Similar to what 'Alt+E+S+L' does however but without column anchoring also.
3. Third macro should format the selected cell a shade of yellow (255,255,105) and outline the cell box with a dotted line.
4. Fourth macro should format the date to the custom format of "dd-mmm-yy"
5. Fifth macro should format the selected cell with basic conditional formatting.
6. Sixth macro should row anchor any selected cells.
Description of requirements/functionality: All the mentioned VBA needs to be executed via keyboard shortcuts.
OS requirements: Windows
Extra notes:
Kind of development: Customization of existing program
Num. of modules: 6
Description of every module: Hi, below I have listed out the macros that I require creating. I know how to write VBA, however, it isn't my core skill and would prefer to outsource this work as it would take myself considerably longer than someone else.
Please ask my any questions if interested in the job.
1. First macro should copy an input or formula all the way to the right of the spreadsheet and stop when it either reaches the final column or reaches another object in a cell.
2. Second macro needs to copy a paste a link to another sheet and in doing so also row anchor the link. Similar to what 'Alt+E+S+L' does however but without column anchoring also.
3. Third macro should format the selected cell a shade of yellow (255,255,105) and outline the cell box with a dotted line.
4. Fourth macro should format the date to the custom format of "dd-mmm-yy"
5. Fifth macro should format the selected cell with basic conditional formatting.
6. Sixth macro should row anchor any selected cells.
Description of requirements/functionality: All the mentioned VBA needs to be executed via keyboard shortcuts.
OS requirements: Windows
Extra notes:
Matthew G.
100% (2)Projects Completed
4
Freelancers worked with
4
Projects awarded
29%
Last project
20 Jun 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
I have a few questions for clarification.
In 1, when you want to copy the cell contents to the final column, what exactly do you mean by "or reaches another object in a cell"?
Also in 1, if you copy a formula, do you need to adjust any cell references in the formula or is it to be copied absolutely?
In 2, where does the link come from? Is it going to be in the selected cell? How is the destination determined and is it the destination that is row anchored or the source?
In 5, what do you mean by "basic conditional formatting"?
115236
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies