1. K

    Find displayed value of cell

    I am using the following method to find the uniqueID supplied by a user on a sheet: Cells.Find(What:=uniqueID, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=True).Activate When I...
  2. S

    Extract non blank rows and adjacent data

    Hi all, Would greatly appreciate it if someone could lend a hand with a problem I have. I have a range, A9:G200. I'm looking for non-blank rows in column G. When a value exists (dollar amount), I then want that value displayed in N3, and I want the associated value from column A displayed in...
  3. P

    Extract line-by-line AS DISPLAYED from a single cell

    Hi everyone, I've seen similar questions, but no answers. Imagine cell A1 contains 100s of words, randomly entered by an end user. Cell A1 is wrapped text. Sometimes all text is visible, other times not if there is lots and lots of text. So as more text is entered, so too does the number...
  4. M

    How do I get Current Year And Current Quarter

    I need to get current year and quarter to update automatically then have previous quarters also displayed. And would like it to be display as shown below. Any suggestion as to how I can do this? <tbody> 2018.1 2017.4 2017.3 2017.2 2017.1 2016.4 2016.3 2016.2 2016.1 2015.4...
  5. T

    Using 'IF' and 'THEN' formula.

    Hi, could someone please help me? If I wanted to display set text depending on the entry in a certain cell, how would I go about that please? Say in my entry cell of E7 the word 'INTERNAL' was input, I'd like the phrase 'ACCEPTED' to be displayed in cell E17. If 'EXTERNAL' was to be input...
  6. T

    Consecutive integers

    I have to write the code such that when the button is pressed the next integer is appended to the end of thetable and its square (n^2) and root (SQR(n)) are calculated and displayed in the table. https://gyazo.com/79ad9088bdf3893edc4fa0165df1c2b5 Could anyone help me get started i have no idea...
  7. N

    Filtering Time Once Every 6hrs

    Hello, I have data being recorded every 30 seconds, however, I would like to filter it down to once every 6 hours. It's currently displayed in one cell as mm/dd/yyyy hh:mm:ss AM/PM. Any suggestions to how I would go about this? Thanks so much!
  8. E

    Date displayed in CSV file not the same as what is saved in the file

    Hi All, I have a macro that exports data from an xlxm file into a single tab and saves it as a csv to enable upload into a system. A particular date format in the source file has the date value as 01/01/9999 and displayed in that exact format i.e. dd/mm/yyyy. When the macro creates the csv...
  9. L

    VBA Picture Can't Be Displayed Issue & Bad File Name Or Number

    Hi, I have a workbook template that you can input a string and it will pull the picture from a directory or internet. The only issue is when it gets quite bulky, some of them result in a picture can't be displayed but unsure why as if I was to run the ones that don't pull the image one at a...
  10. S

    Transposing Excel data to turn rows into columns for Finance

    In the image the above portion will be the data that is downloaded. I need to find a way to transpose the data (into a new sheet) so that the highlighted portion is what gets displayed. Can anyone point me in the right direction for a tool or formula that might allow me to do this?
  11. A

    How to autofocus on the last row on listbox

    Hi, i want to make my listbox autofocus on the last displayed row thank you
  12. C

    Data validation using INDIRECT not working

    I am having a problem with dependent validated options using INDIRECT. Please see illustration. https://www.dropbox.com/s/fnlyewqsux7rh0k/Indirect_validation.xlsm.png The goal is to make the valid options offered in column I dependent on the selection made in column H, using =INDIRECT(A2) to...
  13. S

    VBA change already activated (displayed) userform's position

    Hi all, Is there a way to change already activated (displayed) UserForm's position on the screen? Thank you in advance
  14. E

    Last Entry within a range

    Hi all, I am trying to find a formula to list the last entry from column K:4:K23 These cells may change from time to time, so need the latest entry displayed Many thanks for any help
  15. M

    Making IF Statement combining AND and OR

    Hello, I'm trying to make an if statement where if one cell equals "BZ" and another cell doesn't equal one of several values then a 1 is displayed. My current attempt is not working: =IF(OR(LEFT($O2,4)<>"0940",LEFT($O2,4)<>"0950",LEFT($O2,4)<>"0740",AND(AB$1=$Q2)),1,"") Any ideas?
  16. D

    Comparing Values in Cells

    Hi all, I need help for this. A1 A2 A3 0 0 just Blank (if both cell contains 0) 12 12 Completed (if A1 and A2 are equal) 12 14 incomplete (if A1 and A2 is not equal) I just want output in A3 to be displayed. Thank you guys.
  17. B

    pivot table - keep field list displayed

    Hello Simple question here but I cant find it on google. With pivot tables we can display the Field List. But mine keeps disappearing when my cursor isnt on the pivot table. Is there a way to always keep it displayed?
  18. R

    Excel Form Dropdown List Format Issues

    I have an form (Userform1) with a dropdown list. I want the user to select an inflation rate; the dropdown lists is therefore populated with a named range in another sheet. The values in this named ranged are formatted as percentages (e.g., 1.0%, 1.1%, 1.2%, 1.3%, etc., with the range from 0.1%...
  19. D

    Very curious error: This image cannot currently be displayed

    I am currently using Excel 2010 VBA to copy a worksheet containing an image from one workbook to the other. The image of the copied worksheet, however, cannot be properly displayed and an error "This image cannot currently be displayed" appear in the image placeholder instead. After a bit of...
  20. G

    Identifying if 2 dates are alike and entering the appropriate month

    I have spreadsheet similar to this: This Year Last Year Date Event Date Event 3/1/17 Event 1 March 3/6/16 Event 1 5/6/17 Event 2 May 4/12/17 Event 3 April 4/15/16...

Some videos you may like

This Week's Hot Topics