Happy New year to one and all.
With best wishes,
Kishan Reddy, K
On Tuesday, December 31, 2013 3:24:13 PM UTC+5:30, friend wrote:
Wish you a happy a glorious new year 2014 and all the best for the coming
year
--
-
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
You can use the the links (linked tables) as like original table.
Means,
You can directly open the link and paste the data.
You can refer the linked table in queries, forms, reports and even macros
modules.
Regards,
Kishan Reddy, K
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Dileep,
You can contact me, I am sending my contact details through mail.
Regards,
Kishan Reddy, K
On Wednesday, October 2, 2013 6:34:34 PM UTC+5:30, Bv Dileep wrote:
Thanks for your quick response. And please do let me know in this forum is
anyone resides in Hyderabad and if you are ready
All websites will get Indian companies stock prices data from nseindia.com
and bseindia.com.
If you want to get stock quotes of indian companies based on stock code you
can get that data directly from the above websites sites, instead of
depending on third party sites.
Regards,
Kishan Reddy K
option.
Regards,
Kishan Reddy, K
On Tuesday, August 14, 2012 2:18:44 PM UTC+5:30, Prince Dubey wrote:
Hi Group,
I have a project which is running fine on my system with XP OS but the
same project giving error of Out of Memory 7 on other system with XP
platform. I am using VBA and Acess
software.
Also, You can't project the life span of a software, just like you can't
assess the life span of your own life.
So, enjoy the fun of softwares and also the life.
Regards,
Kishan Reddy, K
On Sunday, August 12, 2012 2:01:17 AM UTC+5:30, (%Allmydreams%) wrote:
Dear All,
What
where around the graph
for information purpose or add a suitable title reflecting the from date
and to date.
This is the way I found a solution, when i faced the same problem.
Regards,
Kishan Reddy, k
On Thursday, August 9, 2012 7:17:50 PM UTC+5:30, Divaker Pandey wrote:
Hi Expert,
can any one
a skeleton.
If you are comfortable with forms and reports, please design it and
send a sample access file, so that I can add the required VBA code to
suit your purpose.
Regards,
Kishan Reddy, K
On Dec 6, 4:40 pm, Veer virbhardwaj...@gmail.com wrote:
hi friends,
i want to make ledger accounts
though functions can be generally used here, It is advisable to
use queries or VBA code.
Send me a sample file with exact requirement, so that I can look up
and guide you.
Your requirement can be exactly and directly addressed using queries
VBA code.
Regards,
Kishan Reddy, K
On Dec 6, 8:58 am
rst.Fields(11) = txtnondays
rst.Fields(12) = txtnetyrs
rst.Fields(13) = txtnetmths
rst.Fields(14) = txtnetdays
rst.Update
End Sub
Regards,
Kishan Reddy, K
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
Lotus 1-2-3 keyboard equivalents
Regards,
Kishan Reddy, K
On Nov 9, 1:25 pm, ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥
vadnalaki...@gmail.com wrote:
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
Hello Akhilesh,
Elaborate your exact requirement.
Kishan Reddy, K
On Oct 28, 5:10 pm, airen airen1...@gmail.com wrote:
Hi Experts,
Is there any way to record a macro between applications?
Thanks
Akhilesh Airen
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise
)
appAccess.OpenCurrentDatabase (D:\XXX\ABCD.MDB)
appAccess.Visible = True
appAccess.docmd.openquery
appAccess.Quit
End Sub
Revert back, if any comments, issues
Regards,
Kishan Reddy, K
On Sep 14, 3:31 pm, ja...@macstop.co.uk ja...@macstop.co.uk wrote:
Hi,
I have
,
Kishan Reddy, K
On Sep 8, 9:37 am, Shankar Bheema shankar.n...@gmail.com wrote:
What is the procedure to develop reports basing on the excel database
through UserForm.
Report generation in the sense, not in column and rows.
It would be look like a form in word document
is made up of different types of cells (basic
controls).
This is called OBJECT ORIENTED PROGRAMMING or EVENT DRIVEN
PROGRAMMING.
Regards,
Kishan Reddy, K
--
--
Some important links for excel users:
1. Follow us
I think, it is time you to study error handling procedures.
Example.
ON ERROR GO TO
RESUME
RESUME NEXT
Go Ahead.
Regards,
Kishan Reddy, K
On May 9, 1:15 am, hanumant shinde arsfan2...@yahoo.co.in wrote:
Hey guys,
its been 2 days but not even single reply. is it too tough or its
There is no sample data in the attached file.
Regards,
Kishan Reddy, K
On May 8, 5:22 pm, Rajesh K R rajeshkainikk...@gmail.com wrote:
Hi Experts
I need code to find the cells in column A having date above the date
specified in C1 then select the entire column and delete it. Then
loop until
.
If you still face the problem, please attach the file to locate the
problem.
Regards,
Kishan Reddy, K
On May 8, 4:20 pm, Yogesh Gohil yashr...@gmail.com wrote:
Hi Guys,
Some time when i want to import any data in Access then i get an error * is
not a valid name. Make sure that it does
into two columns, ie Deposit Month and Deposit
Date.
For filtering on a particular date, first filter on particular month
and then select the date.
Regards,
Kishan Reddy, K
.
On Nov 7, 7:44 pm, Ramkesh Maurya sunscel...@gmail.com wrote:
Dear all,
I am facing a problem in filter (in column N
To all the members families
Happy Deewali
Kishan Reddy, K
On Nov 4, 8:54 pm, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hi Ashish,
WISH U THE SAME
Thanks
Chandra Shekar B
On Thu, Nov 4, 2010 at 6:08 PM, ashish koul koul.ash...@gmail.com wrote:
Wishing you all A Very Happy
I will come back on this again, In a little while
Regards,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Oct 19, 12:10 pm, Yahya yahya...@gmail.com wrote:
Dear all
Can someone help me in this or provide a better spreadsheet?
On Mon, Oct 18, 2010 at 8:47 AM, Yahya yahya...@gmail.com
The file was sent to you through mail.
For any thing you can mail me or Can catch me on google talk.
Regards,
Kishan Reddy, K
On Oct 22, 11:26 am, Kishan Reddy, K
kishanreddy.kethire...@gmail.com wrote:
I had gone through the excel file,
I think, the format has to be changed, so as to enable
.
Regards,
Kishan Reddy, K
On Oct 18, 5:42 pm, me! infinite.space@googlemail.com wrote:
Hi, I have the following code that calculates the number of days
(excluding Sundays) between two dates, and ideally I'd like to add
another parameter to my function to allow me to exclude non-working
Mr Brain,
A macro can be written such that
1. It will copy certain number of rows (one page full) to another
sheet (example sheet2)
2. In sheet2 it will be formatted for printout (such that C/F, B/F,
Page header, Page footer etc.)
(counters will be maintained for page numbers, C/F, B/
F
Mr Rasheed,
We can write a macro such that can pass through number of dates,
compare with the current date and return the details of the bills to
be paid today in a message box.
Regards,
Kishan Reddy, K
On Sep 17, 9:46 pm, Abdul Rasheed rashee...@gmail.com wrote:
HI
Can any one have idea how
Right click the Text Box, Select properties.
set the EnterKeyBehavior Property to true and
set the multiline property to true.
That's it.
Bye
Regards,
Kishan Reddy, K
On Sep 12, 8:09 pm, Johnnyboy5 intermediatec...@gmail.com wrote:
How do I get the text box to line feed on pressing enter
D1, E1, F1
Now use IRR function =IRR(A1:F1)
This is only sample example.
Regards,
Kishan Reddy, K
On Sep 9, 1:17 pm, Usha Negi ushadhvin...@gmail.com wrote:
Dear All,
Can you tell me what is IRR (Internal Rate of Return Calculation) in Excel
and how to use it?
Regards,
Usha
Deepak,
Let me know, why you want to create the form in Excel and link it to
access.
You can directly create a form in access which is very simple.
Regards,
Kishan Reddy, K
On Sep 9, 10:48 am, Deepak Pal Singh deepaktheind...@gmail.com
wrote:
Hi,
I need a help to connect excel file
Mr Neil,
You need not write any code for this.
Just open the form in VBA, select the text box1 and right click it,
select properties.
In that
Set Autotab = true
set maxlength = 2
do the same thing for text box2.
Regards,
Kishan Reddy, K
On Sep 2, 1:17 pm, neil johnson neil.jh
Hai Dave,
Congrats,
Keep the spirit.
Regards,
Kishan Reddy, K
On Sep 3, 10:01 am, Ayush jainayus...@gmail.com wrote:
Hi Group,
I am glad to announce that Dave Bonallack has topped in posting for
the month of Aug'10 with 67 Posts (9% of group posts). He has done it
repetitively for two
try from menu bar command
Windows - freeze panes
May this be useful.
Regards,
Kishan Reddy, K
On Sep 3, 4:08 am, jjsmd jschwart...@gmail.com wrote:
Hi:
I am new to excel and I was wondering hiw I would do the following.
I have an excel worksheet with names of people in a sheet going from
Mr Salva,
Just open visual basic editor (tools - macros - visual basic editor)
Double click on This workbook in project explorer.
copy paste this code in code window.
Private Sub Workbook_Open()
Sheets(Sheet2).Select
Range(A494).Select
End Sub
Regards,
Kishan Reddy, K
On Sep 2, 9:28
Rajesh,
check the files copy of create cells.xls
regards,
Kishan Reddy, K
On Aug 30, 7:03 pm, Rajesh D rajesh...@gmail.com wrote:
Hi
can some one help me on the attached worksheet query
--
Thanks
Rajesh
create cells.xls
18KViewDownload
just use space between 9:00 AM
Regards,
Kishan Reddy, K
On Aug 30, 8:03 pm, Pankaj Kumar rajputpanka...@gmail.com wrote:
Dear all,
When i use the forumulla it shows value pls find attached sheep
--
*Warm Regards
Pankaj kumar
M:9899816107begin_of_the_skype_highlighting
You can use Edit - goto (special) command to select specific cells in
a particular range.
check this command.
Once you feel comfortable, record a macro.
Then, if you require any further enhancements, reply me.
One important thing, people tend to ignore unknown persons.
Regards,
Kishan Reddy
and
to make it is for little modification by yourself.
Bye.
Regards,
Kishan Reddy, K.
On Aug 21, 6:13 am, Aindril De aind...@gmail.com wrote:
Hi Phillip,
Please find attached the solved workbook.
Do let me know if it helps or you need further help.
I have added some other features other
Dear David,
Just carefully replace,
RefersToR1C1:==Sheet1!R2C1:R12C6
with
RefersTo:=Selection
You have four ranges, so do the replace four times for each range.
Regards,
Kishan Reddy, K
On Aug 21, 1:04 am, David Stubbs davidmstu...@gmail.com wrote:
Hello everyone,
I am trying
Mr Pankaj,
1. The code is password protected.
2. Let me Know where is the Submit Button. (in which sheet)
3. Let me know precisely what are the cells that you want to check
for blanks.
Regards,
Kishan Reddy, K
On Aug 21, 10:36 am, Intelligent But Crazy secrets...@gmail.com
wrote:
Hi
.
Still have any problem contact me.
Regards,
Kishan Reddy, K
On Aug 21, 10:07 am, VILAS CHAVAN vilaschav...@gmail.com wrote:
how we can schedule to auto open excel application on given time and run
macro.
Please let me knw and knw the solution on that.
--
With Best Regards,
Vilas Chavan
difference is you will get 1, instead of Yes.
Regards,
Kishan Reddy, K
On Aug 21, 12:56 pm, shariq khan shariqcoo...@gmail.com wrote:
Hi All,
I need your help, as I’m unable to solve the problem which I’m going
to explain you guys……..
Please refer the attached the excel with two tabs “Data
,
Kishan reddy, K
On Aug 21, 2:07 pm, Jai jaihumtu...@gmail.com wrote:
Hello Experts
Can you Tell me that how can Hide the One Cell in Excel in Sheet.
--
Thanks For Mail.
--
--
Some important links for excel users
Mr. Dilip,
Mr Jai has; requested only to hide the contents of the cell without
any protection. So is my answer.
This way you can only hide the contents of the cell, but U can't
protect against alteration.
Regards,
Kishan Reddy, K
On Aug 21, 6:20 pm, Dilip Pandey dilipan...@gmail.com wrote
of decimal places)
Use this
=Round(B1/10,2)
It will round to two decimal places as we have given 2.
Regards,
Kishan Reddy, K
On Aug 20, 8:53 am, OPSHARMA opsharma...@gmail.com wrote:
Dear Experts,
I have many data in excel sheet and want to convert the same in Lakh.
Kindly help me how can
Change this line
Dim ltext As LOng, curRow As Long
AS
Dim ltext As String, curRow As Long
Regards,
Kishan Reddy, K
On Aug 19, 10:24 pm, hemant shah hemanthin...@gmail.com wrote:
Hi Team,
I need your help in the attched excel.
I have explained everything in attached sheet.
Regards
of (.
Regards,
Kishan Reddy, K
On Aug 18, 4:51 pm, Alexander Cargill zanderman1...@googlemail.com
wrote:
Hi all I was wondering if you could help. I have a sheet with entrys into a
cell that looks like this:
AAECHO::DELTA (422|279) K24
AALPHA::HOTEL (447|319) K34
ALPHA::FOXTROT (445|320) K34
As dave said, there is a formula in column
Click on the formula.
Carefully copy the formula except '=' symbol
type the following in the same cell.
=iserror(FORMULA, 0, FORMULA)
Replace the FORMULA with the copied formula
Regards,
Kishan Reddy, K
On Aug 19, 9:27 am, Dave Bonallack davebonall
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
1.Try to create a macro for import with action transferdatabase,
provide the required options.
If any problem contact me,
Regards,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Aug 16, 10:11 am, ALAM aftab.ala...@gmail.com wrote:
Deat all,
pls solve my problems.
1
With CELL.Interior
.ColorIndex = 10
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
End If
Next
You may need to change the colorindex as per your pallate.
Regards,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Aug 16, 6:05 am, Alexander
Just save it as (using save as) excel file.
Then you can open it in Excel 2007.
Regards,
Kishan Reddy, K
On Aug 13, 1:48 pm, harris a harris...@gmail.com wrote:
Hello,
I am not able to open lotus formatted files (with extension WK1) using
Excel 2007. However, I am able to open it with Excel
Just use Pivot table.
Regards,
Kishan Reddy, K
On Aug 6, 4:29 pm, Sundarvelan N nsund...@gmail.com wrote:
Hi Abhishek,
Could you help in one more task also.
That is under each Team leader i need to have corresponding agents name.
Please help.
Thanks
Sundarvelan
On Fri, Aug 6
Can you send your application.
I will check once.
Regards,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Aug 1, 9:07 pm, Anju anjulav...@gmail.com wrote:
Any Updates ?
On Sat, Jul 31, 2010 at 7:40 PM, anju anjulav...@gmail.com wrote:
I am using a WebBrowser control in my
Try this,
But check it may have adverse effects,
Private Sub CommandButton2_Click()
UserForm1.Show 0
End Sub
Also check for help on SHOW method ( modal/nonmodal forms).
Share with me if you have any problems
Bye,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Aug 5, 6:38 am
As per my policy, replacing/deleting any rows/values is not a good
idea.
I will simply use pivot table or subtotals command on the data and get
the results in another sheet.
Regards,
Kishan Reddy, K
On Aug 4, 4:11 pm, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Angelo,
Have a look
First of all,
Let me know why you want you use such type of objects, in excel, when
the same can be done through simple formulas and simple macros.
Let me understand the purpose.
Regardds,
Kishan Reddy, K
On Aug 2, 12:26 pm, Stuart Redmann dertop...@web.de wrote:
Santiago Afonso wrote
Sudhir,
Why can't you use Track changes from Tools menu?
Regards,
Kishan Reddy, K
On Aug 4, 7:51 pm, sudhir kumar sudhir.p...@gmail.com wrote:
Thanks stuart for ur reply, but, macro record is work for when u r using
same type of command again and again, but this time issue is different
, provided we know how to use them.
Regards,
Kishan Reddy, K
On Jul 31, 1:17 am, Nadine S n8dine4ma...@yahoo.com wrote:
Is there a way to find a duplicate with 3 criteria? I know it can be done
with
one. Assuming there is data in columns A, B, C. I need to find if there are
any duplicates
Just open the workbook in which you have created the macro.
It will work in generally.
Regards,
Kishan Reddy, K
On Jul 30, 2:32 pm, Rehan Baig rehan.bai...@gmail.com wrote:
Kishan
Thanx, for your help.
But kindly tell me if i save macro in This Workbook,
Will it work for other workbooks
Mr Abhishek Jain,
There is problem with the function when the following dates are given.
29/01/2010
30/01/2010
31/01/2010
Please check and modify it.
Regards,
Kishan Reddy, K
On Jul 30, 9:47 am, Abhishek Jain abhishek@gmail.com wrote:
You're welcome.
However, both works. 1st one
Hello,
Let me know,
How many number of REPs are there?
Why do you want to put them in different sheets?
Regards,
Kishan Reddy, K
On Jul 29, 2:11 pm, Venkatesh Narla nvenki...@gmail.com wrote:
Hi,
Can u check this this can be helpor not
On Wed, Jul 28, 2010 at 11:21 PM, Ahmed Honest
attach the form, let me check.
Kishan Reddy, K
On Jul 28, 10:16 pm, b wer61...@gmail.com wrote:
I have an Excel workbook w/ a VBA menu to pops up a userform to write
values back to a worksheet in the workbook. Sometimes, the userform
locks Excel and it has to be abended. I suspect its due
The solution was sent through mail.
Is the solution working fine, reply back.
Regards,
Kishan Reddy, K
On Jul 29, 8:33 am, Nagendra Modupalli naga14...@gmail.com wrote:
Hi Team,
The password is correct STPIInvoices in this up to STPII is CAPS letter
nvoices is small latters.
Please let me
Hello,
Obviously you will have a data sheet on which you have created the
graph.
Just right clik on the graph and select source data
It will show the data on which graph is drawn.
Just reselect the range that you want and press OK
done.
Bye
Kishan Reddy, K.
On Jul 28, 4:43 am, Steve
vlookup(A2, SHEET2!$A$2:$B$10,2,FALSE)
Here you will get 1 in column D
Use filter command and fiter for 1's and delete them.
Bye,
Kishan Reddy, K.
On Jul 28, 12:40 am, calibansfolly calibansfo...@gmail.com wrote:
I need to delete rows from one sheet that match an id in another
sheet. Here's
Instead of storing the macro in personal macro workbook, select this
workbook.
There may a problem with the personal work book.
Regards,
Kishan Reddy, K
On Jul 27, 1:10 pm, Rehan Baig rehan.bai...@gmail.com wrote:
Dear Members
I have some problem with macro recording,
after entering
Why can't you use pivot table or subtotals commands instead of
formulas
Regards,
Kishan Reddy, K.
On Jul 27, 10:29 am, nkmorri...@hotmail.com nkmorri...@hotmail.com
wrote:
Can anyone provide me the formula/s for below query? I have four
columns. Company, Product, Date and Weight. What I need
in column B
Simple.
Bye
Kishan Reddy, K.
On Jul 27, 9:42 pm, flebber flebber.c...@gmail.com wrote:
I have a column containing cells which house several delimited values
and a dollar value. I want to be able to remove the delimited values
and leave the dollar value in the cell in currency
Code is not opening, The password might be wrong.
Kishan Reddy, K
On Jul 27, 10:21 am, Nagendra Modupalli naga14...@gmail.com wrote:
Hi Team,
I have Invoices printing macro.It is printing row wise.I want to modify
customer wise.Can you please help me.Thanks in advance.
And also i have
Dear Hari Nair,
If the values in quality column are unique then copy and paste the
following formula in column G2
=VLOOKUP(E2,RATE!$C$2:$D$8,2,FALSE)
for best performance sort the Rate sheet on quality column.
Kishan Reddy, K.
On Jul 22, 4:20 pm, HARI NAIR hari.shrin...@gmail.com wrote:
Dear
col_index_num is mandatory for vlookup function, range_lookup is
optional.
If range_lookup is not given it will take it as TRUE.
One important point for using Vlookup is that the table array should
be sorted on the first column.
On Jul 21, 8:31 pm, preeti vora preeti86v...@gmail.com wrote:
Hi
the excel file and access DB to
me.
Regards,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Jul 19, 10:20 am, debasish debasis...@gmail.com wrote:
I am a novice in macro... could you please elaborate more on this..
Thanks regards,
Debasish
On Jul 18, 8:40 pm, Kishan K
Remove the heading date in column a1
select the data and go to menu - insert - chart..
follow the wizard.
regards,
Kishan Reddy, K
On Jul 18, 4:59 pm, VILAS CHAVAN vilaschav...@gmail.com wrote:
Hello All
I need Help to Making Chart with time and date
on Date and Time
Please Help me
72 matches
Mail list logo