Thanks Noorain. I couldn't reply in time as I was not keeping well.
I worked with the procedure suggested by Swapnil and moved ahead. And now I
got an obstruction. In the excel sheet, I am using an combo-box and want to
populate the combo-box with 'Items' category in the Access Database. The
'I
thanks bhai
But want to solution in VBA.
On Thu, Sep 13, 2012 at 10:49 AM, Prince Dubey wrote:
> Hi Jeet,
>
> Please use below formula hope this will helpe you.
>
>
> =SUM(SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=12)),SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=13)))
Hi Jeet,
Please use below formula hope this will helpe you.
=SUM(SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=12)),SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=13)))
use it with Ctr+Shift+Enter
Regards
Prince
On Wednesday, September 12, 2012 11:52:11 PM UTC+5:30, jeet
Hi Sagar,
I think you can use any open source ERP that help you to manage all your
need
Thanks,
Sushil
On Thu, Sep 13, 2012 at 9:48 AM, SAGAR KASANGOTTUWAR <
sagarkasangottu...@gmail.com> wrote:
> Dear Prince,
>
> I required the FIFO method stock maintain in Excel.
>
> Thanks & Regards,
> Sagar
Dear Prince,
I required the FIFO method stock maintain in Excel.
Thanks & Regards,
Sagar
On Tue, Sep 11, 2012 at 9:47 PM, Prince Dubey wrote:
> Hi Sagar,
>
> I think stock management criteria for several firms or companies could be
> different so pleas explain requirements (functionality as u
>
> Hi Dhananjay,
>
>
Please Find the Attachment.
> Regards,
>
>
Excel Beginner
>
>
> I need a solution as per my query in attached file.
>>
>> Pl. revert in case of any clarification or any confusion.
>>
>> Regards,
>> Dhananjay
>>
>> --
>> Join official
Hi Dhananjay,
Please find the attachment.
Regards,
Excel Beginner
On Mon, Sep 10, 2012 at 12:32 AM, Dhananjay Pinjan wrote:
> Dear Experts,
>
> I need a solution as per my query in attached file.
>
> Pl. revert in case of any clarification or any confusion.
>
> Regards,
> D
Hi Mr. David / Excel Experts,
I am very impressed the way you have given answer. I was expecting the
use of formula "RANK' or 'SUMPRODUCT'. But you have just given it with
very simple equtions. Hat's off.
Sorry to say, but I have some modifications in my requirements (pl.
refer attached Excel Fil
Hertiest Congrats Noorain Ansari. Do continue. Best Luck
On 9/12/12, SAGAR KASANGOTTUWAR wrote:
> Congratulations Noorain...
>
> Best Regards,
>
> sagar
>
> On Tue, Sep 11, 2012 at 7:26 PM, David Grugeon
> wrote:
>
>> Loveufe2001
>>
>> I suggest you post your question in its own thread a
Or another alternative
=SUMPRODUCT((Sheet1!$A$2:$A$2270=A2)*((Sheet1!$B$2:$B$2270=12)+(Sheet1!$B$2:$B$2270=13)))
Sub cnt()
Dim rng As Range
Dim rng1 As Range
Dim i As Integer
Set rng = Sheet1.Range("A2:A" & Sheet1.Range("A" &
Rows.Count).End(xlUp).Row)
Set rng1 = Sheet1.Range("B2:B" & Sheet1.Rang
I believe that the problem is that, when you enter the formula in the Workbook,
you're entering it as an "ARRAY" formula, where it matches the value in Column A
and column B is EITHER 12 or 13 ({12,13})
But in your VBA, you're only counting a match of 12:
Sheet2.Cells(i, 2) = WorksheetFunction.Co
Hi Kuldeep..
It Doesnt work.. can you show or attach file with solution.
Rgds
On Wednesday, September 12, 2012 10:40:39 PM UTC+5:30, Kuldeep Singh wrote:
>
>
> Hi,
>
> Try this.
>
> Function Udf_sum(rng As Excel.Range)
> Dim cell As Range
> For Each cell In rng
> If VBA.IsNumeric(cell) And cell.
Hi,
Try this.
Function Udf_sum(rng As Excel.Range)
Dim cell As Range
For Each cell In rng
If VBA.IsNumeric(cell) And cell.Value <> "" Then
Udf_sum = Udf_sum + cell
End If
Next cell
End Function* *
Regards,
Kuldeep Singh
On Wed, Sep 12, 2012 at 10:27 PM, Rajan_Verma wrote:
> * *
>
> * *
>
> *=S
Sub tests()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
Sheets("New").UsedRange.Borders.LineStyle =
Excel.XlLineStyle.xlLineStyleNone
Dim i As Long
For i = 2 To Sheets("New").Range("a65356").End(xlUp).Row
If Sheets("New")
=SUM(OFFSET($A4,,ROWS($L$3:L3),1,4))
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vabz
Sent: 12 September 2012 9:52
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: UDF to sum
I am agree with Paul.
This group is the main source of information on Excel and its basics.
On Wed, Sep 12, 2012 at 7:40 PM, Paul Schreiner wrote:
> I don't mean to be difficult, or unhelpful, or snotty, or seem to be any
> other bad description,
> but this group is designed to help people that a
IN J4 TYPE = SUM(OFFSET(A4,0,ROW(A1),1,4))
On Wed, Sep 12, 2012 at 9:52 PM, Vabz wrote:
> hi
>
> Question was really tuff..but not impossible..
>
> I could manage to solve without UDF
>
> PFA.. Soln is in K column..
>
> Cheerz..
>
> Rgds//Vabz
>
>
> On Friday, August 17, 2012 11:28:51 AM UTC+5
hi
Question was really tuff..but not impossible..
I could manage to solve without UDF
PFA.. Soln is in K column..
Cheerz..
Rgds//Vabz
On Friday, August 17, 2012 11:28:51 AM UTC+5:30, Amol J wrote:
>
> Hi experts, I need your help, I tried myself but unfortunatly its not
> working.
> I need
Congratulations Noorain...
Best Regards,
sagar
On Tue, Sep 11, 2012 at 7:26 PM, David Grugeon wrote:
> Loveufe2001
>
> I suggest you post your question in its own thread and try to give a
> bit more of an explanation of what you are doing Also use a suitable
> heading.
>
> On 11 September 2012
One technique I've used in the past is to use VBA to open a text file in Binary
mode.
With this, you can read the passwords for comparisons.
This password file is then placed on the network and cannot be opened/viewed
by anyone UNLESS THEY WRITE A VBA MACRO.
Of course, you have to protect your
I don't mean to be difficult, or unhelpful, or snotty, or seem to be any other
bad description,
but this group is designed to help people that are having difficulty with
VBA macros.
Not necessarily teach VBA from scratch.
I think one of the BIGGEST lessons any of us need to learn is how to look
And, I wonder why he insists.. Homework?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Wednesday, September 12, 2012 8:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three par
That's precisely the point!
Because he's wanting to do this with formulas, he's making the solution more
complex than necessary.
A VBA solution would be very neat and tidy (use split to load an array, and
display the array elements in the cells)
A "manual" solution using text-to-Columns is also
All I had to do was unhide the sheet. and the code was not protected
(easily defeated)
. Even if you had hidden with xlVERYHIDDEN code could unhide.
Although more trouble, you may want to use separate protected workbooks where
security is higher for most users.
Don Guillett
Microsoft Excel
You have already helped yourself to join this group,
With following discussion here , you can start learning macros by Recording
Macros , start recording little steps may be help for you.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:exce
hi team,
my job profile is mis analyst level,
have experience in excel depth formulas level but i need develops in excel
VBA
I want to learn excel vba ,
could any one give help me
--
Regards,
Shivaprasad K.
--
Join official facebook page of this forum @
https://www.facebook.com/discussex
hi..
what i feel is this solution is very complex !!
Rgds//Vabz
On Tuesday, September 11, 2012 7:09:23 AM UTC+5:30, Asa R. wrote:
>
> Hi Mangesh,
>
> I've read your other replies, and as to why you haven't received a formula
> method -- most people don't want to take the trouble on a volunteer
As Paul said, there is a better way. Provide a file.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: SridharBL
Sent: Wednesday, September 12, 2012 4:13 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Work
There isn't a pre-existing code to do ANYTHING.
It has to be "built" or "assembled" from VBA tools.
What I would do:
-Open "master" file.
-Start recording a macro (stored in Master file)
-Open one of the 15 report files
-Copy the sheets to the report file.
-Save the file and exit the REPORT file.
Try this attachment
On Wed, Sep 12, 2012 at 2:28 PM, Pravin Gunjal wrote:
> Dear Masters,
>
>
>
> In the attached file there are six working sheets in it.
>
> The concerned person will send a mail of this file to his down level for
> their working/use.
>
>
>
> *Sheet 1 *is made for the master (
Hi Experts,
I am working as a analyst and I do publish the review files to Leaders.
I have one Base excel file, which has two sheets "Basesheet" & "Pipeline"
sheets. I have to publish 15 review reports to different leaders.
So I should be manually copy "Basesheet" & "Pipeline" to all the 15 ex
Dear Masters,
In the attached file there are six working sheets in it.
The concerned person will send a mail of this file to his down level for
their working/use.
*Sheet 1 *is made for the master (which can be seen to all end users).
While others - *sheet 2 to* *sheet 7 (i.e. ASM to SO5)* ar
32 matches
Mail list logo
