I tried non stop for hours/days/weeks to handcraft a VBA / Macro for my project, there a lot of useful help on the internet and spend many hours on searching solutions for my project but VBA / Macro is so sensitive to a mistake that it will not work, plus i have not done any courses on VBA, i would just need a working VBA / Macro once in my life for my project. I found examples for certain steps but i m missing steps, i can t find them in Forums or internet, also i have found no guides how to simple add Macro steps found in forums in one single VBA to get all my steps done in one VBA wich is me requirement. I m using EXCEL Mac version 16.57. So i try my chance in the forums as my laste option, i thought it would be easy and get it done fast, but nope.. I had a lot of fun and nice findings on my way, VBA / Macro is so a creative tool, a good gadget ! My Macro that i m searching must do all this steps in one go if possible, it would safe me a lot of time.
So, Macro should copy Sheet 1 G3, G4 and H4 into Sheet 2 EZ3, EZ4 and EZ5, the next step would be Macro must fill text in Sheet 2 EZ13, font arial size 16 I know how to do both steps with one Macro Record, i would need help for the upcoming steps, next step Macro must change color for Sheet 2 EZ13 depending if the number in sheet 2 EZ3 is above zero to RGB ( 0, 135, 60) or below zero to RGB (235, 15, 41), this case red, this step i found no help in any of my searches and it is not possible to record this Macro with Macro records, next step Macro must hyperlink Sheet 2 EZ13 to Sheet 3 EZ13. Then, Macro must fill in Sheet 3 EZ13 the same text, colour, font arial and font size 16 as from Sheet 2 EZ13, then Macro must hyperlink sheet 3 EZ13 to sheet 2 EZ13, there i could use on Macro Record the function copy / paste and the hyperlink. I know how to do that with Macro Record but don t know how to add it and make it work with previous steps plus i m missing one complete step
Is there hope for me, can u guys give me some aid,, please ?