1. G

    VBA to search multiple cells.

    Hey guys, I have this simple code to export as PDF, range AB52 is where it pulls the file name to save as... is it possible to have multiple ranges for the code to look for? I tried "range ("AB52:AB54")" would not work. Is this even possible? If one cell is empty look on the other ones for the...
  2. Y

    compare and find prize through prefix

    Hi guys I was wondering if someone could help me with this challenage. I am looking for a formula to calculate a prize based on the prefix (telephonenumber breakout). These breakouts are to call international. See below the prefix and rate example template. It works like this, if the prefix is...
  3. Z

    find first letters in a string of alphanumerics

    I have a string ex: ".13 - LAR" I would like to get the first letters, or non alphanumeric and non numeric characters of the string. They are not always the same distance from the beginning so I can't use left or right function. However they always begin in the 6th or 7th position. Any thoughts?
  4. P

    Lookup and Find

    I feel like I should know this but am drawing a blank. I have a table of 3 columns and 10 rows and two values to locate. In column 1, I want to find the number 29850 and I want to locate in column 2 the term "report" and return the value in column 10. So an idea is as below: <tbody> Sequence...
  5. 5

    Find previous quarter and display as Q3 or Q4

    ​Hi, I would like to be able to determine the previous quarter from the current date and display as Q2 or Q3 or Q4 etc.<o:p></o:p> <o:p> </o:p> I have the code to find and display the previous month (see below) but am unable to find a similar one for quarter. Thanks in advance.<o:p></o:p>...
  6. J

    find the content of a cell in another sheet based on the content of a cell

    Hello, I'm looking for a macro to jump to a cell in sheet 2 based on the content of a cell in sheet 1. Basically what the macro should do is: Find cell A1 of sheet 1 in column B of sheet 2 and go to that cell. I've looked for a solution but couldn't find it. Hope it is a simple question...
  7. S

    Calculate no of days to go back to reach a specific day name

    I know this should be easy, but I keep tying myself in knots over this one. I have a date selected by the User. I'm trying to find a simple way of working out how many days before that date is a specific "day name". For example if I take the date as 23/12/2019, I want to find out how many days...
  8. P

    Replace and Find VBA code for a command button

    Hi goodmorning all, hope you can help me place I have cells which sometimes has forexample -1, -4, -3 in them the range is cellsB24:P39, so what I do at the moment manually is CTRL F (find and replace) clickon replace tab – in find what enter (-*) and in replace with enter (0) thenreplace all...
  9. B

    Save with references to unsaved documents

    Hello, I have an excel file that gives the above warning message when saving. I've tried to find references to any .xl. files with find but this gives zero results. Is there another way I can find unsaved documents in an excel file? Thanks. B
  10. V

    VBA Find first character in column

    I have a column containing Given Names sorted into alphabetical order and want to find the first name starting with, say, "V". I do not want to find, say, "STEVEN" which contains a "V" but not as the first char. Assistance with a macro to do this please.
  11. P

    Find last used cell within For Each Loop

    Hello! I am yet to figure out how the following works, but use it all of the time to find the last used cell in a column and offset 1 row: .Range("B" & Rows.Count).End(xlUp).Offset(1, 0) = Cel.Value I am trying to apply the same logic to the following: Cel2.Offset(0, 5).Value =...
  12. G

    VBA Find and Select loop

    I have the below line of code as part of my VBA . As shown below, the first "find " section looks for the word "Paris". When it finds the work Paris, it updates the cell value as France and then moves on to the 2nd "find" section where it looks for the word "London and then updates the cell...
  13. J

    Output first Match Found if Cells contain Duplicate Text

    Suppose I have several a range of cells, each cell of which contain a string, and I want a function to look at this range and output "FALSE" if all strings in the range are unique from each other and I want it to output the first duplicate it finds if there are at least two cells with the same...
  14. A

    Creating Variables with VBA, maybe?!

    Hi All, I have a macro that takes a download from our asset manager and sorts & processes into our report form but I hit a wall with reinvestment's. I can sort them to a space but I'm not sure how to do sumif or something else to sum the reinvestment's per symbol in each account, e.g., no...
  15. F

    Formula to find closest Thursday to a date

    I have a sheet with a date in Column B. I need to find the closest Thursday that is 150 days prior to this date. I can't seem to get the formula to make this happen. Any help would be appreciated.
  16. O

    Found last used column from Row 2, need value in row 1

    Hello all, I have been trying all afternoon to get something working and I can't figure out how to do this.... I am using the following to find the last used column in row 2 on my work sheet: LastColumn = Sheets("Summary").Cells(2...
  17. B

    Find all matches and consolidate them

    Hello, I have a spreadsheet with multiple sheets. Sheet1 Column A has alpha numeric values in it like M1, M2, M3, etc. along with empty cells between them. There may be duplicates but that doesn't matter. I need a formula that I can put on Sheet2 that will generate a consolidated list of what...
  18. T


    Hi I am currently using this formula. =IFERROR(INDEX(Transfers!$J$5:$J$999999,MATCH(A68&$A$61,Transfers!$F$5:$F$999999&Transfers!$H$5:$H$999999,0),MATCH($A$3,Transfers!$E$5:$E$999999,0)),0) It works great except it does not sum multiple matches it only find the first match in the table. I need...
  19. D

    find the first business day of november of LAST year

    the title says it all
  20. A

    Finding the text and moving Next cell

    Hi All, Thank for your support for learning for VBA I have a small problem, I find the text and copy 7 cell in the Active sheet but code not move Next finding. This my code Cells.Find(What:="Date", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows...

Some videos you may like

This Week's Hot Topics