excel10

  1. C

    How to loop through all rows of a range?

    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...
  2. E

    Conditional Formatting creating unwanted rules and altering existing ones.

    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...
    • excelinlife
    • Thread
    • conditional conditional format excel10 formatting unwanted rules
    • Replies: 2
    • Forum: Excel Questions
  3. I

    How to run macro on all sheets

    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...
  4. A

    Userform with macro to fill manual PO details

    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...
    • aditi7
    • Thread
    • bill entry excel10 macro merging rows userform
    • Replies: 0
    • Forum: Excel Questions

We've detected that you are using an adblocker.

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.
Go back
Back
Top