Dear
Please use Pivot Table
Regards
On Fri, Apr 15, 2011 at 12:50 PM, Umed Singh wrote:
> 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.
>
> --
>
> -
=A2&" "&B2&" "&C2 = FSD COM com
On Tue, Mar 8, 2011 at 7:17 PM, Paul Schreiner wrote:
> another alternative actually reduces the wear on the ol' keyboard.
>
> =A2&" "&B2&" "&C2
>
> accomplishes the same thing!
>
> Paul
>
> --
> *From:* "davidpk...@verizon.net"
> *To:
very nice speech Mr. Paul Sir.
Regards
Sumit Vyas
On Tue, Mar 8, 2011 at 7:07 PM, Paul Schreiner wrote:
> 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?)
Very Nice Mr. Kalyan
On Wed, Jan 19, 2011 at 1:43 PM, Kal xcel 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 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 awar
send file
On Sat, Dec 18, 2010 at 7:28 PM, Rajiv Kumar 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 start
send file
On Wed, Nov 17, 2010 at 4:20 AM, Johnnyboy5 wrote:
> 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 - but not before.
>
already give solution
On Fri, Oct 29, 2010 at 3:16 PM, Born to Win wrote:
> Hello,
>
> Please Use COUNTA() Function or check Attached File.
>
> Thanks,
> Chandrabhan Singh
>
>
>
> On Fri, Oct 29, 2010 at 2:43 PM, Rakesh Sharma wrote:
>
>> *Dear All,
>>
>>
>> Please find the attachment and let me
Dear Girish
Please find herewith enclosed file.
regards
sumit
On Tue, Oct 19, 2010 at 10:32 AM, girish kumar
wrote:
> Hi Krishna,
>
> see file attached, in that second sheet u see in b column i used Left
> function and in c column Vlookup
>
> left function i used =left(A2.13)
>
> and vlookup
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
Xls 2003
Select Data
Copy Data
Past Data
Past Only Filter Data
On Fri, Oct 15, 2010 at 2:04 PM, NOORAIN ANSARI wrote:
> Dear Experts,
>
> Please solve my problem. How can we copy only filtered data in Excel.
>
> --
> Thanks in advance..
> Noorain Ansari
>
> --
>
> ---
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
CR-MSP-63
Mr. Naveen
Please explain to Mr. Shrinivas.
i am request please provide vba code.
Regards
Sumit
On Thu, Oct 14, 2010 at 5:17 PM, shrinivas shevde
wrote:
> Please Can I know how to do it?
>
> shrinivas
>
>
>
> --
> Date: Thu, 14 Oct 2010 13:16:47 +0530
> Subject:
gb
On Wed, Oct 13, 2010 at 2:18 PM, kaza deepu wrote:
> Hi Kashan Abbas,
>
> Find attached it may helps you.
>
>
> On 10/13/10, Kashan Abbas wrote:
>>
>> Dear All,
>>
>>
>> I have extracted a report from sap .The first column has been merged with
>> multiple information for which i need separe
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
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 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.
>
> Thanks
>
>
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 wrote:
> Dear Group,
>
> There is a opening for one person with the following skill t
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
E
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 Ta
On Wed, Oct 6, 2010 at 10:41 AM, SUMIT VYAS wrote:
> Dear
>
> No Proper work
>
>
>
>
> On 10/5/10, Paul Schreiner wrote:
>>
>> funny!
>> Luckily, I haven't had any of my editors convert the
>> characters to smileys!
>>
>>
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
Dear
SX0123456789X
On 10/6/10, Jai 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
No Proper work
On 10/5/10, Paul Schreiner 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"
> > To: excel-m
Dear Vijay
Very Good explain by you
Thanks
On 10/5/10, P.VIJAYKUMAR 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 you download th
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 wrote:
>
> Hey Ayush!! You haven't responded to Neil's email
>
>
> Where is the Treat Man!!!?
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 wrote:
>
> Hi Dilip,
>
> You deserve this appreciation in the form of poem. we all
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 wrote:
>
> Dear Groups Member,
>
> I want to Remove the Space, In Cloum C , Sheet Attach, Please Help me.
>
> Thanks for Advance.
>
>
> -
Please use application in macro coding.
On Tue, Sep 14, 2010 at 4:50 PM, عمر 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, September 14,
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.
>
Table Complited
Go to data
cleck privot table
select range
finist
On Sat, Aug 28, 2010 at 11:05 AM, Pankaj Kumar wrote:
> Hi, All,
>
>
> I am fresher in ms excel & wanted to learned how to prepared Pivot table &
> report in Msexcel
>
> --
> *Warm Regards
> Pankaj kumar
> M: 9899816107
> e
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
Di
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 u
good
On Thu, Jul 22, 2010 at 10:27 PM, Harmeet Singh wrote:
> 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 wrote:
>
>> Please help to add the produ
On Wed, Jul 7, 2010 at 10:21 PM, Mahesh parab wrote:
> Hi Sajid
>
> Click on sheet1 tab
> right click & select view code
> copy below mention code
>
> enter value in c8 & press enter cursor will move to G14
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Address = "$C$8" Then
good
On Wed, Jun 2, 2010 at 4:52 PM, prabhakar thakur 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.com>wrote:
>
>> Dear friend
Dear
Local Area Network Working Possibale
Yes I try & Success
On Mon, Jan 11, 2010 at 5:48 PM, Dave Bonallack
wrote:
> Hi Anant,
> I don't think this is possible in XL. It is standard procedure in Access.
> Can you use that instead?
> Regards - Dave.
>
> --
> Date
Ye To Me Bhi Dhund Raha hu
Koi Help Karo Yaar !
On Mon, Jan 11, 2010 at 3:29 PM, Anant Shelke wrote:
>
> Hi,
>
> I want some help and little bit
> challenging
>
> I WANT TO WORK IN ONE FILE IN MULTIPLE LOCATIONS
> AND ALL THE CHANGES MADE BY ALL USERS IT TO BE SAVE IN THAT FILE
> IF IT IS POSS
x27; sheet. Is there a way i can see the data change according to my
> > requirement?
> >
> > Thanks in Advance,
> > Ramesh
> >
> > On Jan 7, 4:33 pm, ankur wrote:
> >> hi sumit
> >>
> >> please check the attached file
> >>
>
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 wrote:
> Hi Cliff,
>
> Just change the cell format to Time. Explained in the attached image.
>
> Best Regards,
> --
> DILIP K
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
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.
>
>
>
>
t;
> On 1/7/10, SUMIT VYAS wrote:
> > Dear Madhu
> >
> > This Sheet Not A Formulas V Lookup Ok
> >
> >
> >
> >
> > On Wed, Jan 6, 2010 at 8:17 PM, madhu nair wrote:
> >
> >> Hi SUmit,
> >>
> >> I added Vlookup
Dear Madhu
This Sheet Not A Formulas V Lookup Ok
On Wed, Jan 6, 2010 at 8:17 PM, madhu nair 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 wrote:
>
>> Dear,
>>
>&g
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 .
--
---
45 matches
Mail list logo
