Search:

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

Page 1 of 6 1

1. Thread: How can we use Multiplication in Sumproduct

by GirishDhruva
Replies
21
Views
256

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. Thread: How can we use Multiplication in Sumproduct

by GirishDhruva
Replies
21
Views
256

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. Thread: How can we use Multiplication in Sumproduct

by GirishDhruva
Replies
21
Views
256

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. Thread: How can we use Multiplication in Sumproduct

by GirishDhruva
Replies
21
Views
256

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. Thread: How can we use Multiplication in Sumproduct

by GirishDhruva
Replies
21
Views
256

6. Thread: How can we use Multiplication in Sumproduct

by GirishDhruva
Replies
21
Views
256

Re: How can we use Multiplication in Sumproduct

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. Thread: How can we use Multiplication in Sumproduct

by GirishDhruva
Replies
21
Views
256

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. Thread: How can we use Multiplication in Sumproduct

by GirishDhruva
Replies
21
Views
256

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. Thread: How can we use Multiplication in Sumproduct

by GirishDhruva
Replies
21
Views
256

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. Thread: How can we use Multiplication in Sumproduct

by GirishDhruva
Replies
21
Views
256

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. Thread: How can we use Multiplication in Sumproduct

by GirishDhruva
Replies
21
Views
256

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. Thread: Calculating based on values in second sheet

by GirishDhruva
Replies
0
Views
24

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. Thread: Combine two PDF into one Separate PDF and save in particular path Using VBA

by GirishDhruva
Replies
5
Views
572

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. Thread: Combine two PDF into one Separate PDF and save in particular path Using VBA

by GirishDhruva
Replies
5
Views
572

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. Thread: Combine two PDF into one Separate PDF and save in particular path Using VBA

by GirishDhruva
Replies
5
Views
572

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. Thread: Combine two PDF into one Separate PDF and save in particular path Using VBA

by GirishDhruva
Replies
5
Views
572

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. Thread: Adding data from Excel to Word throwing a run time error

by GirishDhruva
Replies
8
Views
484

Re: Adding data from Excel to Word throwing a run time error

Hello Friends,

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

by GirishDhruva
Replies
7
Views
216

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. Thread: How to copy excluding one particular column

by GirishDhruva
Replies
7
Views
216

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. Thread: How to copy excluding one particular column

by GirishDhruva
Replies
7
Views
216

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. Thread: How to copy excluding one particular column

by GirishDhruva
Replies
7
Views
216

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. Thread: How to copy excluding one particular column

by GirishDhruva
Replies
7
Views
216

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. Thread: How to copy excluding one particular column

by GirishDhruva
Replies
7
Views
216

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. Thread: Adding data from Excel to Word throwing a run time error

by GirishDhruva
Replies
8
Views
484

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. Thread: Adding data from Excel to Word throwing a run time error

by GirishDhruva
Replies
8
Views
484

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