fills

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> My data are in the column C:P, require results in the Column V:X</SPAN></SPAN> For example count max occurrences of the "last to first" character find in the each row</SPAN></SPAN> Row 6 last to first character "1" max occurrence=1, result In...

Hello: =VLOOKUP(AH:AH,'[Copy of Providence SJ Health Services September 2018 V7.xlsb]PSJH Tracking Sheet'!$AN:$BS,32,0) that is my Vlookup up statement My problem: When I double click the bottom right of the cell the vlookup auto fills the same data instead of looking to column AN and finding...

Good Day, I'm trying to format the column C:E row texts base on the formatted(by conditional formating!) column P values. Column P formatted wih red&yellow; The cells fills red if the values less than -4000 which linked to U1(-4000) The cells fills yellow if the values greather than 5000 which...

Hi guys This one is a 2 min job for you guys!! But I'm really struggling to figure it out... The data is a table of dates and percentages, and I want the formula to tell me the percentage when I tell it the date. So, and apologies if this isn't clear, but I want the formula to read "if b1 =...

How can I make sure that my userform (a) fills the screen, and (b) is in the centre?

Ok, soo... i am having trouble passing the values from combobox and textbox from userform1 to userform3 i have made Cust, PrtNmb and WrkNmb private objects Sub CommandButton1_Click() Range("a1").Select With ActiveSheet .Range("A1").End(xlDown).Activate 'moves to end of data...

I know how to hide rows using a Worksheet_Change module. But, the end user is worried about the workbook being file type xlsm. So, looking to avoid a macro solution if at all possible. Bottom line ask: user fills in Cell a13 with a certain value. Based on the value in Cell A13, if the value...

Greetings can anyone please assist with a button macro to autofill cells to the right as per the colored-in cells in screen clip below: https://ibb.co/ew2Sbb Whenever the value changes, it fills to the right according to that value, then when a new value is found, it fills to the right...

Hello, is there a way in excel that if I use a name or something on one sheet into another sheet that it highlights/puts a number or auto fills data on the sheet. I have one sheet that has all are employees information on it. on another sheet is are positions in the company. if I put there...