filled

Hi Could anyone help me with the following? I would like to create a VBA that copies the first found value in Column A to the empty cells below - until the next filled cell in Column A occures. Then this value is copied to the empty cells below etc. - until there are no more entries in column B...

Hi. I have a table with a column A containing filled cells and empty cells. I would like to create a VBA that copies the filled cells to the empty cells below, and when a new cell value occures, this will be copied to the next cells below etc. until there are no more values in column B. Would...

I have an excel table and upon creating a new row, I want to add code to display a warning message if columns A, E or F are not filled out. What would be the code for this? The table is called tblCosting.

Hello can somebody help me whit this: I need a data criteria for : When i search in column AF the filter to copy from column AO TO COLUMN CP ( AO,AP,AQ,AR ETC) only the filled cells and for AO to modify the text to "#" and then to export only the last letters as you can see in this example (blue...

I have 4 columns A,B,C,D, Row 1. If any or all cells have data in them I need to color fill columns F,G,H in the same row. Subsequently if any or all cells in columns F,G,H have data in them I need to color fill A,B,C,D in the same row. I can get it get it to work if A,B,C,D have any or all...

<colgroup><col><col><col><col></colgroup><tbody> Holdings - - Duration N/A N/A N/A Meets Expectation N/A - - Meets Expectation Meets Expectation - - Meets Expectation N/A - - Meets Expectation </tbody> "There is N/A under Holdings and I filled N/A in next columns manually, before...

Hi I've got a dashboard with doughnut charts - lots of 'em and I need to be able to CF them based on the category NOT values. I am completely stuck. I have followed this: https://peltiertech.com/vba-conditional-formatting-of-charts-by-category-label/ and filled the cells with the colours I...

Hello! I'm working on a spreadsheet at work and my excel skills are terrible. The spreadsheet is used to log all the processed material and I want all the info regarding the material to be filled before they can sign it off with their signature. http://oi67.tinypic.com/20773a1.jpg As shown...

I know there's a way to do it but I'm clueless. I have a good bit of experience with Excel but one thing troubles me. How do I fill a cell with a number I click on in another cell? Example: I click on let's say cell C3. I want it to be filled with the number that's in cell H6. How do I do that?

Hello, I am having some difficulty wrapping my head around this. I know I can get a rough solution via pivot tables but I would like to explore the vba route as well. I am looking for a macro that would take the following table from sheet1 <tbody> Name hair nose eyes ears Donald high...

Ok I'm wondering if there is a formula, macro, program, or some thing I've never heard of that will have a cell if filled out with certain information search through files and open certain files?

I'm building a workbook for work, I have very limited excel knowledge (YouTube has been a great friend lol). Anyways my question is on sheet 1 column A every cell may not end up filled out so on sheet 2 row b I want it to not skip rows if sheet 1 does. Sheet 1 is my input sheet where sheet 2...

Hello to all, trying to get cells in a document if any date is filled in Erick

Hello all i'm hoping someone with the skills much greater than mine can figure this out for me. I have a rather large spreadsheet and in column A i have an incriminating reference number going all the way down to row 2000, Column A has been used as a drop down list on another tab. But the list...

Hello, I'm looking for a way to convert the YES input to the today date for example A3 is filled with Yes on Sheet1 sheet2 A4 should be filled with the Date of today. Is there a way to do this? If yes could you help me on the way? Thanks in advance Rgds, John

Hi guys, new here and forums, so apologies for naivety and if I break any basic rules to forum'ing. I am putting together a project management file and have multiple sheets that are auto populating between each other. All is working great, but the one thing I am struggling with is the below I...

How can i set a criterion to be equal to the day of a given month? In other words, the criteria range is filled with dates, and i need to sum those dates that have a particular day of the month. Thanks!

cell A1 has the month which has to be manually filled Cell A2, A3,A4... has the dates of that month, Can we have a formula where the dates are autofilled depending on the month mentioned in Cell A1 ( as some months will have 31 days and some 30 days ) Secondly in Cell B2, B3, B4.... we mention...

currently I have the code where I am making one cell mandatory when one cell is filled in as yes or no. I want an easier way to specify more than one cell to be mandatory when a certain cell is filled in as no code at the moment to make one cell mandatory 'Mandatory Dependant Questions If...

Hi I am trying to adjust an excel timesheet given to me. I have got a formula to calculate the broken turnaround, but I don't want it to calculate/display until two of the cells within the formula are filled in. Otherwise it auto displays a negative number till they are filled in. The formula...