1. M

    Excel Transpose Help

    Hello, I a have a spreadsheet of about 1600 rows in which I need to get into another format.... <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Part ID Amount 79123 5233122 44.18 79123 11606476 95.1 79123 22346192 149.81...
  2. A

    Transforming Single Column data to Range/Rows

    Hi, i am new here. I need help for this, so I have a long list of data and I need to convert/transform in into comprehensible range or rows. Excel will start a new row after each blank in the column. like this: data: Ref#XXX Acct#XXX Desc Amnt Acct#XXX Desc Amnt -blank- Ref#XXX Acct#XXX...
  3. S

    Need help in use of IF function

    Hello Friends Today my Boss give me some work in excel but i face some problem in it. So i need your help. I have one excel file like below, <tbody> Amt % of Cash 48000 55 55000 65 32000 32 56000 80 110000 78 130000 90 250000 66 260000 74 </tbody> I have...
  4. A

    How to Calculate discount for multiple items

    <tbody> Items Per Piece Qty Disc % Apple 10 2 4 Mango 15 3 5 Banana 12 5 2 Orange 18 4 6 Grapes 20 5 4 Pineapple 26 7 2 </tbody> Total Amt without Disc = Total Amt with Disc = how can i get both amounts in 2 different cells. Thanks Amit
  5. L

    Formula to apply amount to array of cells until consumed

    with the data below <colgroup><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody> A B C D E F G H I J Reported Amt Balance Reported Amt On Acct Cust Balance (calculated col D - Col E ) Invoice Amt Due from transactions Fwd Aged Curr 31-60 61-90 91-120 121+ $...
  6. B

    Help with an If problem in vba

    Hi all, below is a code I use to add a quantity to a "Sales" sheet from a matching name on a "Purchase" sheet. What I need to know is how do I get it to not do it if the cell in column M of the "Sales" sheet is > ("0") Sub Match() Dim NextRw As Long Dim rCl As Range Dim Rw As Long...
  7. D

    VBA extract data based on between dates

    hi, i would like to extract some data based on the date (Between dates) using userform (date start and date end) example data below SHEET1 <tbody> A B C D E DATE REF CODE AMT NAME 1 JAN 2, 2018 AAA 111 25.25 STEVE 2 JAN 7, 2018 ABC 123 654.00 JOHN 3 FEB 6, 2018 DFS 364 215.40 MICHAEL...
  8. J

    # Value Error - if and statement

    I have a if and statement that I am receiving a value error on. If I just use 1 if statement it works properly. When I add a second if statement, I receive a #Value error =IF(AND(C3="B",I3="YES"),"Min. Amt / 286","") + IF(AND(C3="W",I3="YES"),"Min. Amt / 286","")
  9. S

    additional criteria adding

    I have grid as below and comparing column number A,D & E amount is arrived but now I want to add additional criteria column B & C grid <tbody> SS DESG ACH% FROM TO AMT AA SS1 100 100000 158999 50000 AA SS2 100 159000 217999 65000 AA SS3 100 218000 276999 80000 AA SS4 100 277000...
  10. L

    Formula to arrive at balance amt.

    Dear Team, Is there any formula which gives me the desired out of col D ? col. a col. b col. c col d Name |total |amt used |Bal. available a |500 |100 |400 a |500 |200 |200...
  11. K


    I have two worksheets that each need different headers added to row. When I use this: Dim headers() As Variant Dim wb As Workbook Application.ScreenUpdating = False 'turn this off for the macro to run a little faster ActiveWorkbook.Worksheets("AnalysisEnd").Select Set wb = ActiveWorkbook...
  12. K

    VBA to insert a blank row

    I need to insert a blank column, then a blank row after a5 and insert a header with the following data: A5= Merge Cells, B5=Site, C5=Ins. Co., D5= Chg Amt, E5= Pay Amt, F5= Adj Amt, G5=Ref Amt, H5= Bal Amt, I5=Amount Billed, j5= CA%
  13. K

    Copy sheet and add Location number

    I am trying get a macro to look down column A and each change in site name add their location number underneath it. <colgroup><col><col><col><col span="2"><col><col></colgroup><tbody> Chg Amt Pay Amt Adj Amt Ref Amt Bal Amt Albuquerque 60 Totals For AETNA $51,896.00 -$31,204.59...
  14. M

    VBA to distribute data monthwise based on start and end date range

    Dear Sir, I have 2 sheets . Sheet1 contains 5 columns of data as below; <tbody> Unique No S Date E Date Amt Type 1 01-Apr-17 30-Jun-17 100 A 1 01-Jul-17 31-Mar-18 150 B 2 01-Apr-17 30-Apr-17 100 A 2 01-May-17 31-May-17 200 B 2 01-Jun-17 30-Jun-17 300 A 2 01-Jul-17 31-Jul-17 400 B...

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
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 "".
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