excel

I have a list of countries expressed in percentages of a universe Universe = 100% , individual countries as follows Japan 6% China 2.60% Korea 1.20% India 2% HK 0.60% SingaporE 0.30% Taiwan 1.70% Total 14% How do I rebase those countries to 100% in Excel...

Hello . . . I have a very simple piece of VBA (below) that works perfectly well copying a line and inserting it below itself, as intended. However this doesn't work when a filter is applied. Can anyone kindly suggest a fix? Sub WLM_Insert_A_New_Line() ActiveCell.EntireRow.Select...

Yea, I have no idea where to start. I have been all over google trying to figure out the structure. I have a VBA that i need to put into a script inorder to use it in AppSheet. Can you point me in the right direction? Sub ResetWeekly() End Sub Sub ClearOldDates() 'Declare variables Dim rng As...

I have this code that creates a copy of my excel sheet and puts it an email in outlook. this works perfectly. However, I run a filter with a change event once a loan officer is chosen in cell and I would like to modify my macro to strip out all the other data so the user that receives the...

Hi, I have the following formulas that returns the most repeated text in a range that ignores blanks as well but I need to adjust it to only test the visible cells as the data is filtered, can someone help me? I am not sure which is better but both seem to work, can you help me choose the best...

I have code that executes an autofilter to show data based on the value in cell d6. However, when the user hits the delete key the autofilter shows now data. If the user hits delete on d6 I would like to make the value of the cell 0. Is this possible? Code when there is a change: Private Sub...

Having trouble with latest date code for pivot table vba code. Trying to streamline our process of entering equipment hours and I started getting into vba since it seems like it's the way to go, I found some code that should do this but I can't get it working in my particular instance. Listed...

Hi, I’ve started to work on a product that will have a deep integration with Excel with the following requirements. Installation: A one-time installation of the Add-on across all Excel files on a user's machine. Tracking: The Add-on should adeptly track all user interactions within the...

Hola, tengo una tabla donde tengo las 52 semanas del año en curso de la columna de la columna I para la primer semana hasta la columna BH para la semana 52, quiero contar los datos por meses, se que puedo usar COUNTIFS para contar cada columna pero quiero que automaticamente me cambie...

I have been converting older spreadsheets to spilled arrays to improve and simplify logic. However, there is one area I cannot convert to a spilled array without the dreaded circular reference! Below is a simplified version of a table where costs are recovered from reveneue before the profit is...

I am working on an Excel form to allow users to submit data about decisions made and topics covered in meetings as part of a larger project. I will have a lot of different people entering data in this Excel file, so I want to lock as many cells as I can to make sure things aren't accidentally...

Hello, Hoping someone can assist me with this excel question. I would like to create List3 as it looks. If the color in List2 is in List1, then I want it to show up in List3. The part I am stuck on is getting List3 to pull green to the first row,, blue to the second row, and so on. Appreciate...

Hi, I have a vba code that needs to copy an array of sheets from one workbook & paste as values to another workbook & save the destination workbook as either xlsx or xlsx. Below is the code: Sub SaveSheetsAsCSV() Dim ws As Worksheet, ws1 As Worksheet Dim newWorkbook As Workbook...

Hello, I've added a macro that creates a PDF based on specific cell references. It works as intended, but I would like to make it a little easier for users. I have two questions: (1) Is it possible to have the file name already pre-populated to the SaveAsDialog box based on specific cell...

I need to copy the ActiveCell.Address to a string variable to test if a cell is in a range for the Intersect function. I would be very grateful to anyone who could resolve this problem for me. I would also be grateful for any suggestions or comments on the other code in this macro. My thanks...

How would you trim the number from the street address? As you will see below the number and following street address are both variable length. The problem is when the "number" is variable length. Let's look at two scenarios... Thanks in Advance - Dan Address Desired Result 123 Main Street...

Hi! I'm looking for some help in grouping sets of data for when a filter is applied. Example below: Says below is the original set of data - I would like to be able to filter by tests that have "failed". Is it possible to keep all of Test number 2 & 4 showing when I filter for "fail"...

My new csv looks like the second table which is just a little sample. However, I would like it to look like this: Element Component Attribute Repair Unit T1_SORCost T1_SORLifeCycle T1_AssetGroups Adaptations Adapted Passenger lift Adaptated Passenger Lift Present House, Flat...

Hello, I have a progress bar to show the status of a project but I want some of the data will be excluded from the progression I used a drop-down to show "Done, Pending, and Not Available". Below is the image for better understanding and reference. Progress Bar: Status: What I wish is, I...

I am trying to do an array multiplication, multiply each of the months with the corresponding numbers from the 'Array' below, for example for "Person 1" do 0.1*150, then 0.2*250 and so on. As you can see it is returning #VALUE. Even if I try multiplying as an array, or multiply the numbers one...