That formula is doing the same as required !!
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, July 1, 2015 at 9:22:39 AM UTC+5:30, Kumar Bhanushali wrote:
*Dear Mandeep,*
Please
Dear Kumar,
Deciding min Max level based on 3 month data is bit unscientific,you need
to have at least 6 months data. Based on data provided by you, I have
answered your queries.
As mentioned by you GEOFORCE is external warehouse. It is not clear if the
stock at other location is replenished
Hi,
Any one looked at it?
On Wednesday, April 15, 2015 at 3:13:43 PM UTC+1, kumar wrote:
Hi,
Just want to solve the questions with analysis.
please find the enclosed attachment and answer the question. I also trying
to solve. But needed Gurus help.
Thanks
--
Are you =EXP(E:RT) or
Dear Friend Dhaval,
Thanks for your comments. As per the given requirement i thought this would
be the suitable coding. May be I am not understand you exact requirement
properly. If possible could you please let me know you requirement clearly
once again so that I can try to help you to solve the
Try this...
Press Alt + F8 Run macro, on prompt enter date for which you are updating
data..macro will copy data from daily data sheet to main sheet...
Cheers!!
On Mon, Mar 2, 2015 at 3:53 PM, Dhaval Shah todhavals...@gmail.com wrote:
ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ??
Warm
ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ??
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@gmail.com*
On Mon, Mar 2, 2015 at 3:52 PM, Dhaval Shah todhavals...@gmail.com wrote:
THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I
THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I
UPDATE ITS PASTE WRONGLY
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@gmail.com*
On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth michaelvino...@gmail.com
wrote:
Hi Dhaval Shah,
Hi Dhaval Shah,
Please find the attached macro file.
Regards,
MV
On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote:
Dear Friends
Pls find attached file of my work
In sheet two sheets one is main sheet another is daily data
in main sheet yellow mark is the
Dear Sriram,
find the attached file.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, November 25, 2014 4:52:28 PM UTC+5:30, sriram ji wrote:
Dear Guru's
If Forecast Deviation Answered on
Hi mandeep.
I have to compare prices of different varieties in various markets across
markets. Mostly the price comparison is on daily/weekly/Monthly/Yearly
basis and thier absolute change or diffrence between two dates.
But in the above formula mentioned by you,i have to select dates for
right click to select all sheets, then use Find Feature.
On Saturday, August 16, 2014 8:29:28 AM UTC+3, Kaushik wrote:
Hi Team
In the attached excel file I want to do the following to obtain the
desired result
1. I want to find each cell in whole workbook and to see its repeating
But what u want to do with this data ?
prince
On Wednesday, June 5, 2013 6:50:19 PM UTC+5:30, Patil M G wrote:
HI Team Excel Experts
I am learning Excel and new to Macro coding. I want to create attached
INPUT FILE Format into Output Format...always INPUT FILE have huge
data,
=MID(A1,(FIND(5,A1)),6)
Regards,
Vijay
On Fri, Apr 12, 2013 at 12:00 PM, Prince prince141...@gmail.com wrote:
=IF(LEFT(A1,1)=B,LEFT(A1,6),)
On Thursday, April 11, 2013 10:16:28 PM UTC+5:30, Kaushik wrote:
Hi Team,
I need a formula to find anything starting from 5 in a cell and to take 6
=IF(LEFT(A1,1)=B,LEFT(A1,6),)
On Thursday, April 11, 2013 10:16:28 PM UTC+5:30, Kaushik wrote:
Hi Team,
I need a formula to find anything starting from 5 in a cell and to take 6
digit right of the cell starting from 5 as below.
Eg.
DataDesired Result
ABC 500012
Hi
you can visit here to learn all loop in vba
http://excelpoweruser.wordpress.com/2011/07/26/looping-in-vba/
Thanks
Rajan.
On Friday, 26 October 2012 02:26:27 UTC+5:30, Greg wrote:
Hi,
I would like your help in writing a simple macro that will perform a
For/End loop around a .Range
Hi Henning deschka,
Please paste this into C1.
=SUMPRODUCT(--(($A$1:$A$10=1)+($B$1:$B$10=1)*($C$1:$C$1023400)))
Regards
Prince
On Tuesday, October 9, 2012 6:56:51 PM UTC+5:30, Henning Deschka wrote:
Hi NG,
I need to insert a function into cell D1 with an Excel2007 macro that
executes
try this and drag the same at the end of ur range with criteria
=SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,O15)
regards
prince
On Monday, September 3, 2012 5:17:27 PM UTC+5:30, rambo wrote:
Dear all,
--
Regards
Rambabu. G
--
Join official facebook page of this forum
Hi
Thanks for the link, however is it possible to do this job via VBA?
Regards
Shekhar Sharma
On Fri, Apr 20, 2012 at 8:33 PM, ChilExcel chilexcel...@gmail.com wrote:
Please see
http://www.minipdf.com/
I tried it and it works fine ...jpg at xls
Chilexcel
2012/4/20 Shekhar Sharma
See: http://www.xcelfiles.com/VBA_InsertImgs.html
Kris
--
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 not get
quick attention or
Hey Kris,
Thanks for the quick response, however I am looking for the code for not
just adding the image in excel.
I want to use the the data available in that picture to further make the
changes in excel.
Example:
I had the data set available in excel like, result out of 100:
Student Name
Please see
http://www.minipdf.com/
I tried it and it works fine ...jpg at xls
Chilexcel
2012/4/20 Shekhar Sharma shekhar1...@gmail.com
Hey Kris,
Thanks for the quick response, however I am looking for the code for not
just adding the image in excel.
I want to use the the data available in
Hi Vasant,
I am trying to create a macro to do this below task to avoid manual efforts.
For more details please refer the below email.
Here is my code-
Sub Movefiles()
Dim a As Integer
Dim fso, f2
With Application.FileSearch
.LookIn = C:\LLF\ Range(A1).Value
.FileType =
Why can't you use Copy paste command.
Why you require a macro for this.
Regards,
Kishan Reddy, K
On Aug 18, 9:04 pm, kamal shah kamal...@gmail.com wrote:
Hi group
I have piece of XML for example below which i need to repeat it for 1
times
May I request one of expert to develop a
Just Try this code.
Dim CELL As Variant
Range(B2:B105).Select
For Each CELL In Selection
If IsEmpty(CELL) Then
With CELL.Offset(0, -1).Interior
.ColorIndex = 3
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
Else
With
Absolutely perfect mate :P may thanks
Alex cargill
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Kishan Reddy, K
Sent: 16 August 2010 08:13
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Help needed in changing
On Tue, May 4, 2010 at 11:40 PM, Rajeev Nandan rajeev1...@gmail.com wrote:
Dear Group Member,
Please help me to calculate incentive for each technician. I have
tried to apply countifs but could not succeeded. Please suggest if
there is any other way to calculate incentives else help me to
Hi Rajeev,
More info please.
Dave
Date: Tue, 4 May 2010 23:42:37 +0400
Subject: $$Excel-Macros$$ Re: Help needed to calculate incentive
From: rajeev1...@gmail.com
To: excel-macros@googlegroups.com
On Tue, May 4, 2010 at 11:40 PM, Rajeev Nandan rajeev1...@gmail.com wrote:
Dear Group
Hi All
I have data in my excel sheet as follows'
*Status * *a* *b* *c* *d*
*e* *g* *h* *i**
*Work in
Progress sfdf
Hi Saiprasath,
Copy the data which you want to change automatically in second sheet and
choose paste special - Paste Link.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/7/09, sai prasath
Hey Sai,
You just have to use the formula, it's very easy ...you have to link the
files together...I don think we need any macro for this thing...
Suppose if you want the value of cell 'A1' of sheet 1 in the cell B1 of
sheet2 then just got to B1 of sheet 2 and type = and then go to sheet 1
and
Subject: $$Excel-Macros$$ Re: Help Needed for Debit Credit entries
Hi Pradeep (Deep)
Attached workbook has the scenario provided by you along with two possible
solutions based on identiying the rows and coloring of the rows.
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile
:* Thursday, September 17, 2009 9:38 AM
*To:* excel-macros@googlegroups.com
*Cc:* excel-macros group; pradeep170...@gmail.com
*Subject:* $$Excel-Macros$$ Re: Help Needed for Debit Credit entries
Hi Pradeep (Deep)
Attached workbook has the scenario provided by you along with two possible
*please provide a sample file*
Thanks Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Wed, Sep 16, 2009 at 7:44 PM, Deep pradeep170...@gmail.com wrote:
Dear Freinds,
I am attaching one file which contains debit credit
amounts in same column. But previous
Hi Pradeep (Deep)
Attached workbook has the scenario provided by you along with two possible
solutions based on identiying the rows and coloring of the rows.
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
Hi.
Select range and execute the following macro :
Sub test()
Dim c As Range
For Each c In Selection
If c.Value Then
c.Value = Application.Clean(c.Value)
c.Value = Application.Trim(c.Value)
End If
Next c
End Sub
Best regards.
More precisely :
Sub test()
Dim c As Range
For Each c In Selection
If c.Value Then
c.Value = Application.Clean(c.Value)
c.Value = Application.Trim(c.Value)
c.Value = Application.Substitute(c.Value, , )
End If
Next c
End
hi daniel
i tried your code its working perfectly thanks
but wht in this situation in attached sheet i want to remove all non wanted
charters at the end of email ids...
Thanks
Ashish
--~--~-~--~~~---~--~~
the zip is password protected
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Aug 12, 2009 at 5:42 PM, Iqbal Shaikh iqbal.sw...@gmail.com wrote:
Hi All
Can u help me for open the XL file which is in ZIP.
Iqbal
If i understand your query correctly , then the solution would be as
follows
=
1. write the formula in J2 ... = I2 - D2
2. Copy the cell J2 (Ctrl + C)
3. Select the range J2 to J121
4. Paste (Ctrl + V)
but since this is a very very very beginner
Hi Abdul
Can you please provide an example. your file has the folloing fields
Time of Call Recorded
(T1) Tech.Deputed Time
Tech. Arrival Time
Tech. Responding Time
Work Start Time Work Finish Time (T2)
Restoration Time (T2-T1)
Restoration Time In Mins.
can you tell us what should be the final
Hi Vivek,
Thank you for such a quick response. What I want to do is to calculate the
response time for the complete sheet with a single formula. As you have
noticed that I am right now using individual formula to get the figure in
each cell. By the end of month this sheet will be about 400 long
Hi Iqbal,
You need password to RAR file or password remover for RAR files….
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those
Hi Vinod,
Please download from below Link..
MSPress_Step_By_Step_MS_Office_Access_2003_EBook.pdf
http://rapidshare.com/files/248961528/MSPress_Step_By_Step_MS_Office_Access
_2003_EBook.pdf
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Hello,
This is the solution (attachment files) as per the query I understood.
(Pl. append data in 'Main.xlsx' the same will reflect in 'dupli.xlsx'.)
If not happened please mail me back. I will show you the another way.
Thanks regards,
Dhananjay Pinjan
(Mob. No. 9922255533)
On 7/24/09,
@googlegroups.com
Sent: Tuesday, June 23, 2009 4:14:35 PM
Subject: $$Excel-Macros$$ Re: Help Needed !!!
On Tue, Jun 23, 2009 at 11:21 PM, Hems coolh...@gmail.com wrote:
Hi Harmeet,
Kindly help me with attached macro. I want view the call details
after inserting call id in form 3. but its
1. Select all phone numbers and name the range as Phone_Number (Select
the range from the first phone number till row number 65536) 2. Select the
cell from where first phone number is ans name the cell as
First_Phone_Number 3. Above steps to be followed only once 4. Click on the
button It
*Type phone number without any space, bracket, etc. then change the format
of the cells. Rigt ClickFormat CellsNumber TabSelect Special in Cetegory
Choose English (U.S.) in LanguageChoose Phone Number in Type Click Ok.*
On Tue, Jun 9, 2009 at 5:08 PM, amrahs k amrahs...@gmail.com wrote:
Can you simply format the cells to SPECIAL then choose PHONE NUMBER?
Norman
On Tue, Jun 9, 2009 at 7:38 AM, amrahs k amrahs...@gmail.com wrote:
Dear Harmeet and Team,
I have attached a sample file for your reference with my simple query.
Could you please look into this and advice me to
Hi, check the below link to write the excel sheet to Word. The code in the
article does not satisfy all your requirements, you might want to tweak the
code according to your requirements. Also to know the details of saving word
to PDF, you might want to check in some PDF forums too. They will have
so kind of u Sharad .yeh if u can help me writing macro bt also the fact
is m nt so familiar about macros and all.
luking forward...
On Sun, Nov 16, 2008 at 10:34 PM, Sharad Sharma [EMAIL PROTECTED]wrote:
Hi Suneeta,
One way of protcting all xl files in a folder is to write a macro
50 matches
Mail list logo