problem

Hi All I am having a problem with a pivot table which I need help with please. From the data table below I want to get the bootom 5 values but exclude the blank cells from the cvount in the pivot table. The pivot table below shows them as 0 and includes them in the bottom 5. Data Table...

I am using the following code I found somewhere in a workbook to prevent traditional pasting to avoid wiping out cell formatting. I only want to allow paste values. Private Sub Workbook_SheetSelectionChange(ByVal sh As Object, ByVal Target As Range) If Sheet3.UnlockWorkbookCheckbox = False...

https://imgur.com/a/0AgdX6M This wasn't a problem but sometimes when I hit SHIFT + F9, my workbook freezes up, the fans on my computer start spinning fast and nothing really happens. This sheet for example, only has one row of formulas. The sheet of data that it is referencing only has 200...

Dear, I am new in Chandoo.or, and I need help. I wat to sum all data in a column with the same color, but the problem is that cells contain numbers and text. I'm trying to solve this problem but I'm stuck, please find the file in attachment. Please help me find some solutions. Thanks in advance...

I sometimes take screenshots on my 4K monitor and upload them to Imgur so I can embed them. Any ideas why they come out so large? It's not a problem on mrexcel.com. Even when I view them on Imgur.com, they look big there also. Example: They seem to be getting scaled up by a factor of 2.5.

Hi Whilst I have a get around solution to this problem I wondered how others may implement the problem. I want to refer to one of two named ranges in a formula using the RANK function in a cell. A value in another cell in the same row is used to determine which named range is used. How can...

Good Evening All, So I'm having a problem copying text from one workbook to another and keeping the source formatting. Normally a person can use PasteSpecial or xlpaste:= and this can be accomplished. I think that my code that copies things and then pastes is the problem as it does not allow...

Hi, I'm looking for the most efficient solution to this problem... I have a workbook with 30+ tabs that contains stock items, supplier codes and their prices (6 suppliers per tab). I trying to create a new workbook that mirrors the former (data and format) but without the prices. I've no...

excel problem definition has been described briefly in the below snapshot. https://www.dropbox.com/s/0v7duejb726laws/dear%20mumps.jpg?dl=0 Thanks & regards.

Hey Excel Ekspert's on my userform1 i have 8 Label's there Are taking Data from 8 Different's Cell's my Problem is that the Label NOT is Opdating Automatik only when i Click On the Specific Label i Might see the Problem in the Startline of my Code "Private Sub Label71_Click()" But i don't know...

i want get data from web site with following code: <tbody> range day 11,670 11,300 price 12,191 11,031 week range 11,739 11,060 year range 11,948 3,999 </tbody> <tbody> sharing 20 B base volume 894,454 floating 17% vol ave month 9.059 M </tbody> i want to export...

find lost thread. instructions not clear

Hi all Currently i encounter with a problem just as the title I have a program writing in excel vba and interact with 1 access data base. It allow user to input their data from excel user form to access. And some simple query to extract the collected data. Total user connect to database is about...

I have a formula worked out for financial auto loans but the only problem is I need it to cap out @ $900. I currently have a table set up where users enter the income (b22), rent (b23), monthly credit card debts (b24) and monthly insolvency debts (if any) (C32). It checks to see that it doesnt...

Hello dear forum users, Im making a application where i have couple of listboxes on a form. The problem is that my code is repeating too much so im trying to avoid this repetitive code. for i = 1 to listbox.ListCount...... boilerplate code to find selected index So i decided to make a...

I deal with equations that are drafted in microsoft word that look like this: (1.0 x 0.03125 x 0.20 x 187.4237/1920.00) If I independently put an = sign in front of (1.0 it will turn it into a formula after asking to correct for typo for x to become * The problem is I have hundreds of these...

Hello everyone, I am having a hard time figuring out how to deal with a too zealous characteristic of Excel… I am programming a macro that is basically just an advanced insertion : instead of just copying and inserting a range of cells, I want to allow the user to modify a certain number of...

Hello, i was looking for some help in completing this excel doc. I have been given information in a table that must match each category but the problem i keep running into is that the names don't match the columns. As such, i have run into a problem and was wondering if the community could help...

Hi All, I am having issues with loops in VBA, I am convinced it should work but doesn't & I have no clue why! Sub SiteReports() Dim T As Integer Dim fldr As FileDialog Dim sItem As String Application.ScreenUpdating = False Set fldr = Application.FileDialog(msoFileDialogFolderPicker)...

Hi guys, sorry for the poorly worded title. I have a unique problem which I am stuck with... Let me try to describe it here and in addition, attach a worked example. I am working with a quarterly model, however have a a criteria/tranche which is based on yearly/cumulative spend. Criteria...