fill

Hello smart people, I have a large spreadsheet i'm using for people's names/addresses/phone numbers etc I have to add more constantly when a new download becomes available. However, on my initial sheet I fill the row (example, they don't want to be contacted is red, left a message yellow) I...

Hello, I need to fill all blank cells , or = 0 in my selection with "1" Thank you

Hi In one worksheet i have a table with 3 column ABC column A is text that fill manualy B is number fill with vlookup and C is percentage of column B so beacuse of some row column B is zero i need to export a new table in column E to G that only show the row of previous table that column B is...

Afternoon All, iv searched quite a bit but cant find a work around for the formula i am trying to create and am hoping some one could point me in the right direction. i am currently using the the following formula: =SUMIFS(Sheet1!D:D,Sheet1!G:G,"billy",Sheet1!E:E,"Smart") this works great...

The pic1 show original, and the marco will auto fill down as show in pic2 (yellow)

Hi guys, I found this VBA code (here: https://www.extendoffice.com/documents/excel/2129-excel-highlight-active-cell.html) <code class="vb keyword">Sub</code> <code class="vb plain">Workbook_SheetSelectionChange(</code><code class="vb keyword">ByVal</code> <code class="vb plain">Sh </code><code...

I have two columns, one with dates and one with values. Such as: <tbody> 8/4/19 1 8/5/19 5 8/6/19 4 8/7/19 4 8/8/19 7 8/9/19 4 8/10/19 4 8/11/19 4 8/12/19 3 8/13/19 4 8/14/19 3 8/15/19 2 8/16/19 4 8/17/19 4 </tbody> In a separate cell I want to sum up the first...

Hello, I have a vba code that will fill a series from A11 down however if there is only 1 item (A11) I need something in my code that will recognize this and not give me an error but continue with my macro. What could I add to this line to have that happen? ActiveCell.FormulaR1C1 = "1"...

In cell "B1" I have a data validation (LIST). The validation list consists of the data "A,B,C,D,E,F,G" (within the drop-down). I want cell D1 to auto-insert data from the drop-down list in "B1" For instance... If I select "B1" with the data "A", I would like to have "D1" fill with the word...

I am looking for macro which will solve my issue. I have planning of machines per days, but on top of that I would like to have "overview" per machines (if there is no color fill in machine capacity planning then that means it's available for planning, otherwise is at machine planning is fill...

Hi Everyone, I want to be able to open two XLSM doc from a folder. The Two File Names are in sheet "Welcome" Cells "B11" and "B12" but don't or might not have the .xlsm ending. the filepath is in cell B10 and will look like this "C:\Users\Tonypc\Downloads\New folder" I would like to first...

Hi, i need a help. I need a formula for the calculation for the below data <tbody> <tbody> Location </tbody> <tbody> Vehicle No. </tbody> <tbody> Transport </tbody> <tbody> Weighment </tbody> <tbody> Charges </tbody> <tbody> Total </tbody> <tbody> Credit...

Hello, I am having trouble figuring out the code to do the following: If the data in column A says "Internal" and column B is empty then I want column B to fill with: cell.Interior.Color = 16776960 If there is data in column B, I don't want it to do anything. If the data in column A...

B2:B9 is +ve Integers C1 is Value Output Required in D2:D9 as TO FILL VALUES STARTING D2 & Considering range B2:B9 TOP DOWN Thanks in advance Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH...

I want to conditionally format cells in the range A1:A200 that contain any string. If a cell is blank, no formatting should apply to that cell, but once any string is entered in a given cell, that individual cell should have its fill changed. Any ideas?

Hi, In B4, I have formula =B6-SUM(B7:B8) In C4 I have formula = (B6-SUM(B7:B8))/B6 (formatted %) Where B6 = 1,000,000, B7 = 200,000, B8 = 400,000 I wish to achieve the following: When C4 is 0%-100% a data bar in B4 for an equivalent % fill When B4 is negative to show 100% fill I can't...

Hi, Is there a good way to auto fill the Template sheet customer information in yellow from the Customers sheet based on the ID entered in cell I6? Thank you Excel WorkbookBCDE6Estimate For7[Contact Name]8[Company Name]9[Street Address]10[City][ST][Zip Code]11[Phone]12[Email]Template Excel...

Hello all, I've got a load of pivot tables on a sheet and have coloured all the surrounding cells white to make the page look better. However, when I use a slicer to change what the pivots show, when they reduce in size the cells left showing have no fill. I've manually filled them and also...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Columns L:N, I got numbers fills for the character 1, X & 2, my query is to fill colours in the columns C:I as per numbers of character, for example... </SPAN></SPAN> M6="X"=1 fill C6=1"X" with green fill and white font.</SPAN></SPAN> M7="X"=2...

I have a rectangle with an image fill on sheet 1. On sheet 2 I have images that aren't a shape, they were just drag and dropped into Excel, but they are located within the cell borders I'm trying to figure out the code to take the image from a specific cell on sheet 2 and replace the shape...