quotes

  1. F

    remove quotes and apostrophe from cell

    looking for best way to remove the feet('), inch(") and the hyphen from d3
  2. E

    Std Dev problem when using extra condition

    Hi, I need to calculate the standard deviation for 'Duration' data, based on 2 conditions in multiple columns that both need to be TRUE. I had some trouble but ended up using the DSTDEV command. I want to be able to avoid getting an error when there is no data that meets these conditions. I...
  3. D

    Access Macro to create new word and excel documents from templates

    Hi All, I'm new to Access, so I'll apologise now if this is a silly question. Currently, I use an Excel template to put together detailed Building and Construction quotes. I want to use Access as a database for all our quotes. Is it possible to enter the data in to Access, and have a macro...
  4. R

    Converting Cell Formula (MAX) to VBA Formula

    Hi Folks, Just a quickie (I think/hope)... :roll: I had a formula in a spreadsheet cell: =TRUNC(MAX(((MAX(E5-5,(E8-4)))/10),1)) that I needed to move into code, i.e.: Sheet1.Range("J18") = TRUNC(Max(((Max(E5 - 5, (E8 - 4))) / 10), 1)) The VBE/Compiler doesn't like it in this form. After...
  5. G

    How to use Formula in DataValidation List Source

    Hi friends, I need to use a formula in the Source: of my Data Validation to include the Sheetname for my drop down list. The following formula should work if someone can please show me how to properly QUOTE it. I get very confused trying to put quotes within quotes. To be clear, the...
  6. F

    How to add quotes to variable references

    In example below I need to add quotes around the last cell reference and to same formula across columns. I didn't add quotes because autofill doesn't work with quotes. Thank you in advance =SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!"&"$B$35:$B$1000"),$A2,INDIRECT("'"&SheetList&"'!"&M$35:M$1000)))
  7. G

    Issue with csv file

    For work, need to save a csv file to be sent to customer. They upload into their system for invoicing. For some reason, the csv I'm sending, they say is in the wrong format and fails when uploading into their system. After looking at the data, when you open the file with notepad, the text...
  8. B

    "Select " in filename on DoCmd.TransferText

    I have code to import a .txt file into a table. I'm running into an issue where the filename begins with "Select " (note the space after Select). If there is no space after "Select" the code runs properly. This is clearly an issue with how the DoCmd.TransferText is processed and not the code...
  9. V

    sound alert if any error occurs

    Hi people, I am using a excel file where stock quotes are keep updating for every second. During the process when random errors occurs excel sheet will show error messages. I want some sound alarms whenever any message box appears or the sheet stopped updating latest quotes. Thanks in advance.
  10. B

    Predicting sales figures from quotes

    Hi all Probably quite a basic question for you experts on here but I'm trying to solve the following problem: I have values of quotes and values of sales for c.30 weeks worth of data: Example, Week 1 Quotes: £3m Sales: £1m Week 2 Quotes: £4m Sales: £2m etc...
  11. gheyman

    ACCESS Question Using a Table from another Database

    Were i work there is database that has several tables. But pretty much everything is based on one main table in that database. Most of the other tables are for Combo/listboxes sources data in the main table named QUOTES MASTER FILE. The Owner will not allow anyone to touch the data, especially...
  12. S

    sumif does not work if as intended

    Can anyone explain how to solve this issue with my sumif formula. Cells A1 has a value of 100/300, and cell B1 has a value of 30. Cells A2 has a value of " > 100/300" (without the quotes), and B2 has a value of 20 if I do a sumif and search for 100/300, I return 30 as expected. However, if I...
  13. B

    Quotes

    Afternoon Can someone assist with the correct syntax for the below countif :confused: cell(1,12).formula ="=countif(G1:G100),"<=10000")
  14. E

    VBA Application MacroOptions

    Hi, This Macro code won't list all the Argument Descriptions, it only list the first description in the array "ArgDesc (1 to 2). How do i list all the strings in the array "ArgDesc" ? thanks Sub DescribeFunction() 'This can be used to add help text to each function Dim FuncName As...
  15. M

    Putting double quotes around text

    i have a formula in cell A2 with a text output. I need to add double quotes at beginning and end. however if I try to use this code i.e. a double quote inside a pair of double quotes as you would add any other text ="""&A2&""" I just get this which isn't helpful <tbody> "&A2&" </tbody>...
  16. S

    search column for Quote, then msgbox

    Hello, I am trying to get a textbox to show if quotes are found. Column C is the description column, and contains 1/4" oak, 3/4" poplar, etc. if found, i want to call another macro, and if not found, display a messagebox that says "no quotes found". I have this in a larger macro and i get...
  17. P

    Run-time error '9' Subscript out of Range Help

    I am getting a "Run-time error '9': Subscript out of range" on the following code: Worksheets("Exhibit ""I""").Activate The worksheet name is Exhibit "I". If I remember correctly about what that run-time error means, on this line of code its saying it can't find a sheet with that name to...
  18. gheyman

    Access Query Type?

    I have two tables. Both have a field called "Quote Number". One table is called "Quotes Master Table" and the other tblProposalStatus I need a list of all Quote Numbers that are in the Quotes Master Table and not in the tblProposalStatus. I will then need to append those Quote Numbers into...
  19. A

    Stock Quotes in Excel !!!

    Hello Friends, I have a code which gives the stock quotes in web browser. Is it possible to have list of 50 stocks from Indian Stock Market & have TO & From date columns. So whatever stock is selected from the list & respective dates, the data will be downloaded. Thanks In Advance AR
  20. C

    Joining Text with Hypen

    I have asked this before in this forum (https://www.mrexcel.com/forum/excel-questions/1062061-separating-characters-hyphen.html#post5100161), but have ran into a hiccup. Cell AJ2 has "Khaki" without quotes Cell AJ3 has "Medium Gray" without quotes In cell K2 I have (=SUBSTITUTE(AJ2&"/"&AK2...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top