blank cell or cell value

Hi, I have a sheet in my workbook that compiles info from 4 other sheets using formulas to call up cells from other sheets, for example: ='STEAM (SH)'!D3 . this leaves me with rows that have info in every column or just one column at times. I want to be able to quickly hide the rows that have...

Hi Excel Gurus, I'm working on an macro project and almost done. I'm just having a problem on this: I have 2 excel sheet, one is working file and the other is database. What the macro needs to do is to check the cell with blank category (in working file) and add below column data in the...

Hi. I am beginner to excel vba. I would like to ask simple question that I've been stuck for few days. So far, I have two columns, for example column L and M. I have to loop all column L and find the blank cell. If there are a blank cell, then, it will copy next value in column M. Roughly, the...

Hi, I have a formula in cell picking up running values. But when nothing is there, its giving me a number. I want it to show blank. I assume because there is a formula in that adjacent cell. this is what it shows. Where as E is the customer its picking up from column A, and F is the amount of...

Hey, all. New to the forum and really appreciate what you all have here. I've looked around the internet and several other forums for a way to increase the time it takes my code to add data to tables. I have an excel database that stores all the data for projects that I've worked on and will...

Hello, I have a multiple tab spreadsheet. The following formula works perfectly with one exception: =Sheet1!C11+Sheet2!C11+Sheet3!C11 The issue (exception) is that it returns a zero even when C11 on Sheet 1 is blank. If C11 on Sheet 1 is blank, then I need the above formula (or some variation...