full

Can you sort a spreadsheet last rows by full color?

Hi, I have macro working whereby it will delete all rows that have less than number four in column E. However I want a variable to be set in stead of me inputting 4 in the code however it is not working when i set a variable. Any ideas? if you need full code let me know Below is not full code...

Dear All, I have created one userform which has the width of 1022.25 additionally in order to run it in full screen mode. I had used the below quoted VBA CODE. Quote Private Sub UserForm_Activate() '**************************************************************** 'Opening userform in full...

Good Day, This formula works for adding a ticket for every full 1000 =IF(A1<=1000,INT(A1/100),10+INT((A1-1000)/1000)) Is it possible to change above formula base on below rules? Many Thanks Every 100= 1point Between 100 to 1.000= 10point Every 1,000= 1point Between 1.000 to 10.000= 10point...

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Hello, I am looking for a formula to convert a full name in the various formats seen below and convert them all to a consistent "last name only" cell in an adjacent column. I've been trying...

im trying go calculate teams info easier to show than explain but here goes arsenal is in column A5:a3000 and their game played 42 twice so 84 goes in sheet full data "B5" heres a link to an example book https://www.sendspace.com/file/wsaxti

Hi all I on aompany that have exchange mail When I type User10 in outlook and click check names I fount that this name converted to be employee mail like Mohamed.ali@dmain.com I want to do this in excel But after searching a lot I find 2 macros First one return if mail exist or not and give me...

I need help on what formula I can use to work out an APR for a loan where the pay back is loan plus full interest divided by equal number of payments over the period. So, If a loan is £1,000 say at a simple monthly interest rate of 3% over 12 months, the payments are £113.33 each month to cover...

Hi All, I have two spreadsheets for a monthly mail shot. The first spreadsheet has Full Names and Dates of births. The Second spreadsheet is a list of people that have returned with a response. Full Name & DoB again. I need to do the following.... Run a look up to see who and how many...

Hello All I have a spreadsheet containing name of suppliers (lawyers) and the full address of their law chambers. I am trying to extract only the name of the chambers from the full address. The name will then populate under "Name of Chamber" column. I am stumped as to how to go about doing...

I used the following formula to capture the sums for duplicate PO's where multiple items and various qtys were placed. However, the formula will only place a value on the last instance of the duplicate value. =IF(B3,.B2, SUM($T$2:T2)_SUM($U$1:U1),"") I need to have the full po value display...

Hi. I have some script in a form that is looking up a date value from a combo box, and then populating a list box with data from sheet 6 columns where the date is equal to combo box value. Private Sub ComboBox10_Change() UserForm5.ListBox1.Clear ' First Clear the Box...

Hi Guys, Trying to click on a thumbnail of an image to reveal a full size image in a static position on the worksheet. The row on the left is a thumbnail of the full size picture on the right. What's the best method? Should I use a show/hide property for the larger picture or should the...

Something seriously wrong here with my Edit Hyperlink dialog! The hyperlink shown in my illustration works fine. (When clicked it opens that JPG in its associated program, IrfanView.) But if I click anything else (such as the examples highlighted) Excel crashes and restarts. Note that I...

Hi, I was wondering if there is an option/VBA code/steps that will automatically open a spreadsheet in full screen view and restrict users from toggling with the view unless a password has been entered. Pretty much the users will be using the spreadsheet only in full screen view while the...

Hi all, I am making an Excelsheet to easily create UTM-codes for content tracking. Now i'm stuck with the following problem: I have created two different sheets, one with the UTM-generator and the other one with the definitions used. These definitions are seperated in two values a full name...

Hi All, I have a question around getting numbers after a decimal point. The data with the numbers are in column A. I've used =INT(A2) to get the number in front of the decimal point in full (as it ranges from 0 to 120) and this works fine. The issue I am having is getting the number after the...

Dear Friends, I am not so familiar with excel Macro . In one of my excel application it is mentioned to use Application full function in excel. can anyone please help me how to write this Application full function and how to execute it automatically Thanks

Hi Guys, Hopefully someone can help convert the below number into a date format. 18222 This is supposed to correspond to the 20 Nov 2017. The full data extracted from the report is all in one single cell and each number represents a date seperated by a full stop. I just need the last date...

Hi Everyone, Thanks for looking, I need to display the full formula in excel showing the sheet references. Once I set Excel to show formulas I get something that looks like this; =IF(VLOOKUP(A2,'Letting Dump'!C:F,2,0)<>0,VLOOKUP(A2,'Letting Dump'!C:F,2,0),"Vacant") What i need is for the...