Dear
Please use Pivot Table
Regards
On Fri, Apr 15, 2011 at 12:50 PM, Umed Singh umed.singh.par...@gmail.comwrote:
Hi Dear,
I need your help in attached file. Please make for me in macro code
for in attached file.
i want to selected department and past another sheet for seperately.
very nice speech Mr. Paul Sir.
Regards
Sumit Vyas
On Tue, Mar 8, 2011 at 7:07 PM, Paul Schreiner schreiner_p...@att.netwrote:
Dave,
Hey! I'm an ENGINEER, not an ENGLISH major!
Or a veterinarian for that matter!
What kind of dog would jump over a fox anyway...
Always seemed (seems
=A2 B2 C2 = FSD COM com
On Tue, Mar 8, 2011 at 7:17 PM, Paul Schreiner schreiner_p...@att.netwrote:
another alternative actually reduces the wear on the ol' keyboard.
=A2 B2 C2
accomplishes the same thing!
Paul
--
*From:* davidpk...@verizon.net
Very Nice Mr. Kalyan
On Wed, Jan 19, 2011 at 1:43 PM, Kal xcel kalx...@gmail.com wrote:
Dear All,
I am sharing two types of outlook of a Sales Dashboard which I am preparing
for my company. I need your honest comment that looks wise which one is
better.
Thanks in advance
Kalyan
--
Dear Mr. Dilip
*Congratulations to you*
Regards
Sumit Vyas
On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote:
Dear Group,
I am very very very very happy to share a good news with you. One of our
dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award
send file
On Sat, Dec 18, 2010 at 7:28 PM, Rajiv Kumar xlraja...@gmail.com wrote:
Dear sir,
I forget my excel password and how can open my excel sheet so
dear sir plz unlocked my excel sheet
Thanks regards
Rajiv Kumar
--
find herewith
thanks
sumit
On Mon, Nov 22, 2010 at 4:29 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
Any help please
Thanks
On Fri, Nov 19, 2010 at 6:07 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
When I run the program excel starts flicekring how
send file
On Wed, Nov 17, 2010 at 4:20 AM, Johnnyboy5 intermediatec...@gmail.comwrote:
workbook open password protected.
I need to be able to get a message box to appear with some
information - before the Password message box appears. I can get the
message to
appear after the Password box
already give solution
On Fri, Oct 29, 2010 at 3:16 PM, Born to Win cs4...@gmail.com wrote:
Hello,
Please Use COUNTA() Function or check Attached File.
Thanks,
Chandrabhan Singh
On Fri, Oct 29, 2010 at 2:43 PM, Rakesh Sharma rksharma...@gmail.comwrote:
*Dear All,
Please find the
Dear All,
I am send one file create in 2003 but file open 2007
2007 error macros disable ( Hyperlink data )
On Fri, Oct 15, 2010 at 10:02 PM, Vijay Kr. Aggarwal
vjaggarwal2...@gmail.com wrote:
Thanks a lot Srinivasan, siti, Paul and P. VijayKumar
Regards,
Vijay
On Fri, Oct 15, 2010
Dear
Use sumif formulas
SUMIF(Sheet1!$A$2:$A$19,Sheet2!A2,Sheet1!$B$2:$B$19)
CR-MSP-619+ 110 CR-MSP-620 600 CR-MSP-621 400 CR-MSP-622 180
CR-MSP-623 140 CR-MSP-624+ 110 CR-MSP-625 150 CR-MSP-626 350 CR-MSP-627+
80 CR-MSP-628 360 CR-MSP-629 1000 CR-MSP-630 80 CR-MSP-631+ 140
Xls 2003
Select Data
Copy Data
Past Data
Past Only Filter Data
On Fri, Oct 15, 2010 at 2:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Experts,
Please solve my problem. How can we copy only filtered data in Excel.
--
Thanks in advance..
Noorain Ansari
--
gb
On Wed, Oct 13, 2010 at 2:18 PM, kaza deepu deepuk...@gmail.com wrote:
Hi Kashan Abbas,
Find attached it may helps you.
On 10/13/10, Kashan Abbas kashanabbas...@hotmail.com wrote:
Dear All,
I have extracted a report from sap .The first column has been merged with
multiple
Dear,
Please find herewith VBA vlookup
one
Value look up in column 1 6
Value look up in column 2 vlookup2(F10, F11, tLookupDemo, 3) Result
Option Explicit
''
Dear Vishal
This trick is VBA inst log file.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count = 1 Then
If Target.Value Then
If Target.Column = 3 And Target.Row 1 Then
Target(1, -1) = Format(Now, dd-mmm- hh:mm:ss)
Target(1, 0) = Application.UserName
End If
End If
Dear Ayush,
Thanks for you,
1) excel group
2) help all time
3) touch you every
4) help find job
you are great person in this world.
regard
Sumit Vyas
On Fri, Oct 8, 2010 at 9:20 PM, Ayush jainayus...@gmail.com wrote:
Dear Group,
There is a opening for one person with the following
Dear
one colum set structure :- month = jan-2008 jan-2009 jan-2010
then use use pivot table
On Sat, Oct 9, 2010 at 10:34 AM, Kal xcel kalx...@gmail.com wrote:
Hi Worawat,
Thanks for your advice. But I can't use pivot table in this scenario.
Because lot of other issues attached with this.
Dear,
Please send No Of Row
No Of Column
Sheet Name eg: Date / Name / No. 1-2-3 / product name
i make sure report.
Regards
Sumit Vyas
On Thu, Oct 7, 2010 at 4:26 PM, Kishan Reddy, K
kishanreddy.kethire...@gmail.com wrote:
Mr Brain,
A macro can be written such that
1. It will copy
On Wed, Oct 6, 2010 at 10:41 AM, SUMIT VYAS svyas0...@gmail.com wrote:
Dear
No Proper work
On 10/5/10, Paul Schreiner schreiner_p...@att.net wrote:
funny!
Luckily, I haven't had any of my editors convert the
characters to smileys!
It would make it VERY distracting.. although
Dear Rajasekhar
Please use u Sumif Formulas.
Regards
Sumit Vyas
On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju
rajasekhar.prahar...@gmail.com wrote:
hi Excel Guru,
Please assist me in this concern .
Attached are two sheets Task distribution orginal and other sheet
Dear
SX0123456789X
On 10/6/10, Jai jaihumtu...@gmail.com wrote:
I need VBA Passward in Excel , Because When Anybody open in excel file he
want VBA Passward .
Thaks in Advance
--
Thanks For Mail.
--
Dear Mr. Ayush Jain
One Word Name You : - *Matrix EXCEL *
Congratulations Ayush Jain. Really Very proud of you man.
Regards
Sumit Vyas
On 10/5/10, Aindril De aind...@gmail.com wrote:
Hey Ayush!! You haven't responded to Neil's email
Where is the Treat Man
Dear Vijay
Very Good explain by you
Thanks
On 10/5/10, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Dear Ankit,
There is no Direct formula to convert numbers into text.But there are some
add-ins available in the websites. just google for text to numbers converter
in excel add-in.
Once
Dear
No Proper work
On 10/5/10, Paul Schreiner schreiner_p...@att.net wrote:
funny!
Luckily, I haven't had any of my editors convert the
characters to smileys!
It would make it VERY distracting.. although cheerful!
Paul
- Original Message
From: ta...@tinusz.hu
Dear,
Please
Select A Row
Press Ctrl + F
Alt + P
Find What :- Space Key 5 To 10
Replace With :- Blank
Click Replace All
Please try it
On 9/25/10, Jai jaihumtu...@gmail.com wrote:
Dear Groups Member,
I want to Remove the Space, In Cloum C , Sheet Attach, Please Help me.
Thanks for
( In Excel - Macro Platform )
Formula
*=VlookupData+input+logic+international) , ( world,moon,sun,galaxy) (all
talent ) True *
Ans
Ans =*Mr. DILIP*
Regards
Sumit Vyas
On 9/28/10, ayush jain jainayus...@gmail.com wrote:
Hi Dilip,
You deserve this appreciation in the form of poem. we
Please use application in macro coding.
On Tue, Sep 14, 2010 at 4:50 PM, عمر omar27...@gmail.com wrote:
*Range(A i + 2).* = a2
*Resize(1, 6)** = a2:f2*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-mac...@googlegroups.com] *On Behalf Of *neil johnson
*Sent:* Tuesday,
Dear,
Right Click Cell
Format
Number Tab
Select Number
decimal place is 0
ok
Regards
Sumit Vyas
+919755549483
On Sat, Sep 11, 2010 at 8:00 PM, Saurabh Patel
saurabh.pa...@in.aegisglobal.com wrote:
Change the cell format to Number by right clicking on cell.
Regards,
Saurabh Patel
1. Start Microsoft Excel.
2. Press ALT+F11 to start the Visual Basic Editor.
3. On the *Insert* menu, click *Module*.
4. Type the following code into the module sheet.
Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
Dim Dollars, Cents, Temp
YES
On Sat, Jul 31, 2010 at 1:28 AM, shashank bhosle
catchshashankbho...@yahoo.co.in wrote:
Hi,
Is it possible to crack the password for the excel window.
--
--
Some important links for excel users:
1.
good
On Thu, Jul 22, 2010 at 10:27 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Hi There,
See attached file.
Warm Regards,
Harmeet Singh
IT Analyst
McKinsey Company
http://www.facebook.com/Harmeeet
On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal ravepat...@gmail.comwrote:
good
On Wed, Jun 2, 2010 at 4:52 PM, prabhakar thakur prabhakarthak...@gmail.com
wrote:
Dear,
Please find the attached your query.
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
On Wed, Jun 2, 2010 at 12:37 PM, Ashish Khandelwal
4everash...@gmail.comwrote:
Dear
Local Area Network Working Possibale
Yes I try Success
On Mon, Jan 11, 2010 at 5:48 PM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi Anant,
I don't think this is possible in XL. It is standard procedure in Access.
Can you use that instead?
Regards - Dave.
can see the data change according to my
requirement?
Thanks in Advance,
Ramesh
On Jan 7, 4:33 pm, ankur ankurpande...@gmail.com wrote:
hi sumit
please check the attached file
if any other modification needed?
thanks
On 1/7/10, SUMIT VYAS svyas0...@gmail.com wrote
Dear Solved
Password Creack
Ask
Any Body
please ask me formulas
=sumit(a1,vyas,2,false)
Breack Password This Sheet
On Sat, Jan 9, 2010 at 3:34 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Cliff,
Just change the cell format to Time. Explained in the attached image.
Best
Dear Nandkumar kakvipure
This Password Creak Firs Mr.t Sandeep
Second Mr. Ankur
Third Mr. Sumit Vyas
Fourth Nandkumar
Thanks For You You Are A Batter.
i learning excel.
help me
thanks
On Fri, Jan 8, 2010 at 9:58 AM, Nandkumar kakvipure
nandkumar.hindust...@gmail.com wrote:
Hello
check my attachment
On Thu, Jan 7, 2010 at 5:53 PM, Alokeshwar Tiwary
alokeshwar.tiw...@yahoo.com wrote:
See attached, there is a new column 'Range' with a conditional formula.
Use the same to categorize in range and then use a pivot table to get
required results.
Dear All,
Please Ask Me
How To Coding In Excel
Exsampel
Code Report Enter Code Report Gen rate
101Sale 101CollectionReport 100% Ok
How This Is Possible In Excel Without Micro.
I Make Program Excel This Future .
--
Dear Madhu
This Sheet Not A Formulas V Lookup Ok
On Wed, Jan 6, 2010 at 8:17 PM, madhu nair madhuna...@gmail.com wrote:
Hi SUmit,
I added Vlookup, i think thats what you need, check attached sheet,
On Wed, Jan 6, 2010 at 7:07 PM, SUMIT VYAS svyas0...@gmail.com wrote:
Dear,
I Make
requiremnet
On 1/7/10, SUMIT VYAS svyas0...@gmail.com wrote:
Dear Madhu
This Sheet Not A Formulas V Lookup Ok
On Wed, Jan 6, 2010 at 8:17 PM, madhu nair madhuna...@gmail.com wrote:
Hi SUmit,
I added Vlookup, i think thats what you need, check attached sheet,
On Wed
40 matches
Mail list logo