Posts by MARADONA

  • Analysing Data separately with the need of a Macro / VBA

    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

  • 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 ?

  • VBA for copying Data in Sheets added by hyperlinks

    Hello


    Is it possible to have a VBA formula for my problem ? It can be also more VBA formulas to not overload the system. This formula will be used 59 times in the same Sheets but other Cells, it will always move to right hand side but not the Data taking in "Sheet 1" wich always remains the same position in "G3", "G4", "H4".


    In "Sheet 1", "A1" i copied data numbers of the internet and from that Data of "Sheet 1" i need to copy "G3", "G4", "H4" in the same order in "Sheet 2", "EZ3", "EZ4", "EZ5" with Font "Arial", Font size "16". Then I must copy Text (small phrase) from Internet in "Sheet 2" "EZ13" and Font must be "Arial", Font size "16" (i know it is possible to insert the Text in the VBA Module so i would prefer really that option). Then the "fill color" in "Sheet 2" "EZ13" should change color depending if the number in "Sheet 2" "FA3" is "+" or "-" so for " + " in RGB ( 0, 135, 60) or " - " in RGB (235, 15, 41) and the cell "Sheet 2" "EZ13" must be hyperlinked to "Sheet 3" "EZ14" and "Sheet 3" "EZ14" should have same colour, font and size as from "Sheet 2" "EZ13", then "Sheet 3" "EZ14" must be hyperlinked to "Sheet 2" "EZ13".



    Thank u all for your help wich is needed.