All Questions
4
questions
2
votes
1
answer
46
views
How to automate vb script
I have this code:
Sub NewYearData()
Dim wb1 As Workbook, wb2 As Workbook
Dim r1 As Range, r2 As Range
Dim addy As String, sh As Worksheet
Dim shName As String
Set wb1 = ...
0
votes
1
answer
951
views
automatically updating the links of workbooks
iam looking for a way to open .xlsb files in a folder one by one and then rename or update its links as .xlsb.
For example if "C:\FINAL ANSWER\edit.xlsb" file has links as ='C:\FINAL ANSWER\MAIN ...
- 47
0
votes
1
answer
991
views
Create cells value based on formula in Excel VBA
I have an Excel sheet like this, is there a way to get value in C8 using C6 in VBA?
- 15
1
vote
1
answer
1k
views
Need a Excel script to identify email addresses that contain a different variation of the first name of the contact
I have an Excel spreadsheet with 50k+ rows of data, where we are trying to identify within the rows of data where the email address has no match of the first name, etc.
We are basically trying to ...
- 15