BrianD
02-05-2022, 09:20 AM
Hey
I tried for hours/days/weeks/weekends to handcraft a VBA / Macro for my project, spend many hours on searching forums for answers
but VBA / Macro is so sensitive to a mistake that it will not work at all, plus i have no VBA skills :(. I m using EXCEL version 16.57 for MAC from Microsoft 365. My Goal is to reach one Macro for my steps, if that is possible
So, Macro should copy cells in Sheet 1 G3, G4, H4 to 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 step, 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 with Macro Records, then next step Macro must hyperlink Sheet 2 EZ13 to Sheet 3 EZ13, then next step Macro must fill in Sheet 3 EZ13 with the same text, colour, font arial and font size 16 as from Sheet 2 EZ13, then next step 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 help please ?
I tried for hours/days/weeks/weekends to handcraft a VBA / Macro for my project, spend many hours on searching forums for answers
but VBA / Macro is so sensitive to a mistake that it will not work at all, plus i have no VBA skills :(. I m using EXCEL version 16.57 for MAC from Microsoft 365. My Goal is to reach one Macro for my steps, if that is possible
So, Macro should copy cells in Sheet 1 G3, G4, H4 to 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 step, 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 with Macro Records, then next step Macro must hyperlink Sheet 2 EZ13 to Sheet 3 EZ13, then next step Macro must fill in Sheet 3 EZ13 with the same text, colour, font arial and font size 16 as from Sheet 2 EZ13, then next step 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 help please ?