Hello, After I paste copy text from (notepad/browser...etc) and paste into a cell in Excel 2021, I notice the [Wrap Text] button will be automatic pressed down by Excel 2021. (as seen in screenshot 1) I do not want the [Wrap Text] button to be pressed regardless of anything I do to a cell. I want it to look like screenshot 2 permanently I want the Wrap Text button to be unpressed permanently regardless of anything I do to all cells in Excel 2021, how to do it? (if i want to read the contents of the cell i would click on the cell to read the contents displayed on the top (just below ribbon ..read more

Tough to respond without seeing your data. Suggest you post a sample of your data and the pivot table that is derived. Then explain what is missing and mock up what the solution should look like. Your current explanation is too vague to even venture a guess ..read more

How are your Batch and Qty values filled in ? Manually one cell at a time or by some other means ..read more

Hello, I would like a vba code that does the following if possible: On the "Book1" workbook, I need it to find and match with the corresponding file number on TT Recoding Test Sheet (MD), then check what county that file is in and if it's been "recorded" there before post "Yes" to that same county for all file numbers in Book 1. Also a code that automatically formats Col A on TT Recording Test(MD) to hyperlink so if possible if someone clicks on one file number on that workbook it automatically takes them to the corresponding row in Book 1. Ex: 824008 was "recorded"(Col K) in Maricopa county ..read more

Accessing your worksheet multiple times makes the process slow and inefficient, it is much better to use a matrix method. Dim a, i& a = [a1:a10000] For i = 1 To UBound(a) ' Perform operations Next i ..read more

You overwrite the last row with these lines: Code .Range("AD" & RepRow + LastExpRow - 1).Value = "TOTAL EXPENSES" .Range("AE" & RepRow + LastExpRow - 1).Value = "=Sum(AE" & RepRow + 2 & ":AE" & RepRow + LastExpRow - 2 & ..read more

Adapting the code you found to what you describe needing will not in itself cause Excel to crash. How is the value in F127 arrived at after the selection from the E4 drop-down ? My suspicion is that the Worksheet_Change event might be used to fill F127 Right click on the sheet1 tab then View code do you see any subs there ..read more

Goodnight I come here to ask for help. I intend that, when placing the data from cell C7 to cell E241, then by the number of times its name appears in Cell C7 to C241, it will be placed in descending order in cells M7 to M241. I also want the number of times won to be entered in cell N7 to N241. I want the money you won to be added up in cells O7 to O241. I want cells L7 to O241 to be protected Here are some details of what I want. If you have any questions, please ask, as it may not be as clear as I intend. Thanks Best Regards ..read more

You're welcome ..read more

I have 2 sub routines & want to combine them into 1 sub routine. It can be done with goto statements & nests loops but i am unable to do it. Code perform family tree & align family members in order. Code have 2 sub routines demo & getchild. My requirement is that both sub routines merged into single sub routine but i am unable to do it. Kindly help in this regard dear community Code is given below. In the attachment, question is data given & answere is how data should be sorted. Sub Demo() Set nws = Worksheets("newsheet") Dim i As Long, j As Long, objDic As Object Dim arrDa ..read more