Dear Experts
In an excel book, each sheet is named with the designation of the employee
and that particular sheet contains the names of that particular designation.
I placed two combo boxes on the userform, how to link the corresponding
data into the comboboxes with an option that choosing a
Dear Excel-Macro Family
I have Two sheet Like Data Deptwise , Data Sheet Data are comes
from our ERP Software , Deptwise Sheet having Deptemnt wise expenses
consoliated
i have GL Code in my Data sheet but i donot have Deptwise sheet
this gl code automatically add to my Deptwise
Dear Experts,
Attached is an Sample file Excel-2003 with 03 Sheets linked with each
others. Sheet1 is linked with data from Sheet2 by Hlookup / index formulas
and it has Data Validation at Cell H1, too. Chart in this Sheet1 is also
linked with Data at Sheet2.
Sheet3 will get data by Paste
Dear Noorain,
Can we use any other formula which will work little fast, as it takes
little more time while I applied in my original data.
On Mon, Jan 23, 2012 at 10:11 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Excel Lover,
Please check and change value of Cell E1.
Thanks
Dear Excel_Lover,
See attached sheet.
Actually used formula is an array function, which take little time
comparison to Normal Function.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Dear Sam Mathai Chacko
On target! It worked very well.
The quotes rules is a little confuse and I never read anything about
it in Excel books.
Thanks a lot.
Nathan
On 22 jan, 17:16, Sam Mathai Chacko samde...@gmail.com wrote:
Nathan,
The REAL problem is as I mentioned in using the quotes.
Mr NOORAIN ANSARI
Congratulations. It works very well.
See alternative solution at Sam Mathai Chacko reply.
Thanks a lot.
On 22 jan, 14:20, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Nathan,
Problem #1 is that your MainProcedure has strLeter as the parameter name,
but you test for
Hi Friends,
I have a excel file which have data in hindi, I have to translate in
english, there is any softwear or way to solve my problem plz tell me.
Thanks Regards
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Dear Zafar,
First copy and value paste in New Sheet..
Again copy and Select data of new sheet and Format paste .
Hope it will help to you.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Dear Bheema,
use below code format for your query..
Private Sub cmdsave_Click()
With Sheet1
with Userform1
.Range(F3)=.Name
.Range(F4)=.Design
.Range(F6)=.Dob
.Range(F7)=.Doj
.Range(F8)=.DOR
.Range(F11)=.DOR
.Range(E11)=.DOJ
.Range(D29)=.Pay
.Range(H29)=.GP
.Range(B40)=.Pay
.Range(E40)=.GP
Dear Chandra,
Please explain more
On Mon, Jan 23, 2012 at 1:48 PM, chandra sekaran duraichan...@gmail.comwrote:
Dear Excel-Macro Family
I have Two sheet Like Data Deptwise , Data Sheet Data are comes
from our ERP Software , Deptwise Sheet having Deptemnt wise
The sender of this email is registered with Naukri.com as Trigent Software
Limited (Staffing Division)
*Experience required for the Job:* 3 - 10 years
*Job Location:* Gurgaon
Apply
Dear Excel Guru !!!
I need the solution for a query. Suppose i am having below data.
I am having start date, End Date. I want data should be filtered
copy to another location. I am able to do so by applying fileter but
facing its taking all the record while i want visible records only..
Dear Prince,
Please select filtered data, press alt+; then copy and paste
or
Select Data and press ctrl+g and click on Visible cells only then copy and
paste
Hope it will help to you.
On Mon, Jan 23, 2012 at 5:05 PM, prince sethi prince.seth...@gmail.comwrote:
Dear Excel Guru !!!
I need
Maybe??
Sub twodecimalscopy()
Sheets(Sheet2).Cells.Style = Comma
Sheets(Sheet1).Cells.Style = Comma
Sheets(Sheet1).Copy
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Zafar Iqbal
Sent: Monday, January 23, 2012 2:58 AM
To: excel-macros@googlegroups.com
Subject:
Here's the macro. File attached too.
Sub FormatNumbersTo2Decimals()
Dim wks As Worksheet
Dim rng As Range
For Each wks In ThisWorkbook.Worksheets
For Each rng In wks.Cells.SpecialCells(2, 1)
If IsNumeric(rng.Text) Then
rng.NumberFormat = 0.00
Dear Sir,
I have already tried it. Yet, as per your instructions, I did the same
again. There are two problems.
First is that decimals in print view are surely two only but in actual
it may remains more than two in background. If we increase decimals
places it will be viewable, again. I need
Without looking too close, try /30
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Monday, January 23, 2012 4:06 AM
To: excel-macros@googlegroups.com ; Sam Mathai Chacko
Subject: Re: $$Excel-Macros$$ Proportionate calculation
Dear sir,
I attached the excel
Here's how you do it with code
Regards,
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 6:58 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
PFA
On Mon, Jan 23, 2012 at 6:54 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
Dear Prince,
Please select filtered data, press alt+; then copy
You will have to enter 01-05-2012, or you will have to enter 05-Jan-2012
Otherwise, everything works fine. By the way, what's with all days
having 30 days? Jan has 31, Feb never has 30..
If you really are worried about the 30, use
Private Sub CommandButton1_Click()
Dim lngDays As Long,
Well, this should round it. Replace it in the file I sent earlier.
Sub FormatNumbersTo2Decimals()
Dim wks As Worksheet
Dim rng As Range
For Each wks In ThisWorkbook.Worksheets
For Each rng In wks.Cells.SpecialCells(2, 1)
If IsNumeric(rng.Text) Then
Dear Mr. *Sam Mathai Chacko,*
Your macro works fine in parent file. When I copy Sheet1 only to new file,
data in graph table needs a little attention. Dates are converted to
numbers (23-Jan-2012 becomes 40931 and so on).
Macro converted grapgh data to 2 decimals in parent file. However, in
copied
Sir, Now, graph table is more correct.
Last thing remaining is date format in graph. Right now, In graph
table, date format (23-Jan) is converted to number format (40931). I
need 23-Jan instead of 40931.
Regards,
Zafar Iqbal
On Jan 23, 4:57 pm, Sam Mathai Chacko samde...@gmail.com wrote:
Well,
Finds last row and last column and formats range and copies sheet1 to new
book without formulas.
Sub CopyShtwithTWOdecimals()
For i = 1 To Sheets.Count
With Sheets(i)
lr = .Cells.Find(*, Cells(Rows.Count, Columns.Count) _
, , , xlByRows, xlPrevious).Row
lc = .Cells.Find(*, Cells(Rows.Count,
Excellent Solution SAM
On Mon, Jan 23, 2012 at 7:15 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Here's how you do it with code
Regards,
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 6:58 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
PFA
On Mon, Jan 23, 2012 at 6:54
We have to define i, lr, lc and mf. I tried with Dim i as integer, Dim
lr as Inetger, Dim lc as Integer. But what is mf? I do not know.
Please help. Thanks
On Jan 23, 5:26 pm, dguillett1 dguille...@gmail.com wrote:
Finds last row and last column and formats range and copies sheet1 to new
book
Hi Noorain,
Unable to find anything as reference in tools option in Acrobat 9.
Please suggest.
Regards,
Kaushik
--
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
Zafar, your numbers are all coming correct. For the date format, all you
need to do is format the series to d-mmm
Why do you need a macro for that? Keep the custom format, and it will
always remain.
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 8:15 PM, Zafar Iqbal ziqba...@gmail.com wrote:
We
Which means you do not have Acrobat 9 installed. The code will not work
without that.
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 8:27 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi Noorain,
Unable to find anything as reference in tools option in Acrobat 9.
Please suggest.
Regards,
Hi Sam,
I have Acrobat 9 installed in my system.
Pls suggest.
Regards,
Kaushik Savla
--
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
Hi Sam,
In your email there is no attachment or print screen.
can you please let me know which window you are getting?
Regards,
Kaushik
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Sir, Thanks for it. Just please guide me about i, lr, lc and mf. I
think that first three are to be defined as integer. What will be mf?
macro will run when we define these items.
Regards,
Zafar Iqbal
On Jan 23, 6:07 pm, Sam Mathai Chacko samde...@gmail.com wrote:
Zafar, your numbers are all
From what Don intended, I believe it is
Dim i as long, lr as long, lc as long, mf as range
Regards,
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 8:47 PM, Zafar Iqbal ziqba...@gmail.com wrote:
Sir, Thanks for it. Just please guide me about i, lr, lc and mf. I
think that first three are to
Thank you soo much (Noorain Sam)
On Jan 23, 6:44 am, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Excellent Solution SAM
On Mon, Jan 23, 2012 at 7:15 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Here's how you do it with code
Regards,
Sam Mathai
Thanks, Sam. That is correct. I USUALLY do use option explicit.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Monday, January 23, 2012 9:21 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)
Oops. I also should have added this to change formulas to values before copy
sheets(“sheet1”).usedrange.value=sheets(“sheet1”).usedrange.value
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Monday, January 23, 2012 9:21 AM
To: excel-macros@googlegroups.com
hi Noorain
here with attached Excel sheet more informattive
Regards
chandru
On Mon, Jan 23, 2012 at 6:46 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Chandra,
Please explain more
On Mon, Jan 23, 2012 at 1:48 PM, chandra sekaran
duraichan...@gmail.comwrote:
And for printing
Private Sub CommandButton2_Click()
Worksheets(Page1).PrintOut
Worksheets(Page2).PrintOut
End Sub
Regards,
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 6:44 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Bheema,
use below code format for your query..
Try this :
=OFFSET(INDEX($F$6:$F$80,MATCH(E5,F6:F80,0),1),,2,COUNTIF(F:F,E5)) with CSE
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Jan/Mon/2012 12:00
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
I pasted this line in macro last portion as mentioned below:-
Sheets(“sheet1”).UsedRange.Value = Sheets(“sheet1”).UsedRange.Value
Sheets(Sheet1).Copy
End Sub
I am getting message Complie Error: Variable not defined with yellow
selection at Sheet1.
Please help in this matter. Thanks
Regrads,
Hi Experts
I have a data of 1000 names in Sheet2, required dropdown validation in
sheet1, cell A1
query: if i type some name on cell A1 then it display only the related on
that name. it's an urgent
--
*Regards,*
*Dhartikumar Sahu*
Sr.Database Manager - Institutional Equities
* **IDBI
Dear Dhartikumar
Kindly see if below example solves your quarry
*xample: Creating a drop down list with data on a different worksheet*
For help with this example, see the image above.
1. Enter the following data into the correct cells on*Sheet 1* or a
worksheet:
*E1* - The Cookie
thanks priyanka
but i need another way
when i type manually on particular cell , auto pickup related that value.
(e.g. if i type *choc *and click on drop down arrow it will display the
related name of* choc.*
On Tue, Jan 24, 2012 at 12:40 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear
43 matches
Mail list logo