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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.