excel & vba 2013

  1. S

    UDF to get state names from cell content based on sheet2

    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
  2. P

    Dynamic filename referencing for small calculations

    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...
  3. S

    Macro to Compare worksheets and copy unique rows to separate sheets

    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" &...
  4. E

    ActiveX checkboxes slows down opening/load time of workbook

    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)?
  5. R

    Trying to sort a ListObject Table using a custom order range

    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...
  6. R

    How to get excel to sort some strings like they were numbers

    I have a sheet with a couple of columns. <colgroup><col><col></colgroup><tbody> IndexID Part Number 1,1 3807 1,2 6680 1,3 4440 1,4 2074 1,5 5021 1,6 2298 1,7 1572 1,8 3379 1,9 8832 1,10 2627 1,11 6802 1,12 4395 2,1 7504 2,2 4109 2,3 9803 2,4 5461 2,5 2052...
  7. H

    Unable to delete Paragraphs in Word Docs Processed from Excel

    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...
  8. I

    Need help to understand fields

    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...
  9. S

    How to prevent an Excel file from being opened simultaneously by a different user on a network?

    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...
  10. S

    Mailmerge From address have to be change for each email

    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...
  11. S

    Billing Invoices VBA/Userform

    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...
  12. I

    Formula to keep specific words only based on position

    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...
  13. MacroAlan

    Chart Titles not displaying from VBA - Excel 2013

    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...
  14. R

    How to find incident which has changed multiple priority during his life-cycle

    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...
  15. J

    Stack multiple columns into two columns in pairs of two

    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...
  16. S

    How to extract rss bing results with VBA

    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...
  17. S

    Partial match sheet1 in sheet2 get columnB

    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
  18. MacroAlan

    Paste Excel chart into Word using VBA

    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...
  19. F

    How to do checklist to highlights and uncheck to undo highlights for values in excel vba

    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...
  20. I

    Insert a picture above another picture in excel cells in E column

    How i can insert a picture above another picture in excel cells in E column. E column cells have images in them.

We've detected that you are using an adblocker.

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.
Go back
Back
Top