To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Best Regards,
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 thread titles, like Please
http://www.teachexcel.com/excel-help/excel-how-to.php?i=447580#3
2012/6/5 Darwin Chan darwin.chankaw...@gmail.com
Dear,
I am not an expert, but see if the below page can give you some idea.
Darwin
2012/6/5 Puttu * puttu...@gmail.com
Experts,
Can you have look on my requirements
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
:=myrange, Type:=xlFillDays
End With
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Darwin Chan darwin.chankaw...@gmail.com
*Sent:* Thursday, May 17, 2012 1:15 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Ask for improvement
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
. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Best Regards,
Darwin Chan
darwin.chankaw...@gmail.com
, 2012 at 3:45 AM, Abhishek Jain
abhishek@gmail.comwrote:
Actually count of values stored in adjacent columns of each load number
is required. For Load 0241 - there are 6 values so the formula should
return 6.
On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan
darwin.chankaw...@gmail.com
, Abhishek Jain
abhishek@gmail.comwrote:
Actually count of values stored in adjacent columns of each load number
is required. For Load 0241 - there are 6 values so the formula should
return 6.
On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan
darwin.chankaw...@gmail.com wrote:
Hi Sara,
Seems
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
Dear Pawel,
yes, this is what i m looking for, thanks for your help~[?]
2012/4/3 pawel lupinski lupins...@yahoo.com
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 darwin.chankaw...@gmail.com
*To:* excel
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Best Regards,
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk
--
FORUM RULES (986+ members already BANNED for violation)
1
and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Best Regards,
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk
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
use it. OR, UPGRADE.
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Darwin Chan darwin.chankaw...@gmail.com
*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
Dear
://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Tue, Feb 7, 2012 at 3:14 PM, Darwin Chan
darwin.chankaw...@gmail.comwrote:
Thanks all,
the reason is i m reviewing the use of index and match. Found when
browsing this group from another thread, can anyone help to explain
2, 2012 at 5:18 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
2012/2/2 Excel_Lover idforex...@gmail.com
great, Thanks for sharing..
On Wed, Feb 1, 2012 at 12:39 PM, Darwin Chan
darwin.chankaw...@gmail.com wrote:
Noorain,
Is there any version for Excel 97 - 2003?
Thanks
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
and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk
--
FORUM RULES
-macros@googlegroups.com
--
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 thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk
@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Darwin Chan
*Sent:* Monday, January 30, 2012 12:11 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2
cells
** **
Dear all,
** **
I have composed some code
the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
*-
--
*From:* Darwin Chan darwin.chankaw...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Mon
://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Fri, Jan 20, 2012 at 9:13 AM, Darwin Chan
darwin.chankaw...@gmail.comwrote:
Dear group,
I have written a macro for auto saving as today date excel file, however,
when i save this, it refuses to save.
I
Filename:=driveloc \ todaydate .xls
End Sub
2012/1/20 Darwin Chan darwin.chankaw...@gmail.com
Dear Noorain,
I try to use the code pasted here, however, run time error 1004. It may be
due to the code highlight in red. What should the code be if I would like
to have directory highlighted
data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Darwin Chan
darwin.chankaw
, January 5, 2012 9:05:16 AM
*Subject:* Re: $$Excel-Macros$$ VBA code for pasting date, not plain text
You may want to reconsider what you are asking for.
One set dd/mm/ and the other mm/dd/
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Darwin Chan darwin.chankaw
and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk
--
FORUM
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)
End Sub
--
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk
--
FORUM RULES (934+ members already BANNED
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
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
://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Fri, Dec 9, 2011 at 8:03 AM, Darwin Chan
darwin.chankaw...@gmail.comwrote:
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
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@googlegroups.com
--
Darwin Chan
.AutoFilter Field:=39, Criteria1:==*cy*
.SpecialCells(xlCellTypeVisible).Copy Sheets(cy).Range(a1)
.AutoFilter
End With
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Darwin Chan darwin.chankaw...@gmail.com
*Sent:* Friday, October 28, 2011 6:27 PM
*From:* Darwin Chan darwin.chankaw...@gmail.com
*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 part of the requirement. however, the MYLIST seldom
, Darwin Chan darwin.chankaw...@gmail.com
wrote:
Dear all,
Pls find the attached...and I couldn't find which button i could click for
placing sample file.
I can only place by replying the thread in gmaildid anyone know and
thanks in advance!!
Darwin
2011/10/26 Swapnil Palande
PM, Darwin Chan darwin.chankaw...@gmail.com
wrote:
Swapnil,
Thanks so much for your help.
I could see you have added few codes
**
Set ptsheet = Worksheets.Add
Set rng = Sheets(2011-10-26).Range(A1)
**
1. Would like to askthat means we have to define the range before
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 noorain.ans...@gmail.com
Dear Hemal,
Please try below code, sheet is attached
38 matches
Mail list logo