blank column

Hi there, I have several macros which have been written individually which run simple formulas and return the data to the active column. Eg. Macro 1 enters a simple formula in cell X2, to return the result, whereby column X is the first blank column at the end of my dataset. To avoid running...

I have a calculated field Blank:=BLANK() The only purpose of this field is to insert a blank column in my pivot table. This works fine. But when I create a set of the pivot table the blank column disappears while in the MDX statement it shows the blank column. I formatted the blank field with...

i would like to paste my manually copied columns to another sheet next to an empty column. and start paste on column E if not empty using a command button as trigger like if i manually copy column B from sheet1 and paste it to sheet2 column E if not empty.

Hello all, long time lurker first time poster... This website and others have been really helpful to me in the past and I'm looking for a little more help now. I am looking for vba code that will allow me to copy cells in columns A and B that correspond to empty cells in columns C, D, and E...

Hi guys In my project, I only want a certain If command to run in a particular column has at least one non blank cell in it. So if column J has a value in it, then I want this If command to run. I tried the following code but got runtime error 13: If Columns(10) <> "" Then If... Then...

Hello, I have a pivot table issue with blank columns and rows in my pivot table. How can I remove this WITHOUT the filter in the pivot table? the "-" indicate a completely blank cell. As you see, the column header and rows are blank. <TABLE style="WIDTH: 431pt; BORDER-COLLAPSE: collapse"...

I have a pivot table a column header containing 3 values to indicate if someone has completed an assignment. Specifally, the values are (1) complete (2) in progress (3) not started. The row variable is a specific line of business groupsand provides completion counts. So, the table tells me...