running

  1. L

    DAX: Running Total on Non-Date Column

    I have a data model pivot table with a column named "2019 Actual" which shows sales amount. The column resides on the "CombinedAllYears" table. I don't technically have dates (4/1/2019, 4/2/2019, etc) in the table, just month names "Jan", "Feb" etc. I also have a "Store" slicer and want the...
  2. C

    Running VBA code from Access database recordset

    I'm running a project right now that has grown beyond what it was ever intended too. This is an Excel VBA application used within a single dept. Every user should be opening the file from a single location and always be running the latest version, this however isn't happening. What I'm...
  3. zuriqi

    % of row total of the running total in pivot table

    Hi Is it possible to do the following in pivot table? Do running total % of row total based on the values of the running total in point 1 <tbody> A B Total 1 2 3 3 3 6 4 1 5 </tbody> Running total <tbody> A B Total 1 2 3 4 5 9 8 6 14 </tbody> % of row total <tbody> A B...
  4. C

    Running Total Distinct Count

    I have a table I am working with that has project names that are listed multiple times (along with a bunch of other data that should not be relevant here). This is in Power Query What I want to do is a running total of how many times the project name appears then start the count over when a new...
  5. N

    Conditional Formatting Issue

    I am having 2 issue with my conditional format formula. I am trying to work out a formula that allows me to detect new entries daily. So what if i put an entry in today tomorrow it would be gone until a new entry was made that day. Below is what i have already but it seems to be constant...
  6. D

    Running more than 1 excel

    Hi All, is it possible to have 2 excels working at the same time (same versions)? i need to run reports first thing in the morning via macros, which takes about 5min to run. while the macro is running, i cant do anything with excel. is there a way that i can run my macro although still use...
  7. T

    Scope and lifetime of variables

    My understanding of a variable's lifetime is that if it is declared at the module level, it retains its vaue, even after the sub has finished running. So in my following code, after first running Test1 to the end, if I run Test2, the messagebox shows the value of 10, as expected. Dim a As...
  8. S

    Question regarding running Excel VBA from Access

    I have not much experience in connecting Access and Excel but just wondering if someone has knowledge of running an Excel Code from Access? What I like to achive is that I can importing an Excel worksheet into Access but modify it first in excel. And like to achive all of that straigth out of...
  9. S

    running numbers in pivot table's row

    i created a pivot table as below. in my table i want to running serial number of every row as sequence wise. Date: 00-00-0000 (report filter) ROW NAME LCB CB VCB LMDF 1 ABC 10 05 15 20 2 DEF 09 12 21 10 3 GHI 15...
  10. W

    Formula Needed for a Running Total, Based on 2 Specific Cells Content

    I have 3 columns I want to work with. B3 - is a starting total. C3 – is an addition column (If I put money in) D3 – is a subtraction column (if I take money out) F3 – Is the column I want to hold the running total – I want it to look at C3 and D3, and determine whether to add or subtract from F3...
  11. B

    Help with an if error on excel vba

    hi i have this piece of code in my excel macro. ActiveSheet.Shapes.Range(Array("Picture 2")).Select The problem i'm having is that sometimes depending on the sheet that i'm running the code on it can be "image1.png etc.. how can i modify this line that if it errors out it will select...
  12. G

    PowerPivot can't complete import

    Hi, would appreciate any help on this... I have a PowerPivot which imports 1,988,837 rows from an external connection, it gets to 1,980,000 but doesn't complete. I'm running 64bit Excel with 16GB RAM, Task manager shows RAM and Disk use near 100%. Is there a way to import the Rows before it...
  13. D

    update to 64 bit

    Good afternoon, I have an old code running under 32 bit. But now my computer was updated to 64 bit. When running the following code, I got a message to ask to update the code to 64 bit and mark them with PtrSafe attribute. How can I change it? Sincerely. DL [/'Private Declare Function...
  14. A

    VBA: Code execution

    Dear All, Greeting for the Day! I have a query in VBA, I have written the code successfully and macro running properly from backend i.e VBA Editor. But when I'm running the code from excel the automation is not giving me the complete output. Need your expertise in this to understand why it...
  15. M

    Excel VBA for unhiding rows in logical order

    I have code for Hiding and Unhiding rows in Excel sheet. Current problem is: 1) Running twice NewUnhideJobs (position of second section) 2) Running once HideAllJobs 3) Running NewUnhideJobs As the result we have position of third section and not first as it should be. So NewUnhideJobs does...
  16. P

    Do Loop running slow

    Hi all I wrote this simple code but it is taking a long time to run. Is there a faster running macro? Range("BA9").Select Do ActiveCell.Select If ActiveCell.HasFormula Then ActiveCell.Select Selection.Copy ActiveCell.Offset(0, -48).Select ActiveSheet.Paste...
  17. rjplante

    Shut off a specific macro

    I have a Private Sub macro that runs upon worksheet change. I have another macro that is trying to enter a new row of data to the bottom of the list. Whenever this macro runs, the on change macro interrupts the operation and I believe is what is causing the problem with my main macro from fully...
  18. hicksi

    Running a Subroutine on Open ABNORMALLY

    I have Excel as my data with a set of forms (ie, a system utilising Excel - because I CANNOT use C# or VB# due to company policy). Usually it starts and displays the main form... NO PROBLEM It also contains code-save & sheet-save subroutines. I want to run those (without running the forms). Is...
  19. C

    Giving Cells Sequential Reference Values

    Hi all. In my mind, I imagine a table with two columns... column A with a list of names, column B with a unique reference to identify how many times that name has appeared. Rather than summing the total number of times the name has appeared, I'd like a running total rather like the below: NAME...
  20. T

    Lifetime and Scope of variables

    I am a bit confused with regard to the Lifetime and Scope of variables. Given this code: Option Explicit Dim a As Integer Sub FromSheet1() Sheet3.Select a = 1 End Sub Sub FromSheet2() Sheet3.Select a = 2 End Sub Sub GoBack() If a...

Some videos you may like

This Week's Hot Topics

Top