De Premor -
My apologies for not responding sooner but I've been out of commission
It works perfectly :-D And I found that when I just copied and pasted the
images it works and seems to provide a bit more flexibility :-)
Would you mind explaining the macro you created, so that I'll be able to
bé trần văn - Unfortunately that didn't work because when I tried sorting
the rows the images aren't moving accordingly :-(
On Sunday, August 25, 2013 11:28:17 AM UTC-4, bé trần văn wrote:
>
> *You try this.
> *
> 2013/8/25 Prince >
>
>> No Chaya i dont thin
Eugene,
I need to display the images inline. Is there a way to do that with
hyperlinks?
On Wed, Aug 21, 2013 at 12:18 AM, Eugene Bernard
wrote:
> Instead of inserting the images, why can't you use hyperlinks !!!.
>
> Regards
> Eugene
>
>
> On Tue, Aug 20, 2013 at 3
t;> http://www.excel4mac.com/2010/01/shortcut-to-access-visual-basic-editor.html
>>
>>
>> On Tue, Aug 20, 2013 at 11:43 AM, ashish koul
>>
>> > wrote:
>>
>>> press alt +f11
>>>
>>>
>>> On Tue, Aug 20, 2013 at 11:25 AM,
2013 at 11:43 AM, ashish koul
> > wrote:
>
>> press alt +f11
>>
>>
>> On Tue, Aug 20, 2013 at 11:25 AM, P.VIJAYKUMAR
>>
>> > wrote:
>>
>>> Respected Chaya Cooper,
>>>
>>> Please check the following link and see wh
I guess that's good to know. Unfortunately I'm only using this
this computer temporarily, so I'm not able to upgrade the software :-(
On Tue, Aug 20, 2013 at 2:31 AM, P.VIJAYKUMAR wrote:
> Respected Chaya,
>
> Unfortunately macros or VBA interface is not available with
o open it.
Any suggestions?
On Tuesday, August 20, 2013 1:55:04 AM UTC-4, vijay wrote:
>
> Respected Chaya Cooper,
>
> Please check the following link and see whether it helps.
> http://excelsemipro.com/2011/05/create-a-list-in-excel-2008/
>
> To view code you can also ope
Ashish,
That's exactly what I needed :-D
Would you mind showing me how to use it?
- Chaya
On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote:
>
> Hi try the attachment . see if it helps
>
>
>
>
> On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar
>
>
uming that I'll probably need to do this :-)
On Tuesday, August 20, 2013 12:16:50 AM UTC-4, prashant wrote:
>
> Hi Chaya, Prabhu,
>
> Done with a simple macro.
>
> Use Control + Shift + A at particular cell where you want to transpose.
>
> This you have to to for every
A tutorial I'm using (to create a multi-select box) suggests right-clicking
on the sheet tab to View Code, but that option isn't being displayed (I'm
running Excel 2008 for Mac). Any suggestions how I can view the code?
My apologies for what is probably a simple issue, but I've been unable to
I'm sorry, I'm not sure I understand what you're saying :-(
On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote:
>
> hi chaya,
>
> hope if u share the file.. it will be so fine to work.
>
>
> Thanks & Regards,
> Prabhu R
>
&g
That's amazing :-D I'm sorry I waited this long to ask ;-)
One question - is there a way to split it up into several rows (for example
5 rows, with 3 columns per row)?
On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote:
>
> Hi Chaya,
>
> You no need to cut an
I often use Excel to organize rows of text (i.e. terminology, examples,
subsets, etc.) and often need to include images in a row. However since
images aren't actually in a specific cell they therefore aren't linked to
the rest of the information in the row, making it impossible to sort the
data
I often have to move cells in order to have them in a row (going across)
instead of in a column (going down). Is there a way to simplify this so
that I don't have to manually cut & paste or move each cell?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,
.
Experts pfa.
Thanks
Regards,
Chaya
The excel learner :-)
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles
Thanks priti for your formula, it will be a new learning era for me with
varities of formula knowledge.
Regards,
Chaya
The excel learner :-)
On Thu, May 30, 2013 at 2:05 PM, Prafull Jadhav wrote:
> Dear XLS,
>
> It is very useful formula and nice formula I was trying the
Thank you so much Dear Xls. I was amazed you have used sum function,
Actually i thought of sum function is used in only in numerical values
calculation. today i came to know it is used in many calculation. thank you
for that.
Thanks to all.
Regards,
Chaya
The excel learner :-)
On Thu
, please find
the attachment.
Thank you so much in advance.
Regards,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
Dear Experts, any Update on this ?
Regards,
Chaya
The excel learner :-)
On Wed, May 22, 2013 at 7:33 PM, Chaya wrote:
> Thanks Abhishek sir. but it will be a long process. i have many more
> files to insert as hyperlink. Can it be automated like -whatever the
> file contain in t
the same A hyperlink will also be created.
thanks once again
chaya
On 5/22/13, Abhishek Jain wrote:
> Yes Chaya, it can be done. But if that is your only issue, I'll suggest a
> simpler alternate option. Save all your files in a folder, store that
> folder on root of any drive,
Yes Abhishek sir. Can it be done by macros. i mean by first inserting
all the files as object in the master file and creating hyperlink to
the object.
can be done like sir ?
:-)
chaya
On 5/22/13, Chaya wrote:
> Thanks David sir and Paul sir for your quick reply. and thanks to all.
>
Thanks David sir and Paul sir for your quick reply. and thanks to all.
No sir the file is to be sent by mails and no network share folder
will contain. Can it be done by macros.
_
Chaya
On 5/22/13, David Grugeon wrote:
> Can they open the files through the network manually while the fi
all (as the A, B, C excel file contains in my computer not the some one
else computer).
Please advice me or provide me solution for this as i don't have to send
all the file across to some one except Master file (Where hyperlink
contains).
Many many thanks in advance to all.
Regards,
Thanks a lot priti.
Regards,
Chaya
The excel learner :-)
On Tue, May 21, 2013 at 3:39 PM, priti verma wrote:
> HI chaya,
> I hope this is what you're asking ...
>
>
> On Tue, May 21, 2013 at 2:59 PM, Chaya wrote:
>
>> Dear Priti,
>>
>>As
Dear Priti,
As always you did the great logical solution. Infact i really don't
understand the formula used for data validation in Level2 (very huge long),
but i have got some more ideas on this.
Thanks a lot.
Now i have small help modification in the attached sheet.
Exapmle : If F2 changes
select in the item, the same corresponding Points should be
drop down in I columns
Ex: if I select 1.02.d then all the items of 1.02.d should be drop down
in the I column.
Thanking you all in advance.
Regards,
Chaya
The excel learner :-)
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Dear sir,
Thanks for the revert. but i not getting you what exactly you mean.
please elaborate sir.
Regards,
Chaya
The excel learner :-)
On Mon, May 20, 2013 at 6:09 PM, Bé Trần Văn wrote:
> I do not know what you do, the help you, if not pleasant, then continue.
> See Atta
of learning macros !
thanks to all
Regards,
Chaya
The excel learner :-)
On Fri, May 17, 2013 at 5:20 PM, Abhishek Jain wrote:
> Firstly, take a breath. Keep calm. Just because you're reading e-books,
> googling for 2 months and you don't know how to use 'Dim'..
there will be some
certain tips or books of guidance which help to undertand the fact for
practicing. Since last 2 months, i have been reading ebooks and googling
for the guidance, and even today, i am struggling in writing codes.
Thanks once again
Regards,
Chaya
The excel learner :-)
On Fri
om where i can understand clearly
the logical coding and can write codes as per the necessity like you all.
Thanks a millions to all.
Regards,
Chaya
The excel learner :-)
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook pa
Hi Priti,
Thank you. your formula contains logic a lot, perfectly working. thanks
once again.
Regards,
Chaya
The excel learner :-)
On Tue, May 14, 2013 at 5:34 PM, priti verma wrote:
> Hi Chaya ,
> PFA,
> without vba
> If it helps
>
>
> On Tue, May 14, 2013 at
Thanks a lot Abhishek, its working great.
Thanks Amit and to all.
Regards,
Chaya
The excel learner :-)
On Tue, May 14, 2013 at 4:31 PM, Amit Desai (MERU)
wrote:
> Please share the main sheet.. I will convert it & send it...
>
> ** **
>
> Best Regards,
>
&g
Thanks Amit,
But i don't want to transpose the datas, please see the attachment.
Regards,
Chaya
The excel learner :-)
On Tue, May 14, 2013 at 4:19 PM, Amit Desai (MERU)
wrote:
> Do Copy & then do Alt E S V E.
>
> ** **
>
> Best Regards,
>
> Amit
Regards,
Chaya
The excel learner :-)
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
Dear Anil sir,
Thank you very much for the same and your time spare in this.
The Datas are not splitting in the solction provided to me. Please check.
Thanks again to all
Regards,
Chaya
The excel learner :-)
On Mon, May 13, 2013 at 3:54 PM, Chaya wrote:
> Dear Anil sir,
>
>
Dear Abhishek Jain and Anil sir, Thanks for the solution, its perfectly
working.
Both the coding are quite different, but a single and right answer
solution.
Thanks to all for the support.
Regards,
Chaya
On Fri, May 10, 2013 at 4:51 PM, अनिल नारायण गवली
wrote:
> Dear Chaya
>
> P
attachment.
thanking you all.
Regards,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles
Awesome, its perfectly working.
Thanks a ton priti for the help.
Regards,
Chaya
On Fri, May 10, 2013 at 10:46 AM, priti verma wrote:
> please see it .
>
>
> On Fri, May 10, 2013 at 10:25 AM, Chaya wrote:
>
>> Hi Priti,
>>
>>Your formulas are ab
- 156320
Thanks a lot priti, hope you got my point.
Regards,
Chaya
On Fri, May 10, 2013 at 10:17 AM, Priti_verma wrote:
> *Hi chaya ,*
>
> *Yes you can do it.Please see the attached file .*
>
> * *
>
> * *
>
> *From:* excel-macros@google
attached sheet solved.
Many many thanks to all.
Regards,
Chaya
On Thu, May 9, 2013 at 7:08 PM, priti verma wrote:
> Hi Chaya,
> Pfa
>
>
> On Thu, May 9, 2013 at 6:30 PM, Chaya wrote:
>
>> Thanks Waheed,
>>
>>Thanks for that, but i dont want
Thanks Waheed,
Thanks for that, but i dont want to split by text to coloumns, i want
with formulas in one cell.
hope you got my point of query.
Regards,
Chaya
On Thu, May 9, 2013 at 6:26 PM, Shaik Waheed wrote:
> PFA sheet solved,
> You can split your data by using "text
formula for seperation and
finding the Min.
Thanks in advance.
Regards,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise
Yes Anil Sir,
I tried your code too. its fine working. Thank you.
Regards,
Chaya
On Thu, May 9, 2013 at 12:37 PM, Chaya wrote:
> Yes Anil Sir,
>
>I tried your code too. its fine working. Thank you.
>
>
> Regards,
>
> Chaya
>
>
> On Thu, May 9, 2
Thanks Abhishek , it is perfect deleting all the row as per cireria.
Regards,
Chaya
On Thu, May 9, 2013 at 12:08 PM, Abhishek Jain wrote:
> Attached.
>
> On Thu, May 9, 2013 at 11:58 AM, Chaya wrote:
>
>> Dear Abhishek,
>>
>>I have a query for deleting en
Dear Abhishek,
Sorry for the late reply.
Yes, the solution provided to me its perfectly working. thank you.
Regards,
Chaya
On Wed, May 8, 2013 at 6:57 PM, Abhishek Jain wrote:
> Here.
>
> On Wed, May 8, 2013 at 6:23 PM, Chaya wrote:
>
>> Dear Experts
>&
elabroated my query in excel sheet.
Thanking you all in advance.
Regards,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise
understand my needs.
Regards,
Chaya
On Wed, May 8, 2013 at 12:23 PM, Chaya wrote:
> Thank you very very much Abhishek Sir And Priti mam.
>
> Once again thank you very much for the solution.
>
>
> Regards,
> Chaya
>
>
>
>
> Regards,
>
> Chaya
&g
Thank you very very much Abhishek Sir And Priti mam.
Once again thank you very much for the solution.
Regards,
Chaya
Regards,
Chaya
On Wed, May 8, 2013 at 12:12 PM, priti verma wrote:
> try this
>
> Sub Highlighting_cell()
>
> Dim rngCell As Range
> Dim
:
if i put 2 in M2 than all the value greter than 2 should be highlight in
sheet.
Thanks
Regards,
Chaya
Regards,
Chaya
On Wed, May 8, 2013 at 11:33 AM, Chaya wrote:
> Dear Experts,
>
> Please help me in highting number which is greater than 2 by excel vba in
> red colour.
&g
Dear Experts,
Please help me in highting number which is greater than 2 by excel vba in
red colour.
from B2: F12 range.
Thanks
Regards,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
Dear all experts,
Any update on my query.
Regards,
Chaya
Regards,
Chaya
On Tue, Apr 30, 2013 at 4:15 PM, Chaya wrote:
> Dear Hilary Sir,
>
> I am very new to excel. Please elabrote with my previous attached
> excel. And please tell me what is CAGR
> *
> *
&g
Dear Hilary Sir,
I am very new to excel. Please elabrote with my previous attached
excel. And please tell me what is CAGR
*
*
Regards,
Chaya
Regards,
Chaya
On Tue, Apr 30, 2013 at 4:04 PM, Hilary Lomotey wrote:
> =value for current year * (1+assumed rate of growth)
> assume
Dear All experts,
Please provide me formula for future growth calculation and growth
rate. i tried a lot but couldn't able to find the accurate. i tried Growth
Function but not working.
I have attached my file. please find the attachment.
Thanking a lot in advance !!
Regards,
Dear Vijay sir and All experts,
Thank you so much for sharing the Addin. Thank you all for guiding
and helping me in learning excel with VBA.
Regards,
Chaya
On Fri, Apr 26, 2013 at 10:52 AM, P.VIJAYKUMAR wrote:
> Respected Chaya,
>
> There is also an add-in called &quo
googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
Regards,
Chaya
--
Are you =EXP(E:RT)
Dear Amar,
Use , As example
=IFERROR(INDEX(INDIRECT($C$3&"!L:L"),MATCH($C7,INDIRECT($C$3&"!K:K"),0)),"")
Regards,
Chaya
On Mon, Apr 15, 2013 at 5:44 PM, amar takale wrote:
> Dear All
> Can anybody tell me how to remove NA from Attached Sheet in
Dear Pravin,
Replaced -
ActiveSheet.Range("$A$1:$AL$85").RemoveDuplicates _
Columns:=3, Header:=xlYes
by
ActiveSheet.Range("$A$1:$AL$85").RemoveDuplicates Columns:=Array(2, 3), _
Header:=xlYes
Might help you out.
Regards,
Chaya
On Mon
MsgBox "Removed Duplicate in C coloumn", vbInformation, "
Removed"
End Sub
Regards,
Chaya
On Sat, Apr 13, 2013 at 10:03 AM, Pravin Gunjal wrote:
> Dear Friends
>
> I would like to delete the repeated row from the attached sheet.
> E.g. Row No. 3, 5, 7 and so
Dear Lakshman,
I got your point, i am not sure i can do, but i can only try as i am a
very new learner. After all our experts will surely tackle out this query.
Regards,
Chaya
On Fri, Apr 12, 2013 at 1:14 PM, LAKSHMAN PRASAD wrote:
> Dear chaya
> Thanks for prompt reply, but I w
Dear Amar ,
Couple of days back, i too face the same problem. But when i close every
excel from the Task Manager Application and started again the excel file,
then i could able to do. Please try might it will help you.
Hope that this is not a solution but my experience.
Regards,
Chaya
On
.CutCopyMode = False
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False
End Sub
Regards,
Chaya
On Fri, Apr 12, 2013 at 12:36 PM, LAKSHMAN PRASAD wrote:
>
> Dear expert
> I have a excel file, in a sheet contain some details with URL, is
Dear Kuldeep,
Please find the attachment for your requirement.
Actually i got this formula from this forum. just sharing you.
You need to copy and paste down the formula in A colomn, thats all.
Regards,
Chaya
On Fri, Apr 12, 2013 at 12:43 PM, Kuldeep Singh wrote:
>
> Hi Experts,
Dear Kumar,
Please find the attachment. Might it will help you.
Just select the item code from the A2 (cell) drop down and
click on the button (filter).
Regards,
Chaya
On Wed, Apr 10, 2013 at 1:58 PM, C.G.Kumar wrote:
> Hi,
>
>
> I need to filter a long l
Result is same prince sir.
* varResData(intCtr, 2) = Replace(strNum, "", " ", 1, , vbTextCompare)*
With
*varResData(intCtr, 2) = Replace(strNum, "", "", 1, , vbTextCompare)*
*
*
*Please check*
*
*
*
*
*Regards,*
*Chaya*
On Mon, Apr 8, 2013 at 12:39
Thank you so much prince sir,
Its is perfectly working for Extracting words, Can it be done for
Numbers too as per my requirement as earlier attached.
Regards,
Chaya
On Mon, Apr 8, 2013 at 12:13 PM, Prince wrote:
> Hi Chaya,
>
> I Hope This may Help you.
>
> Sub Tes
.
Regards,
Chaya
On Mon, Apr 8, 2013 at 11:09 AM, अनिल नारायण गवली
wrote:
> Dear Chaya,
>
> Pl see the attached sheet it will help u .
>
> Warm Regards,
> Gawli Anil.
>
>
> On Mon, Apr 8, 2013 at 10:20 AM, Chaya wrote:
>
>> Dear Experts and folk,
>>
file. Please find the attachment.
Thanking in advance
Regards,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
Thank you very much Anil Sir and abhishek sir,
Code are working fine. thanks a lot.
Regards,
Chaya
On Fri, Apr 5, 2013 at 1:00 PM, अनिल नारायण गवली wrote:
> Pl see the attached sheet.
>
> Warm Regards,
> Just run the macro.
> Gawli Anil
>
>
> On Fri, Apr 5, 20
also be
green.
and if D10 - is Red and as per condition, A10, B10 and C10 should also be
Red.
Ultimately if the D colour changes means the corresponding row will aslo
be change.
Once again thanks to all.
Regards,
Chaya
On Fri, Apr 5, 2013 at 12:27 PM, Abhishek Jain wrote:
> Does this h
Dear Experts,
Hope you are well !.. i am trying to change the colour of the row by
the corresponding cell value by conditional format. but i have very least
idea on this regards, for reference i have attached by query sheet. please
find the attachment.
Thanking in advance.
-Regards,
Chaya
month, but
seems i am not getting any impact over my learning performances. i already
read few books of macros and excel, but not getting the right concept,
where and when need to be implement. Any advice for me to learn a bit more.
Cheers !!
Regards,
Chaya
On Thu, Apr 4, 2013 at 12:41 PM,
Sir, Might contains data in second row that which might not contains in the
first row in duplicate.
Ragards,
Chaya
On Thu, Apr 4, 2013 at 10:06 AM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> wrote:
> What is the criteria to not delete duplicates.
>
>
> On Thursday, 4 A
Dear Lalit Sir,
Thanks for the reply. i tried to explain a bit more in the attached
file. please refer sir.
Regards,
Chaya
On Thu, Apr 4, 2013 at 8:58 AM, Lalit Mohan Pandey wrote:
> I am not able to understand your both conditions :(.
> First select all column then remove dup
Dear Experts,
I have another problem arise in excel while removing duplicate. i
have attached the sample and explained in the attachment. Please find the
attachment.
Thank you in advance
Regards,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2
Dear Experts,
Sorry for the late reply. Thank you all for the help.
Can we make in the pivot table iteslf the same financial year as we did ?
Regards,
Chaya
On Wed, Mar 27, 2013 at 6:35 PM, Amit Desai (MERU)
wrote:
> FYI,
>
> ** **
>
> Please find attach
I got it Dear Experts, Thanks.
Finally i got =EOMONTH(A1,0)
On Fri, Mar 22, 2013 at 12:50 PM, Chaya wrote:
> Dear Experts,
>
> Can we able to find the last day of the month with the
> corresponding month and year ? Please find the attachment which i have
> p
March*
>>
>> On Wed, Mar 20, 2013 at 4:59 PM, Chaya wrote:
>>
>>> Dear Experts,
>>>
>>> I want to plot a graph with the financial year
>>> starting from April to March. Actually my datas are starting with the Jan
>>>
fiancial year in
excel.
Please find the attachment for reference.
Thank you in advance.
Regards,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Count).End(xlToLeft).Column - 1
For a = 1 To irow Step 1
.
.
'If a > irow Then
'MsgBox "Successfully Donw", vbInformation, "Anil"
'Else
'End If
Next a
-Chaya
On Tue, Mar 12, 2013 at 12:44 PM, अनिल नारायण गवल
Yes Sir,
If you see the attached sheet, there one button is there, please click
on that and go to second sheet. you will find that every time the datas
are shifting down
-Chaya
On Tue, Mar 12, 2013 at 12:02 PM, Abhishek Jain wrote:
> Can you also provide a sample output?
>
>
>
Sir, Please suggest me on which format i will select, please see below
image :
[image: Inline image 1]
On Tue, Mar 12, 2013 at 11:47 AM, The Viper wrote:
> you should choose .xlsx format while saving your workbook
>
>
> On Tue, Mar 12, 2013 at 11:35 AM, Chaya wrote:
>
>&g
Sir, i am using Ms office 2010.
-Chaya
On Tue, Mar 12, 2013 at 11:28 AM, The Viper wrote:
> what version of excel are you using?
> Ëxcel 97-2003 has the capability of holding maximum 65536 rows.
>
>
> On Tue, Mar 12, 2013 at 11:24 AM, Chaya wrote:
>
>> Sir,
>>
Sir,
How to View then, Please advice me ? what is xlsx format, you mean Ëxcel
97-2003 Workbook format" ? i already did save as than, please suggest
experts..
Thanks,
Chaya
On Tue, Mar 12, 2013 at 11:19 AM, The Viper wrote:
> you cannot view more than 65536 rows in prior versions
data base, only
65536 rows is visible and showing to me. i am very scared that the data
base have gone away or deleted. Please suggest me on this, how to retrieve
the data which contains more than 1 lacs rows
Thanks,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Awesome Anil Sir,
its only single line and very short code. amazing !!
thanks v vry much.
-Regards,
-Chaya
On Tue, Jan 29, 2013 at 3:12 PM, अनिल नारायण गवली
wrote:
> Dear Chaya,
>
> Pl find attached sheet. FY I
>
> Warm Regards,
> Gawli Anil
>
> On Tue, Jan 29
.
regards,
Chaya
On Thu, Jan 17, 2013 at 11:26 AM, chaya moni wrote:
> Dear Anoop,
>
> Awesome and unbelievable, it was more then expected. any way i did
> not check those value. once i check, i revert you back.
> thanks for helping me. thank you all.
>
> -Chaya
>
Dear Anoop,
Awesome and unbelievable, it was more then expected. any way i did
not check those value. once i check, i revert you back.
thanks for helping me. thank you all.
-Chaya
On Thu, Jan 17, 2013 at 11:19 AM, Anoop K Sharma wrote:
> Hi Chaya
>
> Here you go
>
heet.
thanks all
Regards,
Chaya
On Fri, Jan 11, 2013 at 4:35 PM, Prince wrote:
> Hi Chaya,
>
>
> Can you please shere ur workbook. One more thing where is the source of ur
> data.
>
> regards
> prince
>
> On Friday, January 11, 2013 4:03:27 PM UTC+5:30, chaya moni
Thank you all.
regards,
Chaya
On Fri, Jan 11, 2013 at 3:32 PM, अनिल नारायण गवली
wrote:
> Hi Chaya,
>
> Welcome to our Groups.fell free at any time to ask regarding about
> excel.
>
>
> Warm Reagrds,
> Gawli Anil
>
> On Fri, Jan 11, 2013 at 3:08 PM
Dear Expert/Exceller,
I am new to this group and very few knowledge about excel and
macros. Myself Miss Chaya, from delhi and completed my B.A English. Even
though i passed through this stream, i want to get full time to new era of
learning Excel and macros, as i found to be very
90 matches
Mail list logo
