VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
7 views
Removing duplicate rows in excel based on smaller column range
I've seen some answers that are close to what I need, but nothing close enough, so hopefully someone here can assist.
I deal with Excel files of User Data that often contains ten's of thousands of ...
1
vote
1answer
6 views
Excel - Error with vlookup across multiple workbooks
My following code displays error message "Application-defined or object-defined error", and I'm not sure why. Can you please have a look and help me solve the problem?
Private Sub ...
0
votes
0answers
7 views
I have a list of 9 names in a collum, I need to do something that when I change a name in this list the next one is updated
The thing is, I have a list of 9 names that each person needs to do an semanal activitie, but if for any reason the person assigned for taht week can`t do it, then someone is going to do it. I need to ...
0
votes
1answer
15 views
Delete Cell based on Color Index
I have data which shows me duplicates between two lists. I'm trying to delete the cells which have duplication to only show me the ones that don't match. Therefore, I can't delete rows but can only ...
0
votes
0answers
17 views
Excel Macro - Copy Range Of Cells in Sheet2 to Sheet 1 below Cell With Specific Text
I need to do is the following using an Excel Macro.
Go to Sheet 2 Copy Range of text L3 to R26
Then go back to Sheet 1 search for cell containing text "Recess Size" in column L
Then paste copied ...
0
votes
1answer
32 views
VBA function - Not able to output variable
I am working on a vba function to calculate the maximum value of a range of data divided by another. All seems to work well, but problem seems to exist when trying to do Application.Max to an array, ...
-2
votes
1answer
19 views
search for string in text file in vb and print lines
Hi I am new to VB and just though if someone could help me in my current scenario
I have a text file named shar.txt
It has 6 lines in it.
I am a new student
I am learning VB
Please ...
0
votes
1answer
20 views
Excel VBA - populating table from various woorkbooks via vlookup
Could you please give me a hand with making below code work? It should be fairly self-explanatory. I've only recently started to use VBA and hence am quite unfamiliar with many of the commands. Thanks ...
0
votes
0answers
11 views
excel 2010 With ActiveSheet.QueryTables.Add errors out but works fine in excel 2013
I have a VBA code for excel (snippet given below). I am not an expert but this code works fine in excel 2013 but fails in excel 2010. I have win 7 + excel 2013 where it works. However I have tried ...
0
votes
0answers
19 views
How to merge records with duplicates in a column and copy distinct data to a new column of the merged record
I have an excel table that I want to change. It looks someting like this:
PhoneNum Name Adress ID
758635 John Long First Street 17839
758635 Ann Long First Street 15283
...
1
vote
1answer
48 views
Excel VBA: More efficient way to pull in data from another workbook?
All,
As a temporary fix before we transfer the process over to our CRM system, I've written a tool with Excel/VBA that allows the user(s) to do some territory planning.
This tool opens a workbook ...
1
vote
1answer
21 views
copying and pasting dynamic data set
I would like to ask for a help. I want to create a validation tool for my colleagues. They manually check the audience profile (which is divided on Primary and secondary market - as shown in the ...
-4
votes
0answers
23 views
How to get GOLD price from a website to the excel [closed]
I need to get the gold price & silver price from www.gold.ae to cell
A1 & A2
A1 = Gold Price
A2 = Silver Price
I'm a newbee and only basic coding knowledge i have, tried so many options but ...
0
votes
1answer
21 views
Prevent More than 1 cell From Being Changed While Ignoring if the Cells' Contents Were Deleted
I am trying to create an Excel VBA macro that will detect if more than one cell is being changed at a time. I also want it to ignore the code if a person is only deleting the cells.
This works for ...
-1
votes
1answer
25 views
excel-vba, Find and highlight a number in a table
I'm currently trying to use excel functions to make this but still no luck so I figured maybe what I want can be done with vba. What I want is a function to search a number in a table, the number is ...
