#excelhelp

  1. K

    I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code....

    I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code.... i was Create MODULE and put this VBA code , So Amazing Trick to ,make Print TO PDF with Duplex (Both-side),,,,, Kindly Provide set VBA code For both page Margin...
  2. K

    HOW TO LOCK COLUMNS ??? (we need Lock Highlight Columns)

    @ HOW TO LOCK COLUMNS ??? I try Column " A" & "B" FIX & Lock ....... This "HSN CODE " IS EVERY TIME FIX & SAME IN BILL ......... Problem : 5 and more people use this File, So my was Change every time , i tried ... We Need lock Columns lock trick .. pleased solve my Query.
  3. K

    Hide Row with Zero value with Entry

    Hide Row with Zero value with Entry
  4. T

    Return a value based on the type (new or existing) and value (from a range of values).

    <tbody> Range of Values New Existing 1 to 10 10% 8% 10 to 50 3% 2.5% 50 to 100 .8% .4% </tbody> <tbody> Type Value Percentage to Return (from the New/Existing columns above) New 40 ??? -What formula to use??? Existing 40 ??? -What formula to use??? New 60 ??? -What...
  5. M

    How to apply if and sumifs function in this case

    Hello, I need to combine if and sumifs function for this case that i have. (according to my lecture) The case is : to fill product cost column (Sheet 1) , they asked me to put the sum of unit price ( in Sheet 2) if the product type (Sheet 1) is Manufactured. If the product type is Bought-in...
  6. W

    Excel Mail Merge with Outlook

    Hi, Is it possible to create a form on excel to have it mail merge with outlook and be sent out to clients ? I.E. I want to create a document in excel where you can answer questions and those questions get answered for us and put nicely back into excel. If anyone know how this would be setup...
  7. E

    If Or Or Or Statement Then

    Good afternoon, I need to write a formula that does the following: If cell is (#### or #### or any letter combination) then put "MA" if cell is (#### or ####) then put "SC" #### stand for a combination of a few numbers. Haven't been able to figure it out. Thank you!

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