strike

Hi All I would like to create a macro where i can paste Columns of Option, Strike and Expiry in respective sheets(sheet name is on left). I have written a macro. please advice the necessary changes <tbody> SheetNAme Option Strike Expiry NIkit c 11200 27-Jun-19 sandeep P 11300 27-Jun-19...

Hi All I would like to create a macro where i can paste Columns of Option, Strike and Expiry in respective sheets on the left. I have written a macro. please advice the necessary changes <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Sheet1 Option Strike...

My spreadsheet has rows that have strikethroughs for the formatting. I need t do some sort of macro or formula that says something like, if the formatting in A1 is strike through, place an "X" in column Z. How can I accomplish this? Thank You!

Hi Team, Below is the table <colgroup><col style="mso-width-source:userset;mso-width-alt:3693; width:76pt" width="101" span="3"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt"...

Does anyone know if this is possible? The Forecast Sheet function is very picky when it comes to only using valid data- in this case timeline MUST be in date format. This is bad news bears for pivots because if you group dates it converts them to text (strike out with Forecast) and if you...

Good Evening! I am working on a spreadsheet that links data from Thomson ONE. I've gotten pretty far on my own, but I am struggling with the last piece. For reference, I'm making a portfolio statement that can be easily changed if we end up buying or selling an investment. Trying to create a...

Good morning. I am expecting the answer to this question to be no based my current knowledge but someone her may have better advise. I want to do an concatenate with an if. something that looks at a2 to see if the font is "strike thorough" and if it is then don't include in the concatenate...