Search:

Type: Posts; User: GirishDhruva; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: How can we use Multiplication in Sumproduct

    The values in that column and the positions will vary but the column names remains the same, so as of column name i need to perform the calculations
  2. Re: How can we use Multiplication in Sumproduct

    My column headers would be fixed as i have provided that column headers in my workbook
  3. Re: How can we use Multiplication in Sumproduct

    It will be differed every week so only i am trying to perform calculations based on Column Header
  4. Re: How can we use Multiplication in Sumproduct

    Oh sorry, those are C1(row-1,column-C),D1(row-1,column-D),E1(row-1,column-E)..........
    I think u haven't seen my workbook, once check my workbook which i have shared.

    Regards,
    Dhruv
  5. Re: How can we use Multiplication in Sumproduct

    What exactly is your question?????
  6. Re: How can we use Multiplication in Sumproduct

    Yes, 1st row contains headers.

    If i am not wrong by using this SUMPRODUCT we could reduce the looping(instead of looping in every cell and calculating i tried using SUMPRODUCT)
  7. Re: How can we use Multiplication in Sumproduct

    =ROUND(SUMPRODUCT(D2/31*G2)+SUMPRODUCT(C2/H2*E2)-SUMPRODUCT(C2/H2*F2),0) ,This formula can be applied in excel sheet directly but i am trying that in vba so

    With Worksheets("Pivot")
    ...
  8. Re: How can we use Multiplication in Sumproduct

    My first row contains headers and from that headers i need to find the value using the formula , but each and every time my columns might be varying so i need to find the columns through the column...
  9. Re: How can we use Multiplication in Sumproduct

    Hi,
    Here i trying to find the columns by column header and from those columns i need to apply the below formula in last empty column
    This formula was done manually but i am trying this in VBA
    ...
  10. Re: How can we use Multiplication in Sumproduct

    Hi steve the fish
    Here below i have shared my workbook
    https://app.box.com/s/p36n4dk08znk2g57iftswh5zz2q4k1pu

    Regards,
    Dhruv
  11. How can we use Multiplication in Sumproduct

    Hi Everyone,
    Here i am trying to multiply a particular columns using SUMPRODUCT but its giving me the output as '0'

    Can i know why is this happening???



    With Worksheets("Pivot") ...
  12. Calculating based on values in second sheet

    Hi Everyone,
    I need some suggestions how i can solve this Using VBA

    This is my workbook which i am working in
    https://app.box.com/s/1rsdix4y6b7k4d9vnu3796g37b065omg
    In the worksheet("main"),the...
  13. Re: How can we combine two PDF into one Separate PDF and save in particular path Using VBA

    Hi John_w ,It worked and thanks for you valuable information and suggestions and sure from now i will always use Option Explicit.

    Regards
    Dhruv
  14. Re: How can we combine two PDF into one Separate PDF and save in particular path Using VBA

    Hi John_w it's throwing me an run time error 424 as object required in below line


    If primaryDoc.Save(PDSaveFlags.PDSaveFull, PDFs(i, 3)) Then

    even i tried with


    If...
  15. Re: How can we combine two PDF into one Separate PDF and save in particular path Using VBA

    Hi John_w thanks for your reply, I am out for next two days so once I reach back I will check and confirm you

    Regards
    Dhruv
  16. Combine two PDF into one Separate PDF and save in particular path Using VBA

    Hi Everyone,
    Here i am trying to combine two PDF sheets using Adobe, where the below code runs perfectly but


    Sub Combine_PDF()
    Dim x, lastrow As Long
    Dim arrayFilePaths() As Variant
    ...
  17. Re: Adding data from Excel to Word throwing a run time error

    Hello Friends,
    Any suggestions/Solution about the Problem

    Regards,
    Dhruv
  18. Re: How to copy excluding one particular column

    I got the solution as i required


    Sub ranges()
    Dim ws As Worksheet
    Dim ColumnLetter As Variant
    Set ws = Sheets("HSR")
    Worksheets("HSR").Select
    lr = Cells.Find("*", , xlValues, ,...
  19. Re: How to copy excluding one particular column

    Already in my Combined sheet i would be having some data which i need for further use but from sheet "HSR" column D is an extra column which is not required.
    As i neglect/i dont need to copy the...
  20. Re: How to copy excluding one particular column

    I have tried with the below code also but its throwing me Error code 1004 Method Range of Object _Global Failed


    Sub ranges()
    Dim ws As Worksheet
    Dim ColumnLetter As Variant
    Set ws =...
  21. Re: How to copy excluding one particular column

    Its throwing me a run time error 1004 if i use the below code


    Sub ranges()
    Worksheets("HSR").Select
    lastColumn = Cells(1, Columns.Count).End(xlToLeft).Column
    lr = Cells.Find("*",...
  22. Re: How to copy excluding one particular column

    kweaver yes always my 1st row contains headers but where i need to do these changes in my code, can you please suggest me
  23. How to copy excluding one particular column

    Hi Everyone,
    Here i am trying to copy data from one sheet to another, where i need to exclude one particular column from copy sheet

    Like :
    Think i have 2 sheets( with names as "Combined","HSR")...
  24. Re: Adding data from Excel to Word throwing a run time error

    As I debugged and checked in the above code highlighted line it's throwing me an Error
  25. Re: Adding data from Excel to Word throwing a run time error

    I have updated my Code

    Sub Revision()
    Dim appWD As Word.Application
    Dim lastrow As Long
    Dim name As String
    Dim rng As Range
    Dim ws, ws1 As Worksheet
    Set appWD =...
Results 1 to 25 of 141
Page 1 of 6 1 2 3 4