sss

  1. S

    List of more then 3 months old Purchase Orders (PO)

    I have a list of POs in sheet 1 contained 20 columns with its information and date is in column F. I need list of more than 3 months old POs in Sheet 2 from row 2, in A1 Date with formula =TODAY(). Please help with formula Sheet 1 Supplier No. Supplier Name PO No PO Type Date...
  2. D

    Need A macro to inseet new sheets with given names

    I have following data in sheet1(Column A) <tbody> SSS SSS EXP KIK KIK KIK MIC SNS SNS TRF </tbody> I want to insert new sheets by giving above names to same work book(only one sheet for one name. here 6 sheets ) . column A is sorted . I use excel 2007 -in my lap...
  3. F

    Repetition of a function (VBA)

    Hello! I wrote some function and want to repeat it as many times as it corresponds to the condition. Function that replaces some part of a string to another by condition: Function fone(ByVal sss As String) As String Dim aaa As Long '--- Dim fff As Long '--- Dim bbb As Long '--- Dim ccc As...
  4. S

    Compare 2 columns extract unique / distinct records in 3 column without vba

    <colgroup><col><col><col><col><col span="2"></colgroup><tbody> Column A Column B Unique List with formula Autofilter 1 60122001 702995 702995 2 60122005 60122112 60122112 3 60122007 60122005 60122005 4 80112356 1458740 1458740 5 60122011 60122001 60122001 6 60122013...
  5. S

    sum substract records on the basis of duplicate records

    Hi Sir Thanks for your reply Please give me solution on the issue i am facing now. actually i have 1 sheet with 5 columns as follows. ------ A ---------- B ----------------C ------------------ D --------- E 1 ---A/c no.---bal 310313-----bal 310314---addition----Release 2-----121 -------1280...
  6. S

    substraction for subsequent row on basis of duplicate records

    Hi sir Please give me solution on the issue i am facing now. actually i have 1 sheet with 5 columns as follows. --- A ------- B -------------C ---------- D --------- E 1 ---A/c no.---bal 310313-----bal...

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