-Original message-
From: Prince Dubey
Sent: 11/09/2012, 23:00
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Creating Custom Ribbon
Hi Vinay.
Pls follow below mentioned steps.
1: download customUI editor And install it in ur system.
2: open ur workbook in ur UI
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)*
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 excel
Try this attachment
On Wed, Sep 12, 2012 at 2:28 PM, Pravin Gunjal isk1...@gmail.com 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
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
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 @
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
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
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
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
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
Congratulations Noorain...
Best Regards,
sagar
On Tue, Sep 11, 2012 at 7:26 PM, David Grugeon da...@grugeon.com.au 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
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
IN J4 TYPE = SUM(OFFSET(A4,0,ROW(A1),1,4))
On Wed, Sep 12, 2012 at 9:52 PM, Vabz in.vaib...@gmail.com 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
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 schreiner_p...@att.netwrote:
I don't mean to be difficult, or unhelpful, or snotty, or seem to be any
other bad description,
but this group is designed
=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
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
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 rajanverma1...@gmail.comwrote:
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.Value
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) =
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.Range(B
Hertiest Congrats Noorain Ansari. Do continue. Best Luck
On 9/12/12, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote:
Congratulations Noorain...
Best Regards,
sagar
On Tue, Sep 11, 2012 at 7:26 PM, David Grugeon da...@grugeon.com.au
wrote:
Loveufe2001
I suggest you post
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
Hi Dhananjay,
Please find the attachment.
Regards,
Excel Beginner
On Mon, Sep 10, 2012 at 12:32 AM, Dhananjay Pinjan dppin...@gmail.comwrote:
Dear Experts,
I need a solution as per my query in attached file.
Pl. revert in case of any clarification or any confusion.
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 facebook page of this
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 prince141...@gmail.comwrote:
Hi Sagar,
I think stock management criteria for several firms or companies could be
different so pleas explain requirements
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
On
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,
thanks bhai
But want to solution in VBA.
On Thu, Sep 13, 2012 at 10:49 AM, Prince Dubey prince141...@gmail.comwrote:
Hi Jeet,
Please use below formula hope this will helpe you.
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
30 matches
Mail list logo