excel10

Hi, I have coded a macro that effectively copies a dynamic named range to a sheet called Sales chart. The working named range, called ItemsSold, is a single column consisting of uniquely filtered data. My problem is the second named range; I want it to look up the source data, called Sales...

I have a spreadsheet with all of my clients' information and I have conditional formatting rules that make rows have red font and/or dotted backgrounds depending on conditions of their portfolios. {they are as follows: ='As of 09-30-13'!$I2>('As of 09-30-13'!$G2*1.2) and ='As of...

I have a macro, which I want to run on all the sheets of my workbook. The code is pasted below: Also I have a problem, I need the macro to display to me the value of the row,column value I am selecting, but its not doing the same. Please find the macro and advise...I need to do this program...

Mr Excel, Pls help me. I am makimg a userform that fills all manual sales bill details into the form. it is working fine all controls are precise. But i overlooked one fact ,one bill can have upto 20 items with different unit price. i dunno how to incorporate these onto the worksheet under one...