bring

I have a spreadsheet that has something similar to thefollowing:<o:p></o:p> <tbody> <o:p></o:p> Find this number in range A1:B4<o:p></o:p> Bring back Officer who issued Ticket (ticket assigned to)<o:p></o:p> A<o:p></o:p> B<o:p></o:p> C<o:p></o:p> D<o:p></o:p>...

I have a freetext entry textbox (tried a cell) that users can enter details however i can seem to get it to bring up scroll bars. Any idea how I do this? Thanks

I want to hide the formulae i used in the spreadsheet whats the process secondly i want that the duplicate values to be deleted row wise how. Thirdly i want that the 5-5=0 its 0 comming but this should show as - how to bring that

Hi Folks, I hope I can explain this OK. I have a VLOOKUP that brings through data in an array. The cell either above or below the value will always blank. I need a formula that if the cell above the lookup value is blank then bring through the value in the cell below the lookup value and if...

Is there any way to bring a table to the front (like an inserted object)? I want to be able to move it around, and not have it resize the cells. Thanks!

Sorry folks, brain has fallen out of my ear. I have a table listing "sales" per week. Table has 52 columns to represent year. Averages are generated for Q1/Q2/Q3/Q4 & YTD using the SUM/COUNTA method. If I wanted to display the weekly performance required to bring the average to a target...

Hello all, I have column A with dates and named dts - column B with numbers So the combobox row source is dts The long story short this code cant see the combobox value to search and bring me what i ask For i = 2 To lastrow If Sheets("sheet1").Cells(i, "a") = combobox1.value then...

Hello All, What formula would I use to accomplish the below. If A1 is 1.5 to 1.9 bring back 101 If A1 is 2.0 to 2.4 bring back 111 If A1 is 2.5 to 2.9 bring back 121 This goes on for a while. Can you please help!

Hi, All... I hope this is the right place to ask this question. If not, let me know... Our company recently upgraded to O365 (Office2017) and since then, whenever I close out of MS Word, it asks me if I want to save the changes to TestDirector7. I have always just clicked no to not save, but...

Ok I have a column of dates and in cell A9 my formula reads as follows EOMONTH(A8,1). A8 has the date 11/30/2016 and the formula is bringing back 12/31/2016, but the last day of December in 2016 was 12/29/2016. Is there a way to tweak my formula to bring back the correct day end of the month...

Hi, I have searched and searched for a solution to my problem but couldn t find any... So here it goes I have cells aranged in a kind of calendar style, now, in the first column i have names, then in the following columns(that represent the days of the year) i bring data that coresponds to...

Hi, Can anyone advise whether we can bring the calendar using Activexcontrol from the developer in excel.

So I am have quite a task, I have a spreadsheet with a bunch of accounts, and they have the county, account name, address etc.... I want to bring them into separate tabs based on the county. I have a tab already for each county, just trying to figure out how I can bring them from the master...

Hi does anyone know a good code that will work in Vba that can bring data from excel into word by one macro? Thank you

Hi, I have the following formula which doesn't seem to bring anything back, can anyone help...

Hi, I have a short name in one sheet and a full name name in another sheet. how do i bring the full name next to the column of short name. for example: short name "Fila" is in one sheet and full name "Fila Industrial Chemica SpA" is in another sheet. how do i bring "Fila Industrial Chemica...

Hello everyone, I have inserted a stock excel icon (a computer screen). When i attempt to print the sheet, the right side of the icon is not showing up. I've tried to bring it forward and bring it back, but to no avail. It does not make a difference where i place the icon or what color the...

I've got this bit of code so far: =IFERROR(INDEX([EbayAmazonWeeklyReport.xlsx]Sheet1!$A$2:$F$2359,MATCH(C2,[EbayAmazonWeeklyReport.xlsx]Sheet1!$C$2:$C$2359,0),2),"") This matches up the number in column C2 on one spreadsheet, with column C2 on another spreadsheet. Then brings over the info...

Hi, I have a workbook with 2 sheets. Sheet 2 brings certain values across from sheet 1 using a lot of different formulas. At the moment all of the rows from sheet 1 are imported across as the formulas all look for the same cell on sheet 1. What I would really like to do is have sheet 2 only...

As I am not allowed to contact a moderator, this is the only way I can bring this to your attention, thanks.