excel2013

Hi, I have the below code that is working for most of my users but is crashing in the red line for some of the users. The only common trend I've found for those that this is not working is that they are Excel 2013 users as everyone else is Excel 2010. The Excel 2013 users have a run-time error...

Hey All, I have the following code in one of my Excel files. Using it to automatically filter team based on what is selected on the home screen. There are various charts which are then processed based on the filter selection. Private Sub Worksheet_SelectionChange(ByVal Target As Range)...

Hello, I have code that uses a command button on my spreadsheet to hide rows that contain the text 'Complete' in column AX. When the command button is pressed again, it will unhide the rows. This works. The other code is used to color rows in my data range based on when the value in column J...

Hello, I'm using Excel 2013 and modified some code to help me filter a certain column, 7th column (the hub name), copy that filtered data, paste that to a new workbook, save it by the hub name being filtered, and format the new workbook. The code works. I'm just wondering why, however, I had...

I have data and need to check Date and Time. then check in list if i get this Data "6/21/2016 11:50 5I" i check 1 in "6/22/2016" Below pic i use sumproduct check time and date and before 11:00 or check time and date-1 and after 11:00 Sorry about my English have other way to calculate...

I have a workbook that I use to keep track of volunteers. One sheet per month, along with a totals sheet. I use the formula =SUMPRODUCT((B7:B150<>"")/COUNTIF(B7:B150,B7:B150&"")) to count the number of unduplicated volunteers per month, but I need to count the number of unduplicated volunteers...

Hi. Glad to be apart of the community even if for a short period :D So, my problem... I want to get the weeknumber from a date in a cell using an excel macro. I have this code right now, but I keep getting a compiler error If...

Hi, I have created a Pivot Table which used Sheet3 in the same file as Data Source ('Sheet3'!$A:$E). The file is created in Microsoft Excel 2013. Everything is fine when I save the file, and open it from saved file. But as soon as I try to move the file elsewhere or rename it or send it to my...

Hey guys, I have created a dashboard with multiple pivot tables, slicers and timelines. I have been able to fix it so the slicer connections will allow me to drill down into the data, but I cannot get the timeline function to do so. For example: when i use all the slicers and timeline for 4th...

hi everyone ! i need help on the codes that can be used for the project im doing now :( im new to excel and im tasked for this challenging project. i sucks at it so please help :( for example : i have 2 tables. table A and table B table A stores the years, category ( apple or orange) , the...

I'm finding it really difficult to understand how to prefix or suffix a set of words based on a what I have chosen in a 'Data Validation List'. CLICK HERE TO SEE/DOWNLOAD AN EXAMPLE SPREADSHEET I have a list of words in column A and a list of words in column B. In Cell C1 i have a data...

hello. can someone please advice me something regarding the slicers in excel 2013? i have a slicer that shows the years in my data. its 2011 - 2015, which the slicer is programmed to. and im asked if theres a way to only show the year 2012 - 2016 for next year, if i happen to add 2016 data in...

hello! please help! how to generate textbox on button click? i got this code : ActiveSheet.Shapes.AddLabel(msoTextOrientationHorizontal, 2800, 900, 100, 30).Select it works but its a plain box without background colour or border. i need a coloured textbox on button click in excel. please help...

Hi All, Hope you are all well. I have made an email reporting tool and I am really struggling with this. Each row has an ID number (starting from 1 and on row 2 in Column G). When a reply comes in I need the reply to have its original ID. Tried using entryid but this value changes when a reply...

I have created some code that will move emails to a folder, add a unique ID, put into a spreadsheet and not overwrite duplicates. This worked when I made it and now it comes up with Run Time Error 70 Permission Denied. Been looking through the code and cant figure out where or why this is...

I am having problems with the code listed below. I'm trying to use indexmatch with another workbook to get the values and save the value as cell values . But it returns a value of #N/A. I want a to save it as paste cell value only and not formula :mad: Can anyone suggest a solution? or...

I want to create a macro that can help me find for an empty cell and then use some conditions 'Find the cell that is empty.a If cell is empty , call the vlookup function method else display "Not indicated" how do i do it ? Thanks and appreciated your help . -NewUserinMacro

Hey All . . . I have used this code before, grabbed it from here (good stuff if you use SSRS):Chintak's Blog - Refreshable SSRS reports in Excel - Chintak Chhapia , and it has always worked swimmingly. I have another use case that requires this trick, but I am repeatedly getting a paste error...

Hi, I wonder whether someone may be able to help me please. I'm running a small script which assigns a shortcut key to a command button whilst to run a specific macro. Could someone possibly tell me please is there way by which I can underline the letter on the command button to show the...

kindly please help, How to round off all the values in a single column into three decimal places where the last three digit is end up with 0.000999 ( for example : 8.816999, 8.823999) without changing any closest data ? **as shown in table below <tbody> 8.743989 8.750991 8.717999...