vba excel

Dear all, I have written the following code: Workbook_SheetCalculate(ByVal Sh As Worksheet) Dim myRange As Range Dim product As Double Dim n As Long Set myRange = Sh.Range("N1:N50,AA1:AA50,AN1:AN50,BA1:BA50,BN1:BN50,CA1:CA50")...

Dear All, I would like to get some feedback how to write my desired module. ]I have a file in which column "O2:O50" is changing as new data is collected from an external source (Bloomberg). The same applies for "AD2:AD50" and "AS2:AS50". Now I would like to get a message if one of the values...

Hi, I have a macro that generates a Journal entry form and I found a simple code to open the file save as window so my team can rename the file to what ever they want. But I would like to have the format automatically save as an excel file. Is there easy code to do this? I used the simple code...

Hello all, We have a routine task where we copy and paste the PnL information but with different customers to new worksheets. - In the sheet "PnL", I have a Pivot table that I can filter different customers to see Revenue, Margin and Costs information. - I have to select each customer/plant...

Hi. Let me be brief: I have values in 2 columns B & C. Column A has 1,2,3,4,5,6,7,8.....to any number. I need a code to multiply column A values with column B & C values separately with both resultant values substracting from each other until a 1.00 difference is detected. Example (a): 0.74...

Hello everyone, My first post here, I've searched the forums extensively for a past week but couldn't find exactly what I'm working on. Unfortunately my case has some weird details . I'd like to ask you for help as I'm stuck right now. Here's the table showing what I mean: <tbody> start...

I have a sheet of 800 rows and 260 columns (A1: IZ800) and each cell contains the data are very diverse. I want to use VBA to look for in each cell the number of characters on the left before the x and if more than 4 characters are given red cell if VBA is run results: 8654x4289 <- ignored...

I'm Trying to get control of the IE pop-up window in my VBA excel project with no success. Could someone please explain to me how to do this, I have looked around the internet but have not found a solution. When I use the debug print command in the code it tells me the pop-up window address bar...

I have 2 tables as shown below Table 1 AA BB CC DD EE Table 2 bb aa bb1 bb2 cc1 cc2 cc3 I need help to do the below steps using Excel VBA code Use Table 1 and loop thru each data in table 1 and compare to Table 2 If table 2 only have 1 match, just replace the Table 1 data from the table 2...

I want to make an excel tool that has a button where I can upload a workbook. Once the workbook is uploaded the tool will: 1. Filter the workbook so only rows that have "Active Loan" in Column M and "Locked-NoRequest" in Column AU stay 2. Extract specific columns from the left over rows...

Firstly, I am not Excel proficient nor VBA literate. However, I have been slowly learning the language through sites such as HomeandLearn.org to overcome my difficulties but seemingly to no avail (Although making some progress). I have however, identified some of the problems with which I am...

arr1=array("d","e","f") For Each elem In arr1 a= a + WorksheetFunction.Sum(WorksheetFunction.CountIfs(.Columns(2), "<>specific text", .Columns(13), "<>""", .Columns(7), elem)) Next elem Can someone tell me a better way to do this? Thank you so much :)

Hi, I am a beginner on working with macros in excel. I am currently trying to overcome challenges on the below items. To compare two columns in excel using macros. The challenge I am facing is that I want to compare using empl id or name which are in multiple rows and add the total value (say...

Big props to whoever knows how to do this. I have are around 100 different workbooks that I want to add a column at the end to that adds the file name to each row. Instead of going into each workbook and manually adding the file name to the last column does anyone know a code that can do this...

I wrote a vba script that combined a bunch of workbooks into one master workbook. I want to add a line of code that will basically say which file the data originally came from. Preferably in the last column. So for example, if the first 20 rows of data came originally from the file "January" a...

Hi all I wrote a simple code that gives me surprisingly (probably not surprising for you) a memory problem: "There isn't enough memory to complete this action..". I want to copy/paste rows from a sheet to another sheet based on two conditions. After it is pasted I want to delete those rows...

Hi all I want to code the following: the macro has to delete the entire row if the value of the cell in column AR is "ABC", "DEF", "GHI" or "JKL". My code deletes only the rows containing ABC and GHI.. Could anybody see what's wrong in the code? Dim i As Range Dim wsTest As Worksheet Dim...

Hi, I'm trying to reference another workbook in vlookup formula but I get an error. Is there a way I can reference another workbook without having the workbook open. I tried two formula's below (1. setting workbook as variable and 2. putting workbook directory in the vlookup itself).: 1) Dim...

Hi guys i am not new to programming but for some time that i dont write nothing. At the moment i am trying to create a small code quit easy i would say and while testing in fake data works but with the real data doesnt. I have a loop running through all the used cells looking for a specific...

In my Excel sheet there are ABCDE columns D column is filled in with data. & I am filling down BCE columns by selecting & Pressing CTRL+D. I want a VBA macro to do this, the sheet is of 1000 rows. data looks like this I want the data to be like this