Dear Experts,
I want rounding method in excel 2003
when i typed 124.90 the rounding should come 120
when i typed 125.10 the rounding should come 125
when i typed 129.90 the rounding should come 125
5 digits upward or downward rounding
Regards
Sajid Memon
Hi,
Assume that your input data is A2 cell and apply the below formula in B2
cell.
=A2-MOD(A2,5)
Refer the attachment for details.
---
Ms.Exl.Learner
---
On Wed, Nov 9, 2011 at 2:11 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
Dear Experts,
I
Hi,
I want to know how we can consolidate data in different worksheets into one
worksheet.
Regards
Smitha/ Senior Finance Executive
Speridian%20Logo
World Class Solutions to Power Global Businesses
Office: 0471-2527525/2700526
mailto:smitha.kum...@speridian.com
Dear Experts,
I want rounding method in excel 2003
when i typed 124.90 the rounding should come 120
when i typed 125.10 the rounding should come 125
when i typed 129.90 the rounding should come 125
5 digits upward or downward rounding
Regards
Sajid Memon
--
FORUM RULES (925+ members
Hi Team,
I'm not sure whether this tip has been shared already.
To reduce Excel file size drastically, save as in .xlsb format which
uses binary features and you can do all the operations as we do in
normal excel file.
Please let me know what is the difference between these two formats.
Your
Dear all
I have a small problem in MS Excel
in a particular column I want to enter only + sign
if I press = sign also it should come to + sign only
anybody can assist me please
Regards
V.Kiran Kumar
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread
Sub method2()
Dim i, j, k, s As Long
s = Sheets.Count
Sheets.Add After:=Sheets(Sheets.Count)
For i = 1 To s
Sheets(i).Select
j = 2
' it will copy till last used row automatically
k = ActiveSheet.UsedRange.Rows.Count
Rows(j : k).Copy
Sheets(Sheets.Count).Select
Hi Sajid,
Refer the reply given to another post for the same subject.
---
Ms.Exl.Learner
---
On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj msma@gmail.com wrote:
Dear Experts,
I want rounding method in excel 2003
when i typed 124.90 the rounding
Thanks for your reply.
Any way to consolidate data other than using macros.
I don't know how to apply the code which you mentioned in your mail
Regards
Smitha
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Wednesday,
use this command
=floor(a1,5)
Mothilal.J[image: image.png]
On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj msma@gmail.com wrote:
Dear Experts,
I want rounding method in excel 2003
when i typed 124.90 the rounding should come 120
when i typed 125.10 the rounding should come 125
You need to post your file or a least your code
How does a jew workbook differ from a gentile workbook?
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Clinton James
Sent: Tuesday, November 08, 2011 7:55 PM
To: MS EXCEL AND VBA MACROS
Subject:
if, as you say, you ONLY want + in the column then
right click sheet tabview codeinsert this. change column to suit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Or Target.Column 4 Then Exit Sub
If Target + Then Target = +
End Sub
Don Guillett
SalesAid Software
Do you want to copy a range from each sheet to a master or do a summary from
different sheets?
Don Guillett
SalesAid Software
dguille...@gmail.com
From: smitha.kumari
Sent: Tuesday, November 08, 2011 10:38 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Consolidate data in
Thank you all!
You help me a lot!
and sorry if I have not be clear, I need to practice my english...
bye
2011/11/8 Sam Mathai Chacko samde...@gmail.com
In Noorain's solution, the name of the defined name formula would be *
SheetNames*
Also, you can find here a UDF through VBA as well
Are you sure you are not using the Excel Viewer?
Regards,
Sam
On Wed, Nov 9, 2011 at 5:45 PM, Rohit Tikhe rmti...@gmail.com wrote:
Can you please help me, as I not getting the VB Editor in Excel 2007
** **
** **
** **
Rohit
** **
--
FORUM RULES (925+ members
Hehe, Don, I'm sure he meant 'new'
Clinton,
Is there any sheet movements in your macro? Maybe worth posting your VBA
code.
Regards,
Sam Mathai Chacko
On Wed, Nov 9, 2011 at 6:36 PM, dguillett1 dguille...@gmail.com wrote:
You need to post your file or a least your code
How does a jew
Thank you very much Paul. Worked very well. I appreciate your time.
John
On Tue, Nov 8, 2011 at 2:33 PM, Paul Schreiner schreiner_p...@att.netwrote:
Try this:
Sub Make_Sheets()
Dim vCnt, vNum
ThisWorkbook.Activate
Sheets(Form).Select
Application.ScreenUpdating = False
Thank you Don, your help is very much appreciated.
John
On Tue, Nov 8, 2011 at 2:57 PM, dguillett1 dguille...@gmail.com wrote:
Use this macro and be sure to save your file as an .xls or .xlsm
Sub MakeSheetsFromVehicleList()
Sheets(Vehicle List).Select
Dim c As Range
Dim lr As Long
lr =
Hehe!
I knew that
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Wednesday, November 09, 2011 9:53 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help: excel changes macro assignment
Hehe, Don, I'm sure he meant 'new'
Clinton,
Is there
Hi Mothilal,
Yours is the exact and simplified solution.
In fact, I forgot that function and I was unable to recollect it while
replying to the OP's question. But, your reply helped me to recall it.
Thanks Dude...
---
Ms.Exl.Learner
---
On Wed, Nov 9,
Dear all
Can you help me out how to remove zero from a sheet:
Example:
A=0
B=0
C=0
D=2
E=3
F=56
G=0
H=67
I=9
J=0
K=0
I just want to remove zero from start and end (A,B,C,J,K) but should
not remove the zero from between number,
Please if any one have any idea how to make vba function for this
if you just want to do a sum of all the same cells across multiple sheets,
you could use something like this
=SUM(Sheet2:Sheet5!A2)
Regards,
Sam Mathai Chacko
On Wed, Nov 9, 2011 at 6:59 PM, dguillett1 dguille...@gmail.com wrote:
Do you want to copy a range from each sheet to a master or
Hi Excel Experts,
We need some data analyst, Please see below all description related to job,
Interested candidate reply me with their Resume.
Experience:
2 - 4 Years
Location: Noida
Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA
Industry Type:
Hi,
I want to remove a certain text from every sentence
Technology Company:David
Technology Company:Arya
Technology Company:Jose
I need only the name, Technology Company: has to be removed from every
cells.
Please reply.
Regards
Smitha
--
FORUM RULES (925+ members already
Select the column...go to find and replace...(CTRL+F) type the technology
company in space for find and keep blank in the space provided for
replace...then replace all.
Sandeep Chhajer.
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: smitha.kumari
Yes, I am sure about that.
I am using MS Excel 2007
Rohit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sam Mathai Chacko
Sent: 09 November 2011 20:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Not getting the VB Editor in
Dear Sir,
Sorry for the late reply. Its still not working.
On 3 November 2011 13:16, ashish koul koul.ash...@gmail.com wrote:
Sub copy_first_sheet_from_different_workbooks_to_single()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim fld As Object, fil As Object
Dim
Use This command
[image: image.png]
Thanks with
Mothilal.J
--
FORUM RULES (925+ 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
The result should be david and not Technology company
Regards
Smitha/ Senior Finance Executive
Speridian%20Logo
World Class Solutions to Power Global Businesses
Office: 0471-2527525/2700526
mailto:smitha.kum...@speridian.com smitha.kum...@speridian.com
From:
If name in a cell is Simon in a work sheet 2 then the designation already
allotted for Simon in worksheet 1 should appear there in worksheet 1 or
wherever in the same work book.
Please show me the formula for that
Regards
Smitha
--
FORUM RULES (925+ members already BANNED for
you can use find replace.
On 10 November 2011 10:39, smitha.kumari smitha.kum...@speridian.comwrote:
Hi,
** **
I want to remove a certain text from every sentence
Technology Company:David
Technology Company:Arya
Technology Company:Jose
** **
I need only the
Hello Smitha;
If you need a formula use,
=REPLACE(A1,1,FIND(:,A1),)
Or
Select your data, press CTRL+H;
Find What: **:*
Click Replace All
Hope this helps
Haseeb
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Hi Haseeb,
This will not consolidate the name , only the hours. Isn't it?
Regards
Smitha/ Senior Finance Executive
Speridian%20Logo
World Class Solutions to Power Global Businesses
Office: 0471-2527525/2700526
mailto:smitha.kum...@speridian.com smitha.kum...@speridian.com
From:
PFA the sheet with name and designations.
Required is, if I type the name in another worksheet, the designation column
for the name should show as in the attachement
Regards
Smitha/ Senior Finance Executive
World Class Solutions to Power Global Businesses
Office: 0471-2527525/2700526
Thanks Ashish.
Please specify why 2 ,0 is used
=VLOOKUP(A1,Sheet3!A:B,2,0)
Regards
Smitha
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Thursday, November 10, 2011 1:03 PM
To: excel-macros@googlegroups.com
Subject: Re:
There are clear instructions not to post queries related to password
hacks. Please ensure forum decorum.
Sam
On Nov 10, 12:15 pm, jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I had made one PPT file few days ago and now i had forgot the password
of that PPT. Hence request you anybody
36 matches
Mail list logo