title

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top