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))
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 i
>
> 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)
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
paul,
Thanks for sharing a good link.
Regards,
Kishan Reddy, K
On Tuesday, October 23, 2012 4:55:03 PM UTC+5:30, Paul Schreiner wrote:
>
> First of all, this is not the forum for this type of distribution.
> Secondly, the information is a "hoax"
> and has been passed
base 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
&
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,
>
e life span of a particular 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:
lds(10) = txtnonmths
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 titl
elationships.
Even 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
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 wrote:
> hi friends,
>
> i want to make ledger accounts in ms acc
lowing search string
"Lotus 1-2-3 keyboard equivalents"
Regards,
Kishan Reddy, K
On Nov 9, 1:25 pm, ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥
wrote:
> Dear all
>
> I have a small problem in MS Excel
> in a particular column I want to enter only " + " sign
> i
Hello Akhilesh,
Elaborate your exact requirement.
Kishan Reddy, K
On Oct 28, 5:10 pm, airen 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,
ation")
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.
,
Kishan Reddy, K
On Sep 8, 9:37 am, Shankar Bheema 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 for
).
and each orgon inturn 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 exce
.
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 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 no
There is no sample data in the attached file.
Regards,
Kishan Reddy, K
On May 8, 5:22 pm, Rajesh K R 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
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 wrote:
> Hey guys,
>
> its been 2 days but not even single reply. is it too tough or its not at all
> p
Send me the generated code, let me try it. (replace the username and
password with X).
Regards,
Kishan Reddy, K
On Feb 17, 10:39 pm, ashish koul wrote:
> write
> on error resume next
> on the line above in the code which is giving errors see if that helps
>
>
>
>
olumns.
Break the Deposit date 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 wrote:
> Dear all,
>
> I am facing a problem i
To all the members & families
Happy Deewali
Kishan Reddy, K
On Nov 4, 8:54 pm, Chandra Shekar
wrote:
> Hi Ashish,
>
> WISH U THE SAME
>
> Thanks
>
> Chandra Shekar B
>
>
>
> On Thu, Nov 4, 2010 at 6:08 PM, ashish koul wrote:
> > Wishing you all A
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"
wrote:
> I had gone through the excel file,
> I think, the format has to be changed, so as to enable stock sp
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 wrote:
> Dear all
>
> Can someone help me in this or provide a better spreadsheet?
>
>
>
> On Mon, Oct 18, 2010 at 8:47 AM, Yahya wrote:
&
.
Regards,
Kishan Reddy, K
On Oct 18, 5:42 pm, "me!" 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
> da
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 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 wrote:
> How do I get the text box to line feed on pressing enter instead of
> th
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
wrote:
> Hi,
>
> I need a help to connect excel file to a database in Acces
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 wrote:
> Dear All,
>
> Can you tell me what is IRR (Internal Rate of Return Calculation) in Excel
> and how to use it?
>
&g
for entering the password.
4. Then check this password against your keyword and make the
worksheet visible.
for any clarity you can contact me.
Regards,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Sep 3, 3:31 pm, Kal xcel wrote:
> Dear Experts,
>
> I need a help...How to p
Mr Santanu,
You can use this code
Sub AddWorksheet()
Dim SheetName As String
SheetName = InputBox("Enter the sheet Name")
Sheets.Add
ActiveSheet.Name = SheetName
End Sub
Regards,
Kishan Reddy, K
On Sep 3, 10:48 pm, santanu_ca wrote:
> Hi
> I want to inser
Sort the data (column A ascending & Column C Descending)
for example you are having data from A2 to C100
In sheet 2, column C use Vlookup function (in C2)
=vlookup(a2, $A$2:$C$100, 3, false)
Regards,
Kishan Redyd, K
On Sep 3, 10:48 pm, None wrote:
> I have a sheet that has 2 columns of data.
try from menu bar command
Windows -> freeze panes
May this be useful.
Regards,
Kishan Reddy, K
On Sep 3, 4:08 am, jjsmd 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 fr
Hai Dave,
Congrats,
Keep the spirit.
Regards,
Kishan Reddy, K
On Sep 3, 10:01 am, Ayush 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 t
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 wrote:
> Hi Every
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").Sele
Rajesh,
check the files "copy of create cells.xls"
regards,
Kishan Reddy, K
On Aug 30, 7:03 pm, Rajesh D wrote:
> Hi
>
> can some one help me on the attached worksheet query
> --
> Thanks
> Rajesh
>
>
just use space between 9:00 & AM
Regards,
Kishan Reddy, K
On Aug 30, 8:03 pm, Pankaj Kumar wrote:
> Dear all,
>
> When i use the forumulla it shows value pls find attached sheep
> --
> *Warm Regards
> Pankaj kumar
> M:9899816107begin_of_the_skype_highlightin
Alternate proposal
Instead of creating the links in each sheet dynamically,
I think it is easy to create a customised toolbar with two buttons for
your purpose,
which can be used on any sheet, that is active.
Regards,
Kishan Reddy, K
On Aug 23, 7:21 pm, shariqcoo...@gmail.com wrote:
>
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 Re
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 wrote:
> Dear Kishan
,
Kishan reddy, K
On Aug 21, 2:07 pm, Jai 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 u
The only difference is you will get 1, instead of Yes.
Regards,
Kishan Reddy, K
On Aug 21, 12:56 pm, shariq khan 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 “Dat
is opened.
Still have any problem contact me.
Regards,
Kishan Reddy, K
On Aug 21, 10:07 am, VILAS CHAVAN 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,
&g
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
wrote:
> Hi Expe
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 wrote:
> Hello everyone,
>
> I am trying to wr
d this into three steps
for your better understanding and
to make it is for little modification by yourself.
Bye.
Regards,
Kishan Reddy, K.
On Aug 21, 6:13 am, Aindril De wrote:
> Hi Phillip,
>
> Please find attached the solved workbook.
> Do let me know if it helps or you need further he
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 wrote:
> Hi Team,
>
> I need your help in the attched excel.
>
> I have explained everything in attached sheet.
>
>
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 wrote:
> Dear Experts,
>
> I have many data in excel sheet and want to convert the same in Lakh.
>
> Kindly help me how can i
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 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 t
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 Bonall
d. Type ) instead of (.
Regards,
Kishan Reddy, K
On Aug 18, 4:51 pm, Alexander Cargill
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
>
>
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 wrote:
> Deat all,
>
> pls solve my problems.
>
> 1.
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 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
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,
Can you send your application.
I will check once.
Regards,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Aug 1, 9:07 pm, Anju wrote:
> Any Updates ?
>
>
>
> On Sat, Jul 31, 2010 at 7:40 PM, anju wrote:
> > I am using a WebBrowser control in my application. When
Just use Pivot table.
Regards,
Kishan Reddy, K
On Aug 6, 4:29 pm, Sundarvelan N 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
&
Sudhir,
Why can't you use Track changes from Tools menu?
Regards,
Kishan Reddy, K
On Aug 4, 7:51 pm, sudhir kumar 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
>
>
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 wrote:
> Santiago Afonso wrote:
> > Hello.
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 wrote:
> Hi Angelo,
>
> Have a look at the attache
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
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 wrote:
> Kishan
>
> Thanx, for your help.
>
> But kindly tell me if i save macro in This Workbook,
>
> Will it work for other
, provided we know how to use them.
Regards,
Kishan Reddy, K
On Jul 31, 1:17 am, Nadine S 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 that mat
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 wrote:
> Hi Team,
>
> The password is correct "STPIInvoices" in this up to STPII is CAPS letter
> nvoices is small latters.
>
attach the form, let me check.
Kishan Reddy, K
On Jul 28, 10:16 pm, b 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 to u
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 wrote:
> Hi,
> Can u check this this can be helpor not
>
> On Wed, Jul 28, 2010 at 11:21 PM, Ahmed Honest wro
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 wrote:
> You're welcome.
>
> However, both works. 1st one is havin
Code is not opening, The password might be wrong.
Kishan Reddy, K
On Jul 27, 10:21 am, Nagendra Modupalli 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
to paste them back in column B
Simple.
Bye
Kishan Reddy, K.
On Jul 27, 9:42 pm, flebber 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 cu
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"
wrote:
> Can anyone provide me the formula/s for below query? I have four
> columns. Company, Product, Date and Weight. What I n
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 wrote:
> Dear Members
>
> I have some problem with macro recording,
>
> after entering macro
in D
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 wrote:
> I need to delete rows from one sheet that match an id in another
> sheet. He
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 wrote
with generated code.
Regards,
Kishan Reddy, K
On Jul 24, 9:10 pm, dage wrote:
> Hi all,
>
> I read from various forums/websites that it appears VB and VBA is
> highly similar and if I first learn VB then programming in VBA will
> have practically no problems at all. Is this correct ?
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 wrote:
> Dear Friends,
>
&g
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 wrote:
> Hi team,
>
> when we do v
Hello,
Open the Office clipboard: From Menu select Edit -> Office clipboard.
Office clipboard will appear on the right side.
Goto sheet 1 and select Data, and Press Control+C, Data will appear on
Office Clipboard.
Repeat the above step for all sheets.
Then use the Paste All Option on Office cl
end me the excel file and access DB to
me.
Regards,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Jul 19, 10:20 am, debasish wrote:
> I am a novice in macro... could you please elaborate more on this..
>
> Thanks & regards,
> Debasish
>
> On Jul 18, 8:40 p
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 wrote:
> Hello All
>
> I need Help to Making Chart with time and date
>
> on Date and Time
>
> Please He
80 matches
Mail list logo
