2016

Picture 1: Picture 2: Hi, How can i convert concated formula in (Picture 1) into real formula so that it can call the data and change according to the choosen month and year (Picture 2). I tried INDIRECT with the concated but got reference error. Any help is much appreciated. Thank you

I'm trying to write a macro that involves copying data from a pivot table into a separate table. I'm hoping to keep positive and negative values separate because I'll need to sub those negative values multiple times for the data to be accurate and the "Label Filter" option seems to be for...

Hello, I am new to VBA and I am trying to type a code that allows me when I click on a cell within range for example A1:A20 it will copy that cell to C1 Also, lets say i want to do this multiple times in the same sheet. For example I also want to click on a cell within another range for...

' To load work book based on cell value ' Real Estate Books Dim varCellvalueReal As String 'Filename:=Sheets("Sheet1").Range("A2").Value & "\" & Sheets("Sheet2").Range("A2").Value) varCellvalueReal = Workbook(Filename:=Sheets("Sheet7").Range("D3").Value) ' & "\" &...

Greetings, I have a macro workbook that was created in Excel 2016, however VBA was added to it in Excel 365. It works fine when opened using MS 365 however the users that will need the from/wb have 2016. When opened in 2016 I am receiving a !VALUE error in the cells that should be calculating...

Hello, I have a command button that, when pressed, will copy values(only) from certain cells on sheet1 and paste to certain columns on sheet2, but I'm having trouble with coding the macro. Data on sheet1 will change, but sheet2 is a log, so will need the macro to paste into next blank row in...

Hi Please I need some expert help I have 2 sheets Sheet1 and Sheet2 I need to copy the value of a cell in Column E and have it paste into a data filter in Sheet 2 cell A5 It then needs to copy whatever the returned value in column B and whatever the row is dependent on where the value was...

I have a macro I want to iron out... I need to copy/paste specific columns from one work sheet to another. I believe I have it to where when I run the macro, it will successfully copy/paste the columns. My problem is the way I wrote the macro, it only knows to do it between two certain...

Hi All, I need to make several hundred excel files which all have the same layout with different information (I.D. Cards). I have resolved all time consuming issues except manually changing the picture for each person. My idea is to write a macro and assign to a button that does the same thing...

Hi seniors, This is my second day of learning to use Data Query, PowerPivot and Slicers in excel 2016. I am trying to create an Excel Dashboard where the data is fetched from multiple excel files located in a particular folder path through a Query and then the connections are made and added to...

I have a code in my Excel sheet to upload multiple pictures from a scanner. In the 2003 version of Excel, I have a Macro for "Insert Picture from Scanner or Camera" function called "TWAIN" with the following code: Application.CommandBars.FindControl(ID:=1764).Execute With the changes in Excel...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #000000}</style>need a faster way to vlookup instead of having to manually scroll down all your data. on PC you can hit ctrl,shift,down and it will highlight all your columns to your last field with...

I've come across a problem I didn't know was possible and need some help disabling it. I originally created a Power Pivot table for my boss. At some point working with it he enabled the ability to edit the cells directly in the Pivot. He is not sure how or when it happened, it was later...

Hi, I have been looking in the forum if anyone have found a solution to the problem when using remove duplicates in Excel for Mac 2016 a popup window appears that doesn't allow the code to continue. I have spent some time looking for a workaround and it seems that issue hasn't been resolved...

Every time I need to create a pivot chart and I start customizing the colors on the filters, excel will inevitably crash and restart itself - sometimes offering a repaired version of my excel file. Most times it just reopens wherever i last saved any updates. Why is the chart customization...

I would so very much appreciate a solution as this has been driving me nuts for days! I have applied 12 conditional formatting rules in my sheet, all to the same range. Pretty basic, they are to colour the rows dependent on the project status code entered into column J. Problem is, when a new...

I have a conditional format in Excel 2016 set to shade cells that are formulas using the ISFORMULA() function. However, it also shades cells that include two manually input values added --- i.e. =1000+2000. That cell is still a value that will need to be input and, thus, NOT shaded. Any...

Dear All Excel MASTERS, HLEP! Let's say I have an excel file which have 2 sheets : "Inbox" and "Sent" in those sheets, there are 2 columns : "Name" and "SCORE" what I am trying to do, is to always get the nearest bigger "Score" (minimum value which is bigger) for any "Name" in the "Inbox"...

hi, in Cells T4:T6 i will enter numbers, in T7 I will be averaging those 3 numbers. =Average(t4:t6). I drag that formulas across 20 column. I get the DIV error in the columns that have not been filled yet. Despite my best efforts, I cannot make the error go away and say return a blank or a 0...

Hello. I apologize if this question has been asked. I tried to locate any threads pertaining to my issue but could not locate what I was looking for specifically, but I could have overlooked any that were posted. I have a locked worksheet with several unlocked cells. Some of the cells are...