http://www.teachexcel.com/excel-help/excel-how-to.php?i=447580#3
2012/6/5 Darwin Chan
> Dear,
>
> I am not an expert, but see if the below page can give you some idea.
>
> Darwin
>
> 2012/6/5 Puttu *
>
>> Experts,
>>
>> Can you have look on my requi
questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any
ill Destination:=myrange, Type:=xlFillDays
> End With
> End Sub
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Darwin Chan
> *Sent:* Thursday, May 17, 2012 1:15 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$E
Dear all,
I have written a simple procedure to fill cells with dates, it depends on
the current month and decide the range of the cells.
Can anyone suggest any room for improvement for my code?
Sub monthfill()
Dim myrange As Range
Dim mth As Integer
Cells.Clear
mth = month(Date)
Select Cas
Dear all,
I have a spreadsheet containing daily customer transaction data. I have
used SUMIF to find out the monthly customer transaction data.
However, it is tedious to copy the formula and paste for next month when
next month comes.
Can anyone suggest any VBA code / idea to help shifting the
t;>> load 02452
>>> load 02462
>>>
>>>
>>> On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain
>>> wrote:
>>>
>>>> Actually count of values stored in adjacent columns of each load number
>>>> is required. For
t; load 02423
>>> load 02452
>>> load 02462
>>>
>>>
>>> On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain
>>> wrote:
>>>
>>>> Actually count of values stored in adjacent columns of each load num
re prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to thi
Dear Pawel,
yes, this is what i m looking for, thanks for your help~[?]
2012/4/3 pawel lupinski
> I realy don't know what are you looking for so check if this is what you
> are looking for.
>
> Regards,
>
> Pawel
>
> *From:* Darwin Chan
> *To:* excel
Dear all,
I have a roster with staff allocated on different roster plan, i.e.
different working hours. I have a task to analyse the maximum and minimum
of staff who would appear at concurrent period.
However, volume of data is huge and formula is needed for assistance in
analysis. I have atta
dy BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
>
3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don&
Dear group,
After browsing the topics in this group, I found excel VBA could integrate
with Lotus Notes.
I found some VBA code useful for the integration, but do not know whether
extra library may be needed for installation.
Can anyone suggest do I need to install the library? where can find t
it. OR, UPGRADE.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Darwin Chan
> *Sent:* Friday, February 10, 2012 3:33 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Synchronization on same set of data on 2
> charts
>
&
>
>>
>>
>> On Thu, Feb 2, 2012 at 5:18 PM, Bé Trần Văn wrote:
>>
>>>
>>>
>>> 2012/2/2 Excel_Lover
>>>
>>>> great, Thanks for sharing..
>>>>
>>>>
>>>> On Wed, Feb 1, 2012 at 1
for you.
>
>
>
> Thanks & regards,
> Noorain Ansari
> *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>
>
> On Tue, Feb 7, 2012 at 3:14 PM, Darwin Chan
> wrote:
>
>> Thanks all,
>>
>&
Hi group,
Currently I m reviewing the use of Index and match. However, anyone can
point out what is missing in my forumla?
--
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
to excel-macros@googlegroups.com
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will
is forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegr
his group, send email to excel-macros@googlegroups.com
>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>
>>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>>>
ft(.Cells(R, "E").Value,
> (InStr(.Cells(R, "E").Value, "X") - 1))
> Else
> .Cells(R, "N").Value = ""
> End If
>
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the way
;
> ** **
>
> You switch between using Cells() and Range() for your references. In a
> case like this where both seem to be being used interchangably, I recommend
> sticking to one for ease of code comprehension, debugging, and code speed.
> I would use Cells in this case as the
e:=todaydate,
fileFilter:="Excel Files (*.xls), *.xls", Title:="Please save the file")
ActiveWorkbook.SaveAs Filename:=driveloc & "\" & todaydate & ".xls"
End Sub
2012/1/20 Darwin Chan
> Dear Noorain,
>
> I try to use the code pas
t; End Sub
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Fri, Jan 20, 2012 at 9:13 AM, Darwin Chan
,
fileFilter:="Excel Files (*.xls), *.xls", Title:="Please save the file")
ActiveWorkbook.SaveAs Filename:=todaydate
End Sub
******
--
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk
--
FORUM RULES (986+ member
rum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ---
>
>
> --
> *From:* dguillett1
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, January 5, 2012 9:05:16 AM
> *Subject:* Re: $$Excel-Macros$$ VBA code for pasting date, not plain text
>
> You
ponses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
Sheets("PivotTable").Cells(2, 12).Value
'20', 40, RF marshalling btw CY/CFS and MR/CMR AND disc/load btw BH/V/L and
MR/CMR
Sheets("PivotTable").Range("L4").Resize(12, 74).Copy
Worksheets("Summary").Cells(dt, 2).PasteSpecial (xlPasteValues)
E
Dear all,
I have a excel table with duplicate bill id, i want to get the unique
count. However, it should also consider another criteria, which is
customer. Should I use advanced filter instead? How should the advanced
filter be set?
--
Darwin Chan
darwin.chankaw...@gmail.com
kw42c
tables and fill up with zero and then to calculate the change in sales
volume. Does anyone have solutions to create a macro or any other solutions?
Below please find the attachment.
--
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk
--
FORUM RULES (934+ members already BANNED for
orld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
> On Fri, Dec 9, 2011 at 8:03 AM, Darwin Chan
> wrote:
>
>> Dear group,
>>
>> I have got an excel file getting sales volume of different customers in
>> buying d
Dear group,
I have got an excel file getting sales volume of different customers in
buying different services on a daily basis. I want to use sumproduct
formula to get the sales volume buying services on a monthly basis.
However, the desired results are not found. Please help.
--
Darwin Chan
------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
s(xlCellTypeVisible).Copy Sheets("mr").Range("a1")
> .AutoFilter
>.AutoFilter Field:=39, Criteria1:="=*cy*"
> .SpecialCells(xlCellTypeVisible).Copy Sheets("cy").Range("a1")
>.AutoFilter
> End With
> End Sub
>
&
gt; SalesAid Software
> dguille...@gmail.com
>
> *From:* Darwin Chan
> *Sent:* Friday, October 28, 2011 10:25 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Compare the data across different sheets
> and put into one sheet
>
> Hi Don,
>
> it is
e your file(s) after you redo it.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Darwin Chan
> *Sent:* Friday, October 28, 2011 9:55 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Compare the data across different sheets
not fixed then use following code (this code you
> have to change every day)
> Dim shtname as String
> shtname = "2011-10-26"
> Set rng = Sheets(shtname).Range("A1")
>
> Regards,
>
> Swapnil.
>
> On Wed, Oct 26, 2011 at 12:01 PM, Darwin Chan >
have to create this pivot table every day. What codes i wish to
change Sheets("2011-10-26") as a variable?
(I copy code from books and forum, I m just newbee)
Thanks!
Darwin
2011/10/26 Swapnil Palande
> Hi,
>
> Pls find attached excel.
>
> Regards,
>
> Swapnil
Dear all,
I am new to Excel VBA, esp for treating it database. Could hemal explain how
to use it?
Also, I cannot open the file from Noorain, my excel version is 2003. Thanks
a lot!
Darwin
2011/9/23 NOORAIN ANSARI
> Dear Hemal,
>
> Please try below code, sheet is attached for ur help.
>
> Priv
40 matches
Mail list logo
