non-blank

Hello! Is there a way to automatically add a comment to a cell within a certain range if the cell has content? Here is an example of what I mean...(I cant share the actual content, so hopefully this example explains my idea) I set up a calendar to keep track of food that is eaten. If a person...

Hi all, I have developed a macro that auto-fills selected cells based on an inputbox. I am in need of assistance to finish it off. Sub Initials() Dim r As Range Dim c As Range Dim name As Variant Set r = Application.InputBox("Select cell(s)", "Demo", , , , , , 8) r.Select name =...

So this is only some test data to prove the concept. Essentially I have a data set that will contain duplicated values in one column which I need to do a look up on with either blank cells or a unique identifier in another column. If the desire look up value is present in the first column, I...

Hi, This might be easy but I don't know how to look for the very first non-blank cell which pertains to the header on an entire sheet. My colleagues won't be giving me a file where the header is always in ROW 1. I know a code that can look on the very last non-blank cell in a column using a...

Hi all, Would greatly appreciate it if someone could lend a hand with a problem I have. I have a range, A9:G200. I'm looking for non-blank rows in column G. When a value exists (dollar amount), I then want that value displayed in N3, and I want the associated value from column A displayed in...

Hello, I need to mark consecutive more than 5 Non-Blank cells in excel like given below. It will be good if this can be done in VBA Macro. <tbody> A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD 2 5 3 4 3 3 3 4 3 3 2 3 3 3 3 3 3 3 4 4 4 4 1 2 3 4 5 6 5 7 7 8 8...

Hello, I'm new to VBA and can't find a workable solution to my issue. I'm trying to insert my custom function adjacent (0,1) to each non-black cell on a worksheet. So if I have a string in cell D3, it will insert MyFunction() into cell E3. And loop through to do this for every non-blank cell...

I am trying to create a code that does two things: First, the code will search for a column that contains a given text within the worksheet. Afterwards, the code will search for the row with the last non-blank cell in the worksheet, while remaining on the same column as 1. As shown in the...

I need help for a lookup formula to find non-blank values in a dynamic range. Here’s a sample of the spreadsheet below. The # of rows between each variable in column A can vary, so I’m having trouble devising a way to find these non-blank values. <tbody> A B C D E F G H I J K L M N O P Q R...

Hello Community Members, I have searched the forum for the answer to this conundrum, but cannot seem to find it. If you know the answer (or where I can find the answer) to the following scenario, then please post below. Here is a simplified version of the excel spreadsheet that I am working...

Hi All, I am stumped when trying to create a list of the non-blank items in a row. I have a table in a spreadsheet, the rows represent a list of clients, the columns represent months of the year. The table is being used to track client visits (if there is a visit in a particular month, the...

I'm trying to set a range equal to the nonblank cells within range I81 and I111 (number of no blanks changes). Cells with data in are always at the top of the range with no blanks separating. At the moment I am setting the range by manually altering the last cell in the range any ideas how to...

I am looking for some vba code to help me copy the non-blank cells in the following section (small exert of the total list) and copy them to a new column WITHOUT BLANKS with the accompanying date. I am having a tough time doing that... <TABLE style="WIDTH: 104pt; BORDER-COLLAPSE: collapse"...