#excel

Hi there, I am having some trouble using the COUNTIFS function. I want to determine whether a certain combination of responses occurs in cell pairs. For example: = SUM(COUNTIFS('P2'!B7,{"Sometimes","Often","Always"}, 'P2'!C7,{"Sometimes","Often","Always"})) When I try the formula in full...

I need to use VBA to move the first 3 characters from column O to in front of the text in column K, so in the example below it should look like: J-7,4x8',Base,8"w,96" appreciate your help !

I have this code that add up all the "CHAIN & EYEBOLT" in a entire excel file, count the quantity, and add a row to the end of the excel file with the quantity. This code is used on thousands of excel files. Sometimes some of these files contain 0 eyebolt & chain, for these, I do not want an...

I need to change a group of values to value A, and another group of values to value B Below is what I have so far, and the code is not working. what am I doing wrong? Sub CleanUpOutlier() With Range("D1", Cells(Rows.Count, "D").End(3)) .Replace "F21222CJ-08"",F21222CJ-11"""...

I have a large number of excel files to clean up, any of the values contained in these arrays will be replaced by a different value Below is what I have so far, any help is greatly appreciated Sub CleanUpOutlier() Array1 = ("1", "2", "3", "4") Array2 = ("5", "6", "7", "8") With...

I have a few thousand excel files that need to be modified, one of the modifications is changing the value from Yes to No in column E based on value from column D. For example, if value in D is: F13345C, or F13355C, or F13365C, and if the value in E is Yes, this Yes will need to be changed to No...

I have a bunch of excel files that contain some values in column D Whenever there are values in this format, with a dash: F12314J-67" (yes with an inch mark at the very end), they need to be replaced with something like : F12314J I've been working on this for a while now and my code so far is...

I am using a record of an Excel Macro for a Goal Seek function on Excel. The problem is that when I try to add a new row in my sheet (both above the cells running the Goal Seek or even in the middle of them), the Macro that i recorded cannot be used anymore and I need to record it again (the...

The task is to extract data from the Source File (contains Multiple Source Sheets) based on the key word in the Dashboard column E and paste them into their respective Destination File and Destination Sheet. For Example: Extract data from the Source Sheet [ABC - Sheet Name] of the Source File...

Hello, I am using the following formula and trying to drag horizontally without just copying the reference to the current cell. I am not very familiar with the indirect formula but this could help save me hours worth of manual linking.. =INDIRECT("'"&B2&"'!c37") B2 is the tab name and C37 is...

Trying to create a code which checks if the dictionary value exists in each cell and if exists then keep that range in memory using Union argument. However, I am facing error with Set Rng = MyRng(i, 1) Else Set Rng = Union(Rng, MyRng(i, 1)) line. Can anyone please help me understand what am I...

I have a source file from where I want to extract data and paste them to their respective destination file. Criteria is country names present in Column E - Row12 (Headers in Row11), in Column F I have the destination file path and name where I want the code to paste data. Column E Column F...

I am looking to find out if there is a way to use excel formula to work out the cumulative number of working days a employee has been absent for when they work shift patterns So if the shift patterns are 4 on 4off, 2 days week one and 5 days week day two and the last shift pattern we have is 2...

Hello everyone, I'm trying to write VBA function to check if file with name that contains some string exists. Currently I have a code like that: Function FileExists(path As String) Dim fso_obj As Object Dim full_path As String Set fso_obj =...

-1 I want to transfer data from one cell only from excel to powerpoint using VBA.My current code only gives me an empty rectangle shape but there is no numbers inside. To further explain, I want to get the data from cell AC12 and then put this data as a statement on my powerpoint. As I am...

WE NEED SUMIFS FORMULA AS PER QUERY...... NOTE.: DIFFRENT-DIFFRENT SHEET IN PRODUCT POSITION IS CHANGE , HOW TO GET TOTAL QTY & RATE AS PER PRODUCTS

Hi, The below code first checks if the required file is open, if it is open then use that file; if not, then open file from the path provided in the cell and read/write with that file. After completing the task, It further checks if the file path & name provided in the below cell is same or...

Hi, Need some help on below:- There is 5 different folders containing many excel sheets and all are password protected. I created a sheet to pull certain data from files from all 5 folders (files are named date wise) Made a column with heading “date 1” and linked required data to populate from...

Hello Everyone, I am using Excel VBA to copy data from other sheets to the "Sales" sheet, which is working perfectly fine. now the thing is I have two-row sales and BOB for the sales columns, data is loading from 1st till the end of the month, which I need to remove from today till the end...