displayed

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

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

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

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

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

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

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!

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

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

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?

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

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

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

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

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?

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.

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?

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

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

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