Give more attention here !
/Sheets(//*sheet2*//).Range(A10).Value = 1000//
/
Because you've specified a sheet name, Please make sure you have Sheet
named *sheet2 *in current workbook
Pada 11/09/2013 12:22, Prabhu Pinky menulis:
Hi experts,
Please find below simple codes, while i
Dear Prabhu,
In place of Sheet2 write
Sheets(2).range(A10).value=1000
Warm Regards,
Gawli Anil.
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 11, 2013 at 11:44 AM, De Premor d...@premor.net wrote:
Give more attention here !
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
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
ashishbhalar...@gmail.com wrote:
Dear experts,
I have a data columnar and want
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
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
ashishbhalar...@gmail.comwrote:
Dear experts,
I have a data columnar and want filter only bold letter data, is it
possible, if yes
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, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
Dear Ashish,
Pl share the workbook with
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
Use below formula or attached file.may be u r looking for this..
=IF(A2=,,MONTH(A2)000SUM((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:
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
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
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 excelle...@gmail.comjavascript:
wrote:
Try this and
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, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Ashish,
Pl see the attached
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
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
DEAR ALL
file attached DBF and XLS file Also
On Wed, Sep 11, 2013 at 3:46 PM, Ravi Kumar excellearn2...@gmail.comwrote:
** **
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
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
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
Thanks Mr.Anil others
I got it.
On Wed, Sep 11, 2013 at 5:36 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
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
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
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
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
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
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)
Now i want to
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 RULES
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
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, _
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
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
End
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 New
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
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
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
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
Please check the below link.
http://www.techonthenet.com/excel/formulas/betadist.php
On Wed, Sep 11, 2013 at 7:24 PM, Sudeshna Sen s4sudes...@gmail.com 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
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
36 matches
Mail list logo
