quotes

  1. J

    Need Help Deleting Rows on all sheets (Quick) (VBA/Macro)

    Hi all, Looking for a macro to achieve the following. In column AA of a sheet named "Welcome" no quotes, I have various text in its cells. If the cell does not contain the word "facts" no quotes in it, I would like to have that row deleted from ALL sheets in the workbook, and not leave any...
  2. R

    VBA Remove hidden quotes in one cell

    Hello, I am trying to find a way to use VBA to remove these hidden quotes in front and end of a few words in one cell (B1). Can someone please pass on a way to delete or remove the quotes just in one cell? Thank you!
  3. E

    Sheet name without spaces have quotes around them- used VBA to create sheets and name based on cell value

    Hi all, I have a code that adds in n number of new worksheets and names it based on cell value. Eventually, I have a summary sheet that will perform lookups to respective sheets using indirect. The newly created sheet names do not have any spaces in them, but for some reason the references...
  4. S

    Updating data from one workbook to another

    All, I am in need of some help. I have two workbooks - A acts as a database of all our quotes, whilst B is a local file with just the quote info for that particular job. I am trying to write some VBA to loop through all the quotes in B (unique id in col F) and update the main database. I am...
  5. B

    Surround values with single quote

    Hi, I created the below sub to convert a single column of values (of varying amounts) into a single, comma separated string. Thus if Column A on "Sheet1" contains: 50 55 60 65 70 75 The procedure will convert that to a comma separated string on a new worksheet ("List1"), e.g.: 50, 55, 60, 65...
  6. S

    When to use Quotes

    When I use the following, I place the formula into the Spreadsheet and get the resulting row number. Range(emailColumn & FirstRow & ":" & emailColumn & LastRow).Formula = "=MATCH(B2,'RosterFileName'!FullName,1)+3" When I try this function in VBA I get different errors; syntax, compile error...
  7. Nelson78

    Impossible replace "" double quotes

    Hello everybody. I'm importing datas from a website. The datas have "" double quotes, it seems they are normally invisible (I can see them only copying an pasting in a notepad). How can I remove them? I've already tried different ways, unsuccessfully (for example): Dim c As Range...
  8. P

    Updating Excel sheet when using another Excel sheet as a template

    I'm using Excel 2003. I have an Excel spreadsheet that I'd like to use as a template for quotations for my company. Our quotes manager will enter the information into the spreadsheet, do a "save as" each time he quotes a job. The original sheet will be used as the template. Is there a way to...
  9. S

    =sumifs question on formula to get total by month

    Hello Forum, I am in need of getting the totals by month for service types. I have a tab named Spot Quotes, in column R is the Service type, Col 'N' has the date and time completed like this '2/1/2018 13:00' My total tab is named Total Quotes. Starting in cell H4 would be the total for the...
  10. S

    Auto count shipping request for quotes: Sumproduct(--(...),(mid(offset??

    Here's an image: https://ibb.co/hJFWYb Context: I need to get a shipping cost to finalize my quotes. Some quotes are really complicated and long. In the example, I want to return the total qty of Mother boards, Hard drives and 4gb ram. Appreciate the help!
  11. J

    Macro to insert double quotes

    Hi, I need to export a sheet to CSV format, so I can use that csv file as input to a access table SQL insert statement. My problem is, I have one column that has data in it with quotes that cannot be altered. e.g. The "location" field has building, room, cubicle such as "Building 208, Room 19...
  12. D

    Any way to run an 'audit' to see which formula/processes are most bogging down my file?

    I'm pulling in a few hundred real-time stock quotes at once and automatically performing a bunch of sorting and modeling as the data updates, but it often lags badly so that I'm sometimes seeing stale stock quotes (30-60s after they change). I've determined that it's not the real-time quotes...
  13. K

    Add item to VBA dictionary with quotes

    Hello, I'm trying to add the key classificationLevels with a value of ["Sectors"] (yes, I need the quotes) to a dictionary When I try Body.Add "classificationLevels", "[""Sectors""]" I actually add the following with the extra ""s. ["Sectors"] I also tried Body.Add "classifiactionLevels"...
  14. A

    formula strings aggravation

    Excel 2013 macro code snippet: ActiveCell.FormulaR1C1 = "=MID(D2,FIND(""."",D2,1)+1,FIND(""."",D2,FIND(""."",D2,1)+1)-FIND(""."",D2,1)-1)" This formula within the quotes works (I'm using it in another excel file), but when the above code snippet sets the cell value, the actual resulting...
  15. C

    VBA - Remove quotes from any cell that contains them

    I have a large spreadsheet of data that goes from Columns A to Columns AD and is about 2000 lines. The spreadsheet is created from some Access database (I am not familiar with the process). For some reason various cells end up with quotes at the beginning of the text in the cell (e.g. "USE...
  16. Y

    Extract text in double quotes including the the double quotes

    Hello everyone, I am trying to extract text in double quotes including the double no matter what position they occur in. for example: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 219px"><col...
  17. K

    Picking value from a certain cell under certain conditions

    Hello! Sorry for the dumb name of the topic - I am a beginner in excel and I know not that much so it's difficult for me to define the issue here. I attached my excel file which I am referring to. It's kinda difficult to explain what I wanna do here but I will try. What I wanna do here, is...
  18. C

    Quotes, Logic Signs

    Can someone explain why in the formula: =COUNTIFS(Sales,">="&H1,Sales,"<"&G2) quotes are used? I know about concatenation but why are the logic signs in quotes and why couldn't the formula just as well be written as: =COUNTIFS(Sales,>=&H1,Sales,<G2) ??? I know words that appear in quotes...
  19. T

    Getting rid of quotes when copying from excel.

    I need some help for when I am copying data from a cell and pasting it into a text box on a website. Every time I copy the cell and paste it, it has quotes at the beginning and end of the data string that I have to manually delete. Is there a way to do this so it does not paste the quotes...
  20. J

    Automatic Updating Between Workbooks

    I want to provide for automatic updating of values between two independent workbooks. Workbook A contains several price quotes. I’ve copied those quotes, using Paste Special/Paste Link into Workbook B. However, when I change the values in Workbook A, the new values are not automatically...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top