MS Excel VBA formatting dynamic cell range
- or -
Post a project like this283
$32
- Posted:
- Proposals: 6
- Remote
- #3950749
- Awarded
Excel Expert |WordPress| Google Sheets |VBA & Google App Script | Woocommerce
Jhelum
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
Rawalpindi
278297726277543151005387349139128939254611
Description
Experience Level: Entry
I have another project. i hope you have time FORMATTING only
1. It is a per sheet logic, sheet 1 and sheet 2 start and end of the cell might be different.
2. In this example, the Format is controlled by the cell format C7, example if the cell is level0 in the account hierarchy, bold, left justified, etc the same is copied to the right of the table, in the example from D7 to P7.
3. the program must update dynamically every time there is a refresh, no worry on the colors and formats from columns A:C since another program will determine that, we just focus on the complete format in the cell ranges controlled by Column C.
4. Continues row by row until the table end, meaning if C28 no format or blank cell then stops there.
5. The cell formats from columns A:C can change dynamically so any time there is a change in the C column range, then the rows to the right will adjust dynamically.
1. It is a per sheet logic, sheet 1 and sheet 2 start and end of the cell might be different.
2. In this example, the Format is controlled by the cell format C7, example if the cell is level0 in the account hierarchy, bold, left justified, etc the same is copied to the right of the table, in the example from D7 to P7.
3. the program must update dynamically every time there is a refresh, no worry on the colors and formats from columns A:C since another program will determine that, we just focus on the complete format in the cell ranges controlled by Column C.
4. Continues row by row until the table end, meaning if C28 no format or blank cell then stops there.
5. The cell formats from columns A:C can change dynamically so any time there is a change in the C column range, then the rows to the right will adjust dynamically.
Marco M.
100% (30)Projects Completed
14
Freelancers worked with
10
Projects awarded
42%
Last project
26 May 2023
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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