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

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...