fill

Need help on creating a macro for this scenario, I hope this to automatically run as I change value. If I enter 5 on C2 the macro should put "X" on D2:H2 If I enter 3 on H3 the macro should put "X" on I3:K3 This i currently what I have but it is hanging for some reason. Private Sub...

I am using excel to create an email message with a lot of data points from an excel table. I've got a 2nd table of info that I want to append at the end. The data in the email message is based off the Branch ID, when I use the drop down to change the Branch ID, the form updates. I would like my...

Hi All I have a spreadsheet for which I need it to do the following: I have populated all weekdays into a separate sheet, and then also added in the bank holidays until 2025. Now, I need it to automatically fill in the working days only into another sheet. So for example, a dropdown box in...

I created a button that when clicked opens up a text box. I can then input the unprotect pword into this text box and it will unlock the sheet. Then I have another button set up so that when clicked it automatically protects the sheet. I'm looking for a code that when the unprotect pword is put...

Hi all, I'm really confused by an issue i'm facing with 2 simple conditional format rules on a single cell (H6): Cell Value - Equal to - =0 - Green fill Cell Value - Not Equal to - =0 - Red fill When I apply these to H6, the cell is always Red regardless of value, even if I delete the not...

I am trying this formula =IF(OR($K7="2",$K7="3"),OR($<wbr style="color: rgb(31, 73, 125); font-family: Arial, Helvetica, sans-serif; font-size: small;">M7="LIL",$M7="BEG",$M7="GWY",$<wbr style="color: rgb(31, 73, 125); font-family: Arial, Helvetica, sans-serif; font-size...

Hi All I am hoping someone may be able to help me with the below I am trying to figure out a formula that will allow me to take data from 1 spreadsheet and fill into every 2nd column on another I want to copy data from lets say cell A1:C1 from one sheet and fill into cells A8, C8, E8 on...

I'm trying to create a macro that will, for a selected range (5000 rows), fill a cell with the contents of the cell above if the cell to the right is not empty/blank. Your assistance appreciated. Regards

Hi all, I am new to this forum and would love some help. I have a spreadsheet from work I have to fill in loads of data, some cells could be made easier as once I fill in the a column, it means I waould have to fill in a certain word in the c column. My headings are <tbody> Company Home...

Hello All, Is there a way to transform a cell's fill color into some sort of data? (I've inherited a bunch of worksheets where each cell has a number value and then the fill color says what the value is for.....the previous person then counted the values by hand and put them in another spread...

Hi to all of you, kindly require to provide me a VBA code so that to fill blank cells down in col. “D” with sequence number starting the first number 1001, 1002 and so on… Therefore, that my data begin from row “12”. I present below an extract of original and expected result. Many thanks in...

I have a spreadsheet with various inspection dates. I would like the fill of each cell to change based on the current date versus the expected date of the inspection. <tbody> Inspection Date Plumbing 4/14/2019 Electric 4/16/2019 Decking 4/18/2019 Final </tbody> What I would like is...

Hi, I would like to fill values into a column based on the percentages of that value in another column. For example, if the first value is 10 and it has 5% of the total, then if the total number of rows is 100, then the first five will be filled in with the value 10. In the example below I...

I'm. Novice user. I am trying to use Excel as a sales pipeline. I want to be able to put data into a cell, then have a drip down menu ( pending; sales ; on hold; sold etc.. Each of these will reflect a different cell fill color.

All, I am using the below current formula in an attempt to get the Average Time to Fill for a specific range of numbers: =SUM(M3+M8+42948)/+(N3+N8+358) BUT what I really want to do is get the Average Time to Fill using the following data: =SUM(QTR1_TA_TaleoData!U4:U170) PLUS the...

Hi, Searching for help to automatically fill missing information in column E where cells in column D match: <colgroup><col><col></colgroup><tbody> Control Number Control 50071879 50071879 50071879 50071879 Critical Spares for Girth Gear 50071879 50071879 50071879...

Dear Sir, How to fill combobox with values from another workbook in VBA Regards

I have a spreadsheet that I have one sheet that's used as a fill-able form. With a command button it will write specific fields into another sheet for a "data base" in columns A-Z. Each entry is identified with it's own specific ID in column A. What I would like to do in the fill-able form...

Is it possible to apply a fade from one colour to another on an active x command button?

Hi, I have these formulas in cell B3 for conditional formatting: =L3="Yes" (I set the fill color to red) =L3="No" (I set the fill color to green) How can I add the word "Closed" if yes and "Open" if no in conditional formatting? Thank you