UDF need to lookup cell content for city, state names from sheet2 ColumnA
Please see the example link
https://docs.google.com/spreadsheets/d/1Qw0CaBUP1Qo0uaXRO-jlKdT6wJu5xfhrs84QGBzFlLs/edit?usp=sharing
Hello, first post here-
I am trying to streamline the set up for a worksheet which I reference every day.
Background info- The goal of the spreadsheet (Main) is to reference other worksheets (Project), which are stored on our local server, and pull data from those project worksheets to...
Hi
I have been looking into automating a process to compare new price lists supplied by suppliers (this could be anything from a few hundred rows to several thousand) against an existing product list within an application.
I can create a workbook that has 2 x worksheets, "new product list" &...
Hi
I have an Excel workbook with around 150 ActiveX checkboxes. All these Active X controls leads to long load time when opening the workbook (about 20 sec on my computer). Is there any way to speed up the load time of the workbook (without changing to form controls)?
Hi.
I have a sheet with a table. I am trying to sort table 'DeviceSummary' using Column 'ID'
Table DeviceSummary:
ID Col2 Col3 Value
1,1 A B 12
1,2 C D 15
etc
I need to sort the table using column ID.
I set up a range defining the criteria to sort on...
Hi and thank you in advance for considering my question.
I need to use VBA in Excel to resolve the following issue: We have word documents that are generated from a training development application. The documents generate titles with Heading 3 and Heading 4 styles that are duplicated in the...
Hi Guys, I have a piece of code which can be used to connect excel with mainframe application.
Below is the code which works perfectly:
Get the main system object
Dim Sessions As Object
Dim System As Object
Set System = CreateObject("EXTRA.System") ' Gets the system object
If...
Software situation: Windows 10 and Excel 2013. in an INTRANET there is an attendance list generated by Excel and saved (with VBA) as a pdf-file. If someone wants to modify his attendance record — for example to change his flexible working hours or free time — then he could open the underlying...
Hi Friends,
Is it possible to create drafts/ Marked as sent emails without sending emails using VBA.
I have list of emails in excel sheet in ColumnA, Where I want to create draft emails "From emails" picking from excel sheet to "From Address field"
Does not matter any text in subject line...
Hello,
Anybody can help and create billing invoice for me with the help fully VBA/USERFORM in excel 2013 or access 2013?
my requirements are below
1>Company Details
2>fully edit features if i want to change previous invoice
3>product select or search with the help of product code & search by...
Hi guys, I am new to excel formulas and I am struggling with a formula.
I have a line of text,of which I want to keep only the 2nd and 3rd word and remove the rest. for example: cell A1 contains 'I love reading books' . I want to write a formula/vba code whichever is easier to give output in...
I have built the PivotTables from the data and then PivotCharts from them.
My "PrimaryValueAxisTitle" is showing on the wrong data; displaying on the Secondary axis side. And my "SecondaryValueAxisTitle" is not displaying at all. I do not get any error messages.
Got any ideas...
Hi Team,
I have been brainstorming this from past couple of months. I work in reporting team and during month end I pull all incident report which has changed priority from P1-P2-P3-P4, P2-P3-P4 or P3 to P4. Currently, I am performing it manually (4000+ count). Below is the sample excel where I...
I have columns A through DB (A:DB) with data, and there is a varied number of rows for each column. If possible, I need a macro that will "stack" columns in pairs of two. For example, column "C" directly under column "A" and column "D" directly under column "B" and so on for all columns A:DB...
Hi Friends,
In sheet2 ColumnA with below RSS urls.
Need to extract all results from each url into sheet1 like title, description, url, date.
http://www.bing.com/search?q= site:Plus.google.com site:Plus.google.com "lived in * dallas" "carpernter at" about&qs=&format=rss&count=50...
Hi Friends,
I am trying to do partial match but its not pulling correct abbreviations.
Attached sample file.
Used this formula but did not pull right one.
<colgroup><col width="64"></colgroup><tbody>
#=VLOOKUP(F1&"*",Sheet2!A:B,2)
</tbody>
https://spaces.hightail.com/space/M8AAa4mCKO
It seemed like it should be so easy. I'm creating a bunch of data from Access and sending to Excel and then creating a bunch of Charts.
Charts look good. As each is created, I want to copy it and paste into a Word document.
Set WDapp = CreateObject("Word.Application")
WDapp.Documents.Open...
hello,
I am very new to vba programming. I am facing a new problem.
What i am trying to do here,Create 6 check boxes that will highlight 6 different values after comparing two columns. so I can undo the highlights when i uncheck them.
So i have two sheet, sheet1 and sheet2. I wanna create...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.