running

Hi everyone, I'm struggling to distribute the Duration in column B over the correct period with a formula, in order to translate the table above indicating when a new project starts into the table below which sums up the current running projects. For example, Project 1 has a duration of 2...

Hi Team, Very 1st query about power bi. I place data in power bi. okk.. Now, column B are unique id's. So in column values i placed that. and using slicers im observing chart. problem is when I did this Pareto chart in excel, I got an option "running % total in" and i was getting running % in...

I'm running a large macro that reformats a data dump from an accounting system. It sorts several times and subtotals. During the running of the macro, I get an "error" message that Excel cannot determine the column header row. I have been hitting ENTER ("OK") and the macro moves on until the...

Hi, I am running a MACRO in sheet2 by clicking on a bottom on sheet1, all of my code is working very well, except here: .Columns("H2:I20000").SpecialCells(xlCellTypeBlanks).Select .Selection.FormulaR1C1 = "=R[-1]C" What i am trying to do here is to tell excel to go to Find & Select >...

Hello, I'm trying to make a table or chart which can show how much a person's running time will change with different weights of footwear. Ideally, I'd like to be able to enter a theoretical weight (in g or kg) and come up with a time in mm:ss or even just straight seconds. An example: A...

hi, bit of background. I'm trying to create a statistics excel sheet for my appallingly bad golf short game. I'm recording the distance to the flag for each putt using my stride length as the standard unit of measurement. anyway I have formula In place that calculate the running total of all...

Hello all - I am a bit stick here, and could use a little push in the right direction, please: Column A has numeric data Column B has a running total of the data in A (and there are a number of other columns…) I have a line chart that depicts the curve of Column B, ie, a line chart of the...

hi all, I need a macro for removing everything after second last space from a string. example data is provided below. My name is khan. this is not an obvious mistake. could you please come here after running macro it should be like: My name this is not an could you please Please not that...

Hey guys I have another problem if you could please help me, thank you. I have this setup: I want to display 1 in column M for the first item that has the condition Yes, column K is a drop down with Yes and No. I don't know how to stop the second formula to run if the first one is...

I have an Excel application written in Excel 2010 64 Bit. Everything has run fine for months but I needed to add a Chdir command and ran into a problem. I added in a Private Declare PtrSafe Function SetCurrentDirectoryA Lib "kernel32" (ByVal lpPathName As String) As Long to my code and...

Hello everyone I am new to this group as well as working on excel marcos. I have made spread sheet where there are two equations (Q1=m1*c*dT and Q2=m2*c*dT) that needs to be balanced (Q1 =Q2) to get such a value of m1 (that utlimately L coming from m1 is same for both m1 and m2). I have made...

I have an office inventory spreadsheet and the following is what I would like to do: Get a running total for quantity even if I sort any column the running total should not break Get Running total sorted by item and should reset when the item name changes Get running total (for visible rows...

Hi All, I have recorded quite a lengthy macro that takes a few minutes to run. Whilst running I get the normal flickering from sheet to sheet. Is there a code I can add into my macro that will make it stay on the 1st sheet and display some text saying that the macro is running. Also when...

Good Day, Below code is running at userform but on worksheet module its not running... What would be the reason. I simply put on worksheet 2 combo and 1 listbox Is there anything that I need to add? Private Sub CommandButton1_Click() Dim r As Long, Ac As Long, c As Long If ComboBox1.Value...

Each of my inventory items has an individual number and I use that number to auto populate an item and its price. I would like to be able to search the worksheet for any instance of an item number showing in Column A, then pull the related item numbers in Column C (Qty received), Column D (Qty...

I've just finished creating my VBA spreadsheet and while it's very useful and 'a bit of a beast' it's not so impressive to look at while running. I played around with turning screenupdating on and off and either way doesn't make much difference so was just wondering if anyone had any tips on...

Hi, We have a huge problem with running macros in Excel 2010 on Windows 10. In macro settings we marked option "Disable all macros except digitally signed macros". We are using Certificate for Digital Signature and because of that we want to run just digitaly signed macros. I setup all...

I am trying to make a sheet that has a column with a running total. However if nothing has changed from the previous day meaning the total is still the same as the previous day I would like to not add anything to the total but if possible still display the current total in that cell.

Hi, I am running a macro in one workbook. I want to open and work on another excel workbook. Is this possible? Excel 2016 Thanks

I am using PowerPivot Excel 2016 data cleaned in PQ The data is formatted like this Item Name Item 1 Start Item 1 Running Item 2 Start Item 2 Running Widget 1 15 1.15 12 1.63 Widget 2 9 .79...