excel2016

I have a macro/vba codes written, which is running smoothly although probably slower than the usual. The problem is >It crashes when i saveas the file with a different name and open a new empty workbook. I ran the macro line by line/ step by step and it is when saving the file that it...

I have a form where information is being from a form is being added to a sheet "Database". How can I add to the current VBA and have the the same information added to the "Database" sheet on the Active workbook and another workbook "WF Manager-Database.xlsm Sheet "Activity Database". Code below...

While editing, Excel restored the workbook and I lost all changes. Since Excel did not crash there was no recover file to retrieve the data. Has anyone seen this unexpected event before? This had never happened before while working with Excel for a long time and seemed to just start like some...

Hello All. I've recently come across the power query feature in excel 2016 where in i got to know that i can extract data from multiple workbooks in a folder with actually having to open all those workbooks. Now my question is, not sure whether it's possible or not, Can power query be used to...

Hello guys I'm trying to do a pivot table using VBA alongside multiple other things, however I'm trying to filter the pivot table using the VBA to have account_number to be equal to 123456, I've done this code, however I don't know how to add the extra line to filter as mentioned above. Set...

Hello Gurus, Hope all is well. Could you possibly help be on how to code this? 1. In Sheet1, I need to highlight in yellow the text containing "Target" in column AZ. 2. Separate the data with "Target" text by adding a blank column 3. Add message box noting how many "Target" text are there...

Can someone help me please. As you can see in cells B17 and C17 I have a size with a ± value of 0.30 and column D is for the lowest size(110.50 - 0.30) and Column E is for the highest size(110.50 + 0.30). The formula that I am using works perfectly but that is only if there is ± but sometimes...

Hi all, I have an excel file with two sheets 'Data' , 'Template' The 'Data' sheet has data in cells A4:AA6608. In column C, I have sorted the names of companies (but they are not unique). Moreover, I have a 'Template' sheet with header in A1:AA1 I have a button in 'Data' sheet and I want to...

Hello ppl! I googled my problem before posting but couldn't find anything helpful so i decided to ask here. Is there an option to remember the last thing i copied and paste it after doing several actions in between ? For example > I have to copy some text and paste in one cell, than i change...

Hi all, I am using Excel 2016 and want to update a "Box and Whisker" chart with new "Source Data" in a dynamic range. One workaround is to delete "Chart 1" and create a new "Box and Whisker" chart but how to update existing chart? I have tried below code and others but I can't get it to work...

Sorry if this is in the wrong location, this is the first time I am posting on this forum. My issue is a regarding a "Compile Error: Method or data member not found" that happens when an excel file is opened by some users. These users have either excel 2013 or 2016 installed. The compile error...

Novice in need of guidance! I run a macro that copies all cells with unique text from a separate work sheet and pastes them in the first column of a table. As this table has a load of formulas worked out using this column as a reference, I want the table to automatically extend to include the...

Hello, I have built a sales report dashboard which is to be updated monthly with around 2000 rows of input. The data I input has the following categories/columns: Date | Sales rep | Product | Quantity | Value | Product category | Brand. Sadly, the company's software does not export the...

Hello, everyone, I have a pivot table displaying the total sales of three brands in two columns (one as currency, the other as % of total). The currency column's numbers are formatted as currency, with thousands separator, two decimal places and "лв." after each number. For each of the three...

Hi, I have twoexcel documents, "Book1" and "Book2". Book1 is exportedfrom our business system. Book2 is a compilation of forecast from the businesssystem data that were exported. Today Ihave to manually put in the data from Book1 to Book2. I want to automate thatprocess. In Book2 Ihave...

I'm new to much of this, so please bear with me. . . I'm trying create a count of active projects by week using projects' start and end dates. I've created a COUNTIFS formula in an Excel worksheet table that works, but I would prefer the calculated column reside in my Data Model/PowerPivot...

I created an addin that works fine. I wrote a bunch of code and assigned them to buttons. But I would like to add some buttons using built in functions like Add Row, Delete Row, Hide Row. How do I refer to these built in commands? Here is a line of my XML code: <tbody> <button...

I have a small vba code to copy data to another sheet - (data from SampleSheet1 {range(B17:W*) *is obtained from cell AA17} to SampleSheet2 {range(no change from last selected)} Dim Cval As Variant Dim Rng1 As Range Worksheets("SampleSheet1").Activate Cval =...

Hi! As shown in the picture, I am comparing year end sales numbers (in millions) with stores numbers. Since Sales are in millions, the bar graph displays store numbers are more than sales. How can I display it so that it is easy to compare visually?

Hi, while I'm new to this forum, I'd call myself pretty advanced when it comes to Excel. But since some days I have a problem with Pivot Tables. I'm working with Excel 2016. When I try to change the source of a Pivot Table from one sheet to another, Excel just doesn't do it. It either keeps...