running

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...