filled

Morning All, I need your help on my query. This is my query. I have 3 spreadsheets in a workbook which the first spreadsheet is the data entry spreadsheet and the other is the quotation form to fill automatically from the details from the first spreadsheet. The 3rd spreadsheet is my register...

Hi: I need to fill a large worksheet as follows: all blank rows that follows a cell with a value should be filled with that cell value. For example in column C below, C5, C6, C7 should be filled with value in C4. Value in C8 must stay as is but C11, CC12 must be filled with value in C8 The...

Hi guys, I’ve encountered a difficult task. There are two sheets (“sheet1” and “sheet2”) In sheet1, Column A1:A100 are filled with 5 names (some are blank cells) In sheet2, there are some cells required to be filled in (I.e.,A13, B23, C18, D50, E5). The value to be filled are exactly the five...

Hello! I have a formula that makes a division and in some cells it shows #DIV/0! because it tries to divide by zero. That's fine, but I just want these cells to be filled with N/A (not applicable) or zero or a dash or something more pretty than #DIV/0! Any idea?

Hi guys, Hope you can help with this - I need a formula for column I 'ActiveIngredientG' If the cell in column G 'Antibiotic' contains the value 'Florocol' I would like the corresponding cell in column I to equal the value in column H 'QuantityProductG' divided by 2. If, however, the value...

Looking for a to solution to pull data down into blank cells below until no blank cells remain. I could obviously just grab each cell and complete this but I've got 600 unique data pieces with varying numbers of blank cells below which need to be filled. Thanks so much. <tbody> AutoZone...

Dear all, Wanted to understand the Loop Until in Copy & Paste. Example: Data are available in Sheet1. Column A There are numbers available in various cells - Some are filled in and some are blank. Requirement is to copy 1st filled in cell in column A and then paste it below in all blank...

Hello all, I have question I want to highlight cells to edit but not print in color en not send by email before cells are filled. I do not want to us black and white in the printing setup, because some features on the sheet must be printed in color. Hope somebody can help Thanks Steel010

I need some help with a nested formula. Here is what I need: If cells, C10, C11, C14, C15 are populated then "Ok to save","Not OK to save". All 4 cells need to be filled before it says it is OK to save I appreciate anyone's help. Have a great day! Brian

Hi I am looking for a macro that copies the formula in cell A1 and autofills row1 till the last filled column in row2. Sub AutofillColumnsInRow1AccordingToLastFilledColumnInRow2() Dim lastColumn As Long lastColumn = Range(Columns.Count & 2).End(xlToLeft).Column Range("A1").AutoFill...

Hi, -I'm tryingto create a spreadsheet which enables me to filter a list of salariesso that I can display the maximum wage for employees after an annual increase.I’ve tried using the VLOOKUP, but unfortunately I can’t get it to work asintended. I’ve used the function in the example below...

Need to apply conditional formatting to a cell containing a date e.g L6 = (08/06/2019) Criteria are: If L6 is 2 months or less away from todays date & If M6 is Blank then L6 should be filled red. If L6 is 1 month or less away from todays date & If M6 is Blank then L6 should be...

Sorry I am not sure where to begin even asking for help, let alone explaining what I am trying to do. The Process I have a form made on excel that requires both text and numbers. The form has two variations. Form A starts a new Request and can yield multiple tracking#s per request. (seperate...

I am using the following macro to place a "w" in column M (9) of the target record of a worksheet when colmun D gets the entry "Filled". Dim lastrow As Integer lastrow = Range("D" & Rows.Count).End(xlUp).row 'If Status is "Filled" place a "w" in Results 'Range("D2:D" &...

Hello all, I have a spreadsheet that has data from B3:AA15000 that is filled with numbers. I also have a drop down box in cell A1 where a logical (i.e. >,<,<>) is chosen, a drop down box where a data type is chosen (A,B,C,D, these data types are column headers for columns X:AA) in cell B1 and...

Hello, I would like to know if there is anyway to "lock" a cell if the previous cell isnt filled. In other words, I have to fill a file with multiple cells. If I accidently forget to fill one cell and pass it up, I want Excel/VBA to tell me that I have forgot to fill a cell. I have a small idea...

Requesting help for > VBA to check range (C2:G1001), The Criteria: if C2 and D2 are filled (not empty) then G2 must be > 0 to have a complete entry, if criteria was met then it is "legit"; the cursor should stay at G2 until it is filled with a number. To exit such checking, it is "legit" to...

Problem: As the number of rows in my table in the Sheet("Table") changes according to the different tenor(number of years) and frequency(Annual, Semi, Quarterly), I need a function for my button "Copy" in my Sheet("Master") to copy the table in the Sheet("Table") till the last filled row (as...

Hello there, I have a spreadsheet with already filled data/formulas. I want to add an if statement to ensure if the reference cell is blank it shows the cell blank until a value is filled.. like: =IF(ISBLANK(E24),"",F24/G24).. I know how to do that. However, I don't want to go through every...

Generally, the question is: Can the Linked Cell property of an ActiveX control be dynamically changed? Specifically, what I am trying to do relates to this: I have 2 Worksheets, the first, Sheet1, with a table A3:D1000 where Col 2 is filled with a bunch of different "First Names" but some...