populated

Hi Everyone, I'm wondering if there is a way to populate a DLookup in a cell based on the population of another cell in the same row? For example, Cell D2 is populated with a Scan as text. When that happens I would like to populate cell H2 with the formula below and then repeat that in each row...

Hi Everyone, I have a worksheet where cell B2 is populated by a handheld scanner as text, cell C2 is a date that is keyed and cell D2 is an invoice that is keyed and formatted as text. What I am looking for is when B3 is populated, cells C3 and D3 are populated with the same date and invoice...

<tbody> A B C D E 1 Player Game 1 Game 2 Game 3 Game 4 2 3 Total Total Total Total 4 </tbody> Morning people Is there anyway I can get Excel to automatically enter a new row once I've populated A2:E2? The behaviour I'm looking for is for the current row 3 to...

Hi All I have a simple code blow that i have in my excel. As the Value of F4 changes from time to time, the values to be populated in the Range changes. But i find that if once a value has been populated, the new option cannot overwrite the cell. Ie, if Plan A was chosen, and Cell G5 is already...

Hi. I have a spreadsheet where cell D26 is populated with 2 outcomes “workable” and “non-workable” as the result of a vlookup against 2 other cells. I want to hide rows 27, 29, 35, 37, 38, 39, 56, 57, 59, 60, 61, 63, 65, 71, 78, 79, 80, 81, 82, 83, 84 and 86 If workable is populated, and leave...

I have several Comboboxes on a user form that are each populated with Named Ranges. I would like to put a button next to each combobox so that If a user types something into the combo box that is not in the list They could click the button and insert it into the list. Currently all the lists...

I have several Comboboxes on a user form that are each populated with Named Ranges. I would like to put a button next to each combobox so that If a user types something into the combo box that is not in the list They could click the button and insert it into the list. Currently all the lists...

I am trying to compare a date against NOW() and AND it with a statys field (Complete or In progress), depending on the result a priority field is populated. What am I doing wrong with the statement??? =IF(((AND(NOW()<>E5,F5="Complete")), "NONE", "HIGH"), IF((AND(NOW()<E5,F5="In progress"))...

Hi, I have the code below which one has to run it manually. I need that if cell B9 is populated, it runs automatically. Sub insertusername() Range("A1").Value = Application.UserName End Sub Thanks in advance

Hi All, i have the below code which runs when a cells is populated (but only works when manually populated). i have cells that are either manually populated (which it words fine for) and some that are populated via a formula (which is does not work for). do i need to change the trigger to...

I have a simple worksheet that I'm looking to use to track entries that require follow-up. If R1 has a populated DATE, I'd like to hit a command butto that will print that row (and all rows that contain a date in the R1 cell),cells A1 thru X1 on each row, to a new worksheet within this workbook...

Hi, I'm struggling to create a function that will look across a range of 10 cells. % will be populated with letters such as "M". They following works if the first five cells are populated but I need a function that will ignore the blank cells. It also looks at the persons name and gender but I...

Hi, With range (C2:C10) I want to restrict input For example: If C2 is populated Can input in C3 Can't input in C4:C10 Any help appreciated

Hello, I need help with a formula. i need to show YES if Cells C1, D1 are empty, and NO if they are populated ( C1 & D1 would contain date . Thanks in advance

Good morning all, I am after some help with VBA to perform the follow tasks Find the last populated cell within range C4 to C174 Copy the last populated row from A to H Paste values @ A174 to H174 Delete the original range copied Delete all rows based on C being blank in range C4 to C174...

This is probably a very simple request, but I am stumped. Hopefully someone can lend a hand. On a main data sheet, I have a populated row of data (header). Below the header, I have certain cells populated with data. I want to do a look up on a separate sheet and match the 'header' and...

Hi folks, I'm using =IF(COUNTA(D7:AC7),INDEX(D$2:AC$2,MATCH(TRUE,INDEX(D7:AC7<>"",0),)),"") to find the header (in D2:AC2), but I can't get my head around how to use this, or another code, to find the header for the LAST populated cell. I used this Stack Overflow article to find the above...

I am trying to figure out if a formula can be used to control the format of a cell For Example If C3 or F3 is populated, then, make the contents of B3 bold Is there a way of doing this?

Hi , Wondering if anyone could advise me on a more efficient wayof coping & pasting data between two sheets. Below is my code Sheets("SCF_File").Select Range("G2:G10000").Select Selection.Copy Sheets("Running File").Select Range("E" &...

Hi, Hoping some one might be able to help me with this one: Is it possible to use some form of look up formula that will return the value of the last populated cell in each row in a table, when the number of populated cells in each row in that table is not the same? Is it also possible to...