blank cells

Hello, I am trying to take a range of cells and reformat them in a different sheet that gets rid of the blank cells. I can't figure out how to do this with a macro since the names of what is in the range will differ and the number of cells with text in them will change as the macro updates.

Hi, I have vba which works very well, it copies down to the last row and will paste on the first empty row, however when it is copying it skips blanks, does anybody know how my code could be modified so that it will copy and paste blanks? I'm copying and pasting from multiple workbooks so that...

Hi, To start off, my question is very similar to the one at this location: http://www.mrexcel.com/forum/excel-questions/553169-concatenate-row-variable-number-columns.html This is the provided solution that I've been trying to use: Sub ConCatFromColumnC() Dim X As Long, LastRow As Long...

hi! I am using Excel 2010. BTES worksheet: acct# Oct-13 Nov-13 Dec-13 13245 850 12458 850 45864 12385 1500 MainList - F2= (current month) Based on the current month (which I planned on typing in) on the MainList worksheet I need to count how many blank...

I need to highlight cells that must be filled in. It is easy to do when you are only looking at the ActiveCell but I need several cell to be highlighted if they are blank and the main Category has been filled in. Example: A1 = Main Category B1 to E1 are sub categories. If there is nothing in...

I have to calculate the days after we receive a notice to when we have to reply. I have two columns column A contains a date when the form was sent out but sometimes I don't have the date the form was sent and I have to go by when the form was filled out (column B). my formula in column C is...

Hello, I am a manager at a martial arts studio who created the mega attendance sheet from hell...Long story short it accounts for many scenarios that come up in the business. It records attendance for the entire year (which is actually necessary for things like end of year awards). We have...

I have an Excel file with about 30,000 cells in it. Here's an example of what the file looks like here. And I need it to be sorted like this. To explain further, If someone's name(B) or plan number (A) has blank cells AND additional names under the "Beneficiary Name" column (F), I want these...

Hello all, I hope for this to be my last inquiry on this topic for the immediate future. I have columns A-F which are general formatted cells. These cells have Alpha and Numeric strings. In each of these strings is an '. Does anyone have a non-VBA solution in order for to be rid of the leading...

Hello all, Although, I was working this into a Macro, I was wondering if anyone had a non-vba solution as well? Basically, I have cells with " ' " due to an extract from our ERP system here at the office. As you can imagine this is quite irritating. My question: Is there a way to identify...

Hello all, Although, I was working this into a Macro, I was wondering if anyone had a non-vba solution as well? Basically, I have cells with " ' " due to an extract from our ERP system here at the office. As you can imagine this is quite irritating. My question: Is there a way to identify...

On a spreadsheet I have a "Save" button which saves the sheet in a specific place determined by the contents of 3 cells. C4 = Date, E4 = Venue, I4 = Name These three cells determine the location and name the file will be saved; c:\Venue\Year (from C4)\Month (from C4)\Name (a combination of day...

I work with a spreadsheet every week to input values and subtotal them. These values change constantly and instead of going through and manually deleting each row in a 100+ row spreadsheet to be able to import into another program, I'm looking for an quicker way to keep my data in order but...

Hi All, I don't even know if this is even possible but here goes... This is based on an accommodation type of business for a mine site. On Sheet1 I have named a few cells being: StartMonth = 01/04/13 EndMonth = 30/04/13 Week1Start = 01/04/13 Week1End = 07/04/13 Week2Start = 08/04/13 Week2End...

Hi everyone, I've got the following formula and can't find a way to ignore the blank cells if not data is entered. I'm trying to avoid having double comas when no data is in one of the cells. using formula (=CONCATENATE(A1, ", ",B1, ", ",C1) <tbody> Column 1 Column 2 Column 3 Formula result...

Here is a sample of the data I am using. Excel 2010ABCD1Myfolder58002Bin18003de400004en500005Random150436Random25044Sheet1 I am importing it from a text file that is pipe delimited. The data represents a folder structure. Items in the same column are on the same level, those that are 1+...

When accounting software (in my experience) outputs an account in XL format, I find that the spaces are not necessarily spaces. It's easier to explain if I give you an example. Here is a small sample of the output. https://www.dropbox.com/s/egh15zk5kon61nz/Blank%20cell%20problem.xls Columns A...

Hi, going crazy with trying to do what should be a simple thing. Would anyone know the code to give a message box if any cell within a range is blank? The code I have tried is below but it doesn't work. Private Sub CommandButton1_Click() If ActiveSheet.Range("A2:AY2").Value = " " Then...

I've been struggling to remove the empty text string created when I use "" as the false value in formulas. I think I found a way but I wanted to see if anyone has a more elegant solution, and one that would work as a macro. I use the "if" formula to populate many of the cells on my spreadsheet...

What is the formula that I can use in Column C? I don't want to have to change any cell references as this data changes all the time so it will have to be smart enough to detect blank cells in column B and then place the subtotal in column C. Also, the subtotal in column C is only for a...