formating content

Hello everyone, some time ago I created a code here with great help from DanteAmor which can extract the selected data from all sheets and create a summary from them (see "Summary" list). I would like to thank him once again for that. But since I will use this code for a few more years and I...

HI, so my issue is as follows. I have a master workbook in which I would like to track changes that were implemented in other workbooks in dofferent locations. The workbooks are all including the master saved in different locations on sharepoint. Now what I would like to track are changes in...

a few times a year I have to make some special signage up from three columns A1: Item B1: Number of Tickets to get Item C1: How many signs are needed so for example A1: Gadget B1: 100 Tickets C1: 3 Which I have to convert into A1: Gadget B1: 100 Tickets C1: Gadget D1: 100 Tickets E1: Gadget...

Hello in a cell I have this type of information created. ="If the sample size > 30 (in this example) "&D8&", we use a 2"&CHAR(10)&"tail Z-score of "&TEXT(ABS(I8);"###,##0")&" at a "&TEXT(G8;"0###,#00%")&" risk-level, which is "&TEXT(G8/2;"0###,#%")&" on either side of the tail." I like to...

I was wandering if the code below could be changed in a way where if the target had G4496-9809 it would still highlight. Also if it could highlight the entire row instead of just the one cell. Thanks Jamey Private Sub Worksheet_Change(ByVal Target As Range) If Target.Value = "G4496" Then...

Hi Experts, Is it possible to identify a seaprate line/vbnewline in a cell text. Example i have the following text in Cell A1: "I have a brown dog I also have a black car I have a nice watch" If i have the above text in the cell, then i would like to identify from where is the next...