#vba #excel

Hi folks, An expert helped me out with the below code which is pulling out the information from "transactions" and "purchases" worksheets to the "output" worksheet. I need to build-in one more logic - to exclude all the rows from the "perc change" calculations (column H, "output" sheet)...

Hi experts, I am struggling to write a vba code to count the unique values based on criteria. Can somebody help me please? Like, I have the data as shown in the mini-sheet attached. I need to find the unique number of items# from column2 if the Date is blank in column1. As per the sample data...

How to Match workbook to other workbook data & Get status (HOW To MATCH "BOOK2" WITH "BOOK1" , All data Match , to Get Status and Highlight 4 CELL matching How it possible ???

(NEED THIS CONDITION) C2= "20 ft" use 5,00,000 C2= "40 ft" use 10,00,000 Change value According "20 ft" Or "40 ft " ------------------------------Kindly Suggest Right Formula-----------------

I am totally new to Excel VBA. But I have a requirement to copy some data from let us say sheet1 to sheet2. I have several columns and rows in sheet1 (source sheet). Now I have to copy only Five columns data from within that where "Ferro Manganese" found in particular one coloum and if found...

Ok....So, I am currently working with an excel database that links client information entries to a Word note file located in the client's digital file. What I'm trying to do is three fold; I'd like to be able to code the "notes" cell on the client's row to auto-populate the next available entry...

Hide Row with Zero value with Entry

Hello, My colleague has recorded a macro which works for 2 of our team. However when others try to use it they get a "Compile Error: Named Argument not found". I have done some research and I think I understand what a Named Argument is, but I don't understand how its created or why it works...

Hello Mr. Excel gang, I have spent 10 hours trying and trying my hand at this code. It seems like a repetitive question after scouring the web yet any code I came across gave me some kind of issue, even with hours of tinkering. That being said - SOS >I have hundreds of files in a folder on my...

I need to create a VBA VlookUp that will go through Col A to H in a Sheet2 tab(the table_array), match it with column V(look_up value) in Sheet 1 and put the matching results(which is the column index and its in column 7) in cell AD. I was able to test this for a very small range of values...

Hello every body, i hope that some of you guys are able to help me out. i have to get multiple excelfile into one file, but i want to make an inputbox, so that the user are able to choose between different folders. The code looks like this so far: Sub Samling() Dim FolderPath As String Dim...

greetings i am trying to send out sms using an api http://bulksms.mysmsmantra.com:8080/WebSMS/SMSAPI.jsp?username=username&password=password&sendername=sender id&mobileno=919999999999&message=Hello i want to get the mobileno from a cell in sheet7 of the workbook from "d" the cursor will be in...

Hi. Good day everyone. I am writing a VBA application for an excel workbook, which contains information regarding multiple funds of multiple fund managers. In the worksheet, there is a "Update" button. When clicked, it grabs the returns and other information from the webpage and place them...

For context I am trying to hide tabs based upon the specified user of my model and I want to make it dynamic such that if new tabs were to come into the model....all I would have to do is say if it were true or false based upon the specified user. I have 5 different users lets call them...

I have created a master excel report with 5 main tabs, 3 of which contain multiple pivots that draw their data from 3 separate CSV files. The CSV files do not have a single common denominator and cannot be joined. I need to replicate the master ~500 times for different users. Each user can only...

Good afternoon - new here so please be gentle as i'm a total novice at VBA coding... I have a master spreadsheet that draws information from 3 password protected workbooks. In order to open then I have got the following code: Sub OpenSesame() Workbooks.Open Filename:="C:\folder\sub...

Hi, I'm new here, I would love to get resources on VBA - very resourceful analytical materials, thanks guys

Hi! please help me to figure out on how to put a text if only nothing follows to the word "TRIMFORM". below is the code that I used. Thanks in advance :) Sub try() Dim c As Range For Each c In Range("D2:D429") If c.Value Like "*TRIMFORM*" Then c.Offset(1, 0).EntireRow.Insert c.Offset(1...

hey, need your expertise guys, i have a formula for VBA code below. it returns an error Sub test() Range("Y17").Select ActiveCell.FormulaR1C1 = "=IF(MAX(RC[2]:RC[14])<=0,""-"",INDEX($AA$15:$AM$15,0,MATCH(MAX(RC[2]:RC[14]),RC[2]:RC[14])))""" End Sub I believe the absolute reference...

kindly solve this issue my code is Private Sub Button9_Click() Sheets("sys").Range("A9142:A20000").Copy Dim lastrow As Long lastrow = Range("A9249:A20000").End(xlUp).Row Sheets("Sheet1").Activate Cells(lastrow + 1, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone...