Hello everyone
Is there anyone in the group having Good Stock register for material
Inventory or PHP based code for the same. If yes, I request to share with
us.
Regards
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook pa
Please check the below link.
http://www.techonthenet.com/excel/formulas/betadist.php
On Wed, Sep 11, 2013 at 7:24 PM, Sudeshna Sen wrote:
> Hi,
>
> I've been trying to understand how the Beta.dist function works in MS
> Excel. The MS Office help says that Beta.dist returns the beta cumulative
Paul,
Thanks for the answer! I usually breaks into ~250 sheets and a total of
~2500 columns.
I can send you the file, but how can I do that without having to attach it
in the forum?
Thanks,
Cesar
Em quarta-feira, 11 de setembro de 2013 13h29min33s UTC-3, Paul Schreiner
escreveu:
>
> Could
Can you share sample text file and workbook ?
Pada 11/09/2013 22:42, CesarSan menulis:
I have been researching for a quicker way to do the following task,
but I couldn´t...
Can you please help me with that? It is basically a parser that
convert text files into sheets, but the problem is that
Could you send me (directly) a sample data file?
even just a couple thousand lines would be sufficient.
(otherwise, I have to spend time creating sample data!)
I routinely read in comma delimited files.
(The largest is 127,000 lines)
I think there are several things I could do with your macro t
I have been researching for a quicker way to do the following task, but I
couldn´t...
Can you please help me with that? It is basically a parser that convert
text files into sheets, but the problem is that the text file has about
10 lines and this code is taking more then half hour to run!
ok De Premor, tks.
Em quarta-feira, 11 de setembro de 2013 05h48min30s UTC-3, rashid memon
escreveu:
>
> Dear All,
>
>
> I have a DBF Table containing Vouchers Month wise like
>
> 70001 (Dated : 05-July-13)
> 70002 (Dated : 08-July-13)
> 80001 (Dated : 02-August-13)
>
>
> Now i want to get
Try this code, please give more attention on RED Color :D
Sub RoundedRectangle1_Click()
Dim LRow As Long
Sheet1.[A10].Formula = "=SUM(A1:A9)"
LRow = WorksheetFunction.CountA(Sheet2.Range("*B:B*")) + 1
Sheet2.Cells(LRow, *2*) = Sheet1.[A10]
Sheet1.Range("A1:A9").ClearContents
E
U're welcome ;-)
Pada 11/09/2013 21:24, georgebeegl...@gmail.com menulis:
PERFECT!!!Thanks so much for your assistance the last 2 days.
I appreciate it very much.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
It’s =TIME(2,DO:IT,N:OW) ! Join official Faceb
hi Ravi,
This code is throwing error "subscript out of range".
Please suggest.
On Wednesday, September 11, 2013 5:44:17 PM UTC+5:30, Ravi Kumar wrote:
> No dear,
>
>
>
> Point 1)
>
> Workbooks(primewb).Sheets("sample").Range("A4:c22").Copy
> Destination:=Workbooks(Mid(fil.Name, 1, _
>
>
No it's not, that file protected by simple method to prevent user
opening it they change the file header structure
Try attached DBF, i've repair the header by changing 1st byte on file
with correct value.
Pada 11/09/2013 21:19, Basole menulis:
Hi, the dbf attachment is corrupted.
Em quart
>
> PERFECT!!!Thanks so much for your assistance the last 2 days. I
> appreciate it very much.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULE
Hi, the dbf attachment is corrupted.
Em quarta-feira, 11 de setembro de 2013 05h48min30s UTC-3, rashid memon
escreveu:
>
> Dear All,
>
>
> I have a DBF Table containing Vouchers Month wise like
>
> 70001 (Dated : 05-July-13)
> 70002 (Dated : 08-July-13)
> 80001 (Dated : 02-August-13)
>
>
> No
>
> Explanation written on attached worksheet. Thanks for your time and
> assistance.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use con
Hi,
I've been trying to understand how the Beta.dist function works in MS
Excel. The MS Office help says that Beta.dist returns the beta cumulative
distribution function. The FALSE of the function gives the probability
density function while the TRUE give the cumulative distribution function.
Hi,
Am trying to plot dyanamic chart but am having problem with name range if I
try to select correct reference its changing to other reference. Could you
please check attach file and let me know where its going wrong.
Thanks in advance.
Regards,
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:R
Please send me a sample file with a little explanation there
Pada 11/09/2013 20:10, georgebeegl...@gmail.com menulis:
Hi De Premor,
Thanks so much for the accurate information yesterday. We are
currently using that for one of our workbooks.
Yesterday, you nailed putting the value into the
Thanks Mr.Anil & others
I got it.
On Wed, Sep 11, 2013 at 5:36 PM, Prafull Jadhav wrote:
>
> Dear Anil and Xlstime Sir,
> can we use below method?
>
> Sub prafull()
> For Each x In Range("G2:G139")
> If x.Font.Bold = True Then
> x.Offset(0, 1).Value = 1
> End If
> Next x
>
> End Sub
>
>
>
> On W
>
> Hi De Premor,
>
Thanks so much for the accurate information yesterday. We are currently
using that for one of our workbooks.
Yesterday, you nailed putting the value into the TOTALS worksheet in A1 and
then each time the values were cleared and the macro was run again it
replaced that va
Can you explain it with a sample workbook ?
or maybe you can try to change
*LRow = WorksheetFunction.CountA(Sheet2.Range("A:A")) + 1**
*
to
*LRow = WorksheetFunction.CountA(Sheet2.Range("C:C")) + 1**
*
Pada 11/09/2013 19:28, georgebeegl...@gmail.com menulis:
Hi All,
Got some great help
DEAR ALL
file attached DBF and XLS file Also
On Wed, Sep 11, 2013 at 3:46 PM, Ravi Kumar wrote:
> ** **
>
> Negi ji, He’s saying that he have “DBF” table.
>
> ** **
>
> Use the below command hope you already know this and then you can
> manipulate the data through excel easily otherwise pl
Hi All,
Got some great help yesterday from De Premor using VBA to copy data to
other worksheets and then using next available row to copy again etc.
It works like a charm. But I need some tweaking that I hope is possible.
Scenario of worksheet "TOTALS"
A B
No dear,
Point 1)
Workbooks(primewb).Sheets("sample").Range("A4:c22").Copy
Destination:=Workbooks(Mid(fil.Name, 1, _
WorksheetFunction.Find(".", fil.Name) -
1)).Sheets(Sheets.Count).Range("A1")
Point 2)
Workbooks(primewb).Sheets("sample").Range("A4:c22").Copy
Destination:=Workbooks(M
Dear Anil and Xlstime Sir,
can we use below method?
Sub prafull()
For Each x In Range("G2:G139")
If x.Font.Bold = True Then
x.Offset(0, 1).Value = 1
End If
Next x
End Sub
On Wed, Sep 11, 2013 at 2:23 PM, अनिल नारायण गवली
wrote:
> Dear Ashish,
>
> Pl see the attached workbook.
> Is it ok?
hi Ashish,
it's running perfectly without any error but it's not adding the sheet in
workbook.
On Tuesday, September 10, 2013 7:54:02 PM UTC+5:30, ashish wrote:
> is it giving you any error
>
>
> On Tue, Sep 10, 2013 at 2:54 PM, Ravi Kumar
> > wrote:
>
>> Try this and change you folder name
Hi Ravi,
i think the below code is incomplete.please correct me if i'm wrong.
" Workbooks(primewb).Sheets("sample").Range("A4:c22").Copy
Destination:=Workbooks(Mid(fil.Name, 1, _"
On Tuesday, September 10, 2013 2:54:19 PM UTC+5:30, Ravi Kumar wrote:
> Try this and change you folder name acc
Negi ji, He's saying that he have "DBF" table.
Use the below command hope you already know this and then you can manipulate
the data through excel easily otherwise plz share your dbf table with us
Copy to "C:\Users\Admin\Desktop\DBFfolder\dbftable.dbf"
"C:\Users\Admin\Desktop\DBFfolder\e
Use below formula or attached file.may be u r looking for this..
=IF(A2="","",MONTH(A2)&"000"&SUM((MONTH($A$2:A2)=MONTH(A2))*1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rashid memon
Sent: Wednesday, September 11, 2013 2:19 PM
To: excel-macros@
Pls provide example file for more clarification.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rashid memon
Sent: Wednesday, September 11, 2013 2:19 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Required : How i import Data in Exce
Dear Ashish,
Pl see the attached workbook.
Is it ok?
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 11, 2013 at 2:11 PM, अनिल नारायण गवली
wrote:
> Dear Ashish,
>
> Pl share the workbook with us.
>
> Warm Regard
Hi,
Please read below link
http://support.microsoft.com/kb/213923
.
Enjoy
Team XLS
On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> I have a data columnar and want filter only bold letter data, is it
> possible, if yes please tell me how it
Dear All,
I have a DBF Table containing Vouchers Month wise like
70001 (Dated : 05-July-13)
70002 (Dated : 08-July-13)
80001 (Dated : 02-August-13)
Now i want to get New voucher # by month wise
like :
New # 70003 dated 15-July-13
or New # 80002 dated 18-Aug-13
Kindly Help me in this regard
Dear Ashish,
Pl share the workbook with us.
Warm Regards,
Gawli Anil.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> I have a data columnar and want filter only bold letter da
Dear experts,
I have a data columnar and want filter only bold letter data, is it
possible, if yes please tell me how it done.
Thanks & regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
--
Are you =EXP(E:
34 matches
Mail list logo
