empty cell

Hello everyone. I have a short question i really really need answering. A1 = 350 euro B1 = 500 euro C1 = B1-A1 (ok i do a simple SUM) but in case 1 variable "Say.... B5 isnt in yet so the box is blank..." How do i B2 = 450 euro C2 = B2-A1...

Hello, I'm new to VBA and I would like some help. I have a huge table and I'm interested in values on columns A, H and I. What I would like to do is to identify for each row if the cells on columns H and I are empty or not. If either cells on column H or cells on column I on a specific row...

I have a worksheet that goes over a 24hr period. Each hour a user enters their hourly count. One of my lines has a running daily count. I have =IF(K1677="","",K1677-K1676) as a formula. It takes the amount enters in the previous hour and subtracts it from the current hour to give the actual...

Hi all @ Mr Exel! I have a conditional formatting problem I can't quite get my head around and I'm hoping someone can help me out. First let me just say that I have been unable to find anything in the existing forum topics that resolves this, but I have been able to make some progress using...

Hi I want to know if there is a way to to fill empty cells with value left. i have this example: e d c b a 1 Y X 2 Y X I want to get this: e d c b a 1 Y Y Y X X 2 Y X X

I want my macro to loop through a series of files and, if all the cells B10:F10 in Sheet2 are empty, then delete row 10. I think my problem is that the value in each cell is linked from Sheet1 and the zero for an empty field is hidden (e.g. ='Sheet1'!B22 & ""); I have tried to delete for both...

Hi, I'm fresher in vba ,This particular excel is meant to be put in a share folder where team members are supposed to fill it. I want to popup a error message before saving. The requirements are 1.In a row , the highlighted columns must be filled(error msg before save if not filled) 2.select...

Hi! I have the following situation: In a large table I have conditions in column A and values in column B. I want to create a list of those values in B which meet a given condition in column A ("textjoinif"). To do so I basically have TEXTJOIN(", ";TRUE; IF(columnA="example";columnB;"")). Yet...

Hi all, i have been working on a creating a macro to find specific name in column G and wanted to check if the the cell right to the current cell is empty. if empty warning should be displayed. Detailed explanation: In my sheet in column G i have enter 'A' 'B' and 'c' randomly till row 1200...

Hello. I have a set of account program titles(B) and a dollar value(J) and for some accounts there is not a program title and the cell is blank or empty (not sure what definition fits this situation, there is no formula in the cell). I would like to sum all of the dollar values for which there...

Hi everyone, I'm new to using VBA and am in need of some practice. My manager often asks me to deliver data sheets in excel with all visible cells except the ones with data in them whited out as he thinks this looks better. I tried to write a code to do this for me but this turns all of the...

Hello - i would appreciate some help with finding empty cells in a row and then doing something when found. My code for testing is: Sub TEST_Find_EmptyRows_DeleteRow() Application.ScreenUpdating = False Dim r as Long Lastrow = Cells(Rows.Count, "A").End(xlUp).Row For r = 1 To Lastrow If...

Hello, I want your help. I want to use macro, that will search a blank cells in predetermined range and if cell is empty it should paste formula. I want to run this macro automatically in every 1 second. I searched procedures like this and tried to adjust to my excel, but something goes wrong...

I am trying to compute a score of players based on a macro with a series of checkboxes. The output values of the check boxes are pasted on the "Calculations" worksheet where the score is then computed in cell F18. I would like to copy cell F18 and paste it in the next empty cell of column D on...

Hi, so I'm really new to this and don't even know how to get started with this one. I have information in cell "AU" on sheet "Input Sheet". I want to move the information in this cell to the first available row in column "B" on sheet "Master Sheet" when I press a button. The information in cell...

I need a macro who returns ALL ROWS (of a table) containing ONE OR MORE EMPTY CELLS. <colgroup><col span="5"></colgroup><tbody> BEFORE FILTER Column A Column B Column C Column D Column E A1 3 YELLOW 22 11 A2 2 33 A3 BLUE 444 112 A4 11 GRAY 332 A5 22 GRAY 11 11 A6 FDSA...

HI, I want call values from sheet1 to sheet2 but on sheet2 i have "Date, Description, amount" which i will enter manually but if i enter anything on sheet1 "date description, amount" it should reflect on sheet2, but it should post it on next new line Im trying this from last 2 days not able...

Hello everyone, I am working on an Excel file with numerical data, of 2825 rows total. Every about two data rows, there is a blank row, and every about 50 rows, there is a total row. What I need to do, is to remove the totals and blank rows so I can couple this file with 18 others that range...

Hi, My data like this: some text some text some text value1 -empty cell - some text some text some text value2 My expectations of the macro is: 1. start from down to up. 2. copy value2 to three cells and stop while on empty cell 3. copy value1 to three cells Finally my data should be...

I have a form in which I assign some values With Me Let lBudgetID = .txtBudgetID.Value Let lMonthNo = .txtMonth.Value End With but if the fields txtBudgetID and txtMonth are empty, the code will fail since it's not possible to convert empty strings to numeric variables. How can I...