Analysing Data separately with the need of a Macro / VBA

Hey

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 ?

Hello

Here are pics of my file i m working on, i wrote in caps not to shout but to make it easy to read, for me it helps a lot. Hope to get an answer....

How can i delete my Profil ?

hello

I m sorry for bad communication. so i will upload an example file, i think this can be done by answering here? The file is s complet excel file,right?

Again i feel bad for this mis communication of me, i do respect a lot forums and more there people who help to solve the problems.

I wish u a good day

Hello, how are you ?

I uploaded the file. Hope this comes to you !