1. E

    Title a Sub Routine with a variable.

    I have over a dozen checkboxes. They are titled checkbox1, checkbox2, checkbox3... etc. They each have a sub routine that tells them what to do when click. These subroutines are identical except for the number that indexes each checkbox. While this was easy to create using copy/paste. It is...
  2. K

    Code has error in email to PDF

    Sub AttachActiveSheetPDF() Dim IsCreated As Boolean Dim i As Long Dim PdfFile As String, Title As String Dim OutlApp As Object ' Not sure for what the Title is Title = Range("A1") ' Define PDF filename PdfFile = "Sharp_Air_Estimate" i = InStrRev(PdfFile, ".") If i > 1...
  3. M

    Email PDF code - save a copy

    Using this code from ZVI's examples on another thread - it kills the PDF at the end, how can I make it save a copy in a location, with the file name from cell C4? Sub AttachActiveSheetPDF() Dim IsCreated As Boolean Dim i As Long Dim PdfFile As String, Title As String Dim OutlApp As...
  4. B

    Sumifs and array question

    <tbody> A B C D E F G H I J K L 1 Project Value x x x Title Hours Title Hours Title Hours 2 15 Bob 3 14 Justin Bob 4 15 Bob Justin 5 18 Justin </tbody> Can someone help? I know this should be fairly easy, but I am struggling with it. I am...
  5. B

    Find duplicate in row based on cell value.

    I'm looking to highlight/identify duplicates in a row based on a common title (same) and am not sure of the direction to proceed. Simple example: There are two helpdesk title's and both are part of similar groups. I would like to identify all groups that "helpdesk" have in common. Then...
  6. M

    Clear content of several ranges (inc Message)

    Hi, For the life of me this doesnt work, any ideas? Many thanks Sub Clear_Estimated_Hours() Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "Do you want to continue ?" ' Define message. Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons. Title = "Delete...
  7. S

    Custom Sort with wildcard not working

    I'm trying to make a custom sort based on a contact's management level. Basically sort by their title. So the list would sort something like this: Owner, CEO, President, Vice President, CFO,etc... The list works fine when the title is exactly as in the custom list. But if the title is a...
  8. D

    Searching cells to see if it contains multiple text strings

    Hello, I am trying to search a cell to see if it contains an abbreviation for job title.. if it contains the abbreviation, i want it to put in the full job title which is reference in another cell. I have got it working for one text cell by the following...
  9. G

    Changing the subtitles stops VBA working and form printing

    Hi, I already have a sheet set up with an embedded form that pulls data from the spreadsheet and prints using a button programmed to print each numbered entry. A second button also saves a pdf copy to the system. However I need to change the subtitles in the spreadsheet and form as they have...
  10. M

    Word Tables to Excel when number of rows varies and transpose also needed.

    Hi! I want to take tables from a Word document and put them into excel where the columns are transposed to rows in a certain way. The word document has three tables, each of which can spread across 3 to around 20 pages. Each table has two columns. The first has a table number which tends to be...
  11. Johnny Thunder

    Lookup Help - 2 Criteria Lookup with the 2nd Criteria being a range - Excel 2016

    Hello all, I need help with a lookup and not sure how to achieve this. My dilemma: I need a 2 way look done on a row by row basis, similarly how a Vlookup would work except a Vlookup is done on a one criteria method. Sheet1 = PO Details Sheet2 = PO database Row to Enter Formula...
  12. A

    Two way lookup for column title

    I have a table that looks like the following <tbody> A B C D John Mary 16 21 55 32 Alex Lisa </tbody> What I need to be able to do is look for the letter (column title) that corresponds to a score of 55 for Mary. In other words, search for Mary's scores, find her score...
  13. TAPS_MikeDion

    VBA: MS Office 2011 for Mac

    Hi all, I have failed in trying to find this information via searches on this forum and Google so here are my questions. Using VBA MS Office 2011 for Mac: Can you hide the title bar? Is it possible to get a picture to be inserted into a userform? No matter what size or format I try I keep...
  14. M

    Military time to regular time in different timezone

    Hi All I would like to convert a list of military time in Column C to regular time in a different time zone (+3hr) and also deduct 45 minutes off the new calculated time. <tbody> Scedule Title Description Time Test1 Apple 620 Test2 Banana 1050 Test3 Orange 2015 </tbody> After...
  15. G

    Excel VBA data entry/sorting over numerous sheets

    Hello all! I have a database management query that has to be done in Excel (even though it would be easier in Access) How would I go about entering data into a 'form' or cells that will then keep a record of all of these in one sheet, but also populate into a sheet depending on the value in a...
  16. E

    Listing missing info in a grid.

    Some Helpful advice please. Imagine a collection of 10 items (First to Tenth) each item comes in one of 10 possible colours. So to collect them all I need all 100. Now I can create a table with the numbers as column titles and the colours as the row title which would allow me to tick off as I...
  17. T

    Returning Calendarized Data

    I have a title sheet that I want to show the data by month. My data sheet is a list of costs and what month they hit the system. Is there any way that I have have my title sheet search the data sheet and return the costs into the correct month column? Also, the data column will most likely...
  18. L

    Retrieve text from CenterHeader

    Hi I am trying to retrieve the text that is in the center header At the start of the program I ask the user for a sheet title sheetTitle = InputBox("Please input title for sheet", "Title") which I later use in the print setup With ActiveSheet.PageSetup .CenterHeader =...
  19. A

    Excel Graphing Question - Move X-Axis Title

    I have a simple horizontal bar graph. The X-Axis title currently sits on the X-Axis at the top of the graph (above the horizontal bars). How do I move the X-Axis title to the bottom of the graph along the x-axis (below the horizontal bars)? I know I can physically drag it, but is there an...
  20. J

    vlookup Question

    I am looking to pull in the the Title from another spreadsheet in the excel document based on the data matching. Hopefully below will help explain a little bit better.?. Is this possible to achieve? Main Spreadsheet: <tbody> AG AH User Story ID User Story Title 12345 This is My Title...

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