Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?

2013-10-10 Thread Chaya Cooper
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

Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?

2013-08-25 Thread Chaya Cooper
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 prince...@gmail.com javascript: No Chaya i dont think there is any

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-20 Thread Chaya Cooper
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 open the VBA window by pressing ALT+F11 and go

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-20 Thread Chaya Cooper
koul@gmail.comjavascript: wrote: press alt +f11 On Tue, Aug 20, 2013 at 11:25 AM, P.VIJAYKUMAR vijay...@gmail.comjavascript: 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

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-20 Thread Chaya Cooper
20, 2013 at 11:43 AM, ashish koul koul@gmail.comjavascript: wrote: press alt +f11 On Tue, Aug 20, 2013 at 11:25 AM, P.VIJAYKUMAR vijay...@gmail.comjavascript: wrote: Respected Chaya Cooper, Please check the following link and see whether it helps. http://excelsemipro.com/2011

$$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Chaya Cooper
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

$$Excel-Macros$$ Is there a way to insert images into a specific cell?

2013-08-19 Thread Chaya Cooper
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

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Chaya Cooper
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 and paste the each cells

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Chaya Cooper
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 On 20 August 2013 04:35, Chaya Cooper chaya...@gmail.com

$$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread Chaya Cooper
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

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Chaya Cooper
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 prash...@gmail.comjavascript: wrote

$$Excel-Macros$$ Charts create

2013-05-31 Thread Chaya
. 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

$$Excel-Macros$$ Look up value from Column and rows

2013-05-30 Thread Chaya
, 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

Re: $$Excel-Macros$$ Look up value from Column and rows

2013-05-30 Thread Chaya
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

Re: $$Excel-Macros$$ Look up value from Column and rows

2013-05-30 Thread Chaya
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 prafulltjad...@gmail.comwrote: Dear XLS, It is very useful formula and nice formula I

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-23 Thread Chaya
Dear Experts, any Update on this ? Regards, Chaya The excel learner :-) On Wed, May 22, 2013 at 7:33 PM, Chaya chayamon...@gmail.com 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

$$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread Chaya
at 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, Chaya

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread Chaya
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 da...@grugeon.com.au wrote: Can they open the files through the network manually

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread Chaya
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 chayamon...@gmail.com wrote: Thanks David sir and Paul sir for your quick reply

Re: $$Excel-Macros$$ Help Please - Data sub validation

2013-05-21 Thread Chaya
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

Re: $$Excel-Macros$$ Help Please - Data sub validation

2013-05-21 Thread Chaya
Thanks a lot priti. Regards, Chaya The excel learner :-) On Tue, May 21, 2013 at 3:39 PM, priti verma pritiverma1...@gmail.comwrote: HI chaya, I hope this is what you're asking ... On Tue, May 21, 2013 at 2:59 PM, Chaya chayamon...@gmail.com wrote: Dear Priti, As always you did

Re: $$Excel-Macros$$ Data transform

2013-05-20 Thread Chaya
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 betnmtdongna...@gmail.comwrote: I do not know what you do, the help you, if not pleasant, then continue

$$Excel-Macros$$ Help Please - Data sub validation

2013-05-20 Thread Chaya
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

$$Excel-Macros$$ Macros Tips

2013-05-17 Thread Chaya
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 page of this forum @ https

Re: $$Excel-Macros$$ Macros Tips

2013-05-17 Thread Chaya
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

Re: $$Excel-Macros$$ Macros Tips

2013-05-17 Thread Chaya
of learning macros ! thanks to all Regards, Chaya The excel learner :-) On Fri, May 17, 2013 at 5:20 PM, Abhishek Jain abhishek@gmail.comwrote: 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

$$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Chaya
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

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Chaya
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) amit.de...@merucabs.comwrote: Do Copy then do Alt E S V E. ** ** Best Regards, Amit Desai +91

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Chaya
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) amit.de...@merucabs.comwrote: Please share the main sheet.. I will convert it send it... ** ** Best Regards, Amit

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Chaya
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 pritiverma1...@gmail.comwrote: Hi Chaya , PFA, without vba If it helps On Tue, May 14, 2013 at 4:11 PM

Re: $$Excel-Macros$$ Split data in financial yearly wise

2013-05-13 Thread Chaya
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 chayamon...@gmail.com wrote: Dear

$$Excel-Macros$$ Multiple time copy

2013-05-10 Thread Chaya
the 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

Re: $$Excel-Macros$$ Multiple time copy

2013-05-10 Thread Chaya
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, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear

Re: $$Excel-Macros$$ Re: Delete As per criteria

2013-05-09 Thread Chaya
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 abhishek@gmail.comwrote: Attached. On Thu, May 9, 2013 at 11:58 AM, Chaya chayamon...@gmail.com wrote: Dear Abhishek, I have a query for deleting

Re: $$Excel-Macros$$ Re: Delete As per criteria

2013-05-09 Thread Chaya
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 chayamon...@gmail.com wrote: Yes Anil Sir, I tried your code too. its fine working. Thank you. Regards, Chaya On Thu, May 9, 2013 at 12:31 PM, अनिल

$$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
in 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

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
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 waheedb...@gmail.com wrote: PFA sheet solved, You can split your data by using

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
attached sheet solved. Many many thanks to all. Regards, Chaya On Thu, May 9, 2013 at 7:08 PM, priti verma pritiverma1...@gmail.comwrote: Hi Chaya, Pfa On Thu, May 9, 2013 at 6:30 PM, Chaya chayamon...@gmail.com wrote: Thanks Waheed, Thanks for that, but i dont want to split

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
- 156320 Thanks a lot priti, hope you got my point. Regards, Chaya On Fri, May 10, 2013 at 10:17 AM, Priti_verma pritiverma1...@gmail.comwrote: *Hi chaya ,* *Yes you can do it.Please see the attached file .* * * * * *From:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
Awesome, its perfectly working. Thanks a ton priti for the help. Regards, Chaya On Fri, May 10, 2013 at 10:46 AM, priti verma pritiverma1...@gmail.comwrote: please see it . On Fri, May 10, 2013 at 10:25 AM, Chaya chayamon...@gmail.com wrote: Hi Priti, Your formulas are absolutely

$$Excel-Macros$$ Highting number

2013-05-08 Thread Chaya
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

Re: $$Excel-Macros$$ Highting number

2013-05-08 Thread Chaya
: 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 chayamon...@gmail.com wrote: Dear Experts, Please help me in highting number which is greater than 2 by excel vba in red colour

Re: $$Excel-Macros$$ Highting number

2013-05-08 Thread Chaya
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 pritiverma1...@gmail.comwrote: try this Sub Highlighting_cell() Dim rngCell As Range Dim

Re: $$Excel-Macros$$ Highting number

2013-05-08 Thread Chaya
understand my needs. Regards, Chaya On Wed, May 8, 2013 at 12:23 PM, Chaya chayamon...@gmail.com wrote: 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

$$Excel-Macros$$ Merge cell To Repeat cell value

2013-05-08 Thread Chaya
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

Re: $$Excel-Macros$$ Merge cell To Repeat cell value

2013-05-08 Thread Chaya
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 abhishek@gmail.comwrote: Here. On Wed, May 8, 2013 at 6:23 PM, Chaya chayamon...@gmail.com wrote

Re: $$Excel-Macros$$ Future Growth Calculation

2013-05-01 Thread Chaya
Dear all experts, Any update on my query. Regards, Chaya Regards, Chaya On Tue, Apr 30, 2013 at 4:15 PM, Chaya chayamon...@gmail.com wrote: Dear Hilary Sir, I am very new to excel. Please elabrote with my previous attached excel. And please tell me what is CAGR

$$Excel-Macros$$ Future Growth Calculation

2013-04-30 Thread Chaya
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, Chaya

Re: $$Excel-Macros$$ Future Growth Calculation

2013-04-30 Thread Chaya
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 resp...@gmail.com wrote: =value for current year * (1+assumed rate of growth

Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

2013-04-25 Thread Chaya
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 vijay.4...@gmail.com wrote: Respected Chaya, There is also an add

Re: $$Excel-Macros$$ Repeated row to be deleted

2013-04-15 Thread Chaya
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, Apr 15, 2013 at 11:12 AM

Re: $$Excel-Macros$$ Remove NA Error

2013-04-15 Thread Chaya
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 amartak...@gmail.com wrote: Dear All Can anybody tell me how to remove NA from Attached Sheet in Output worksheet.I try

Re: $$Excel-Macros$$ Repeated row to be deleted

2013-04-14 Thread Chaya
Sub Regards, Chaya On Sat, Apr 13, 2013 at 10:03 AM, Pravin Gunjal isk1...@gmail.com wrote: Dear Friends I would like to delete the repeated row from the attached sheet. E.g. Row No. 3, 5, 7 and so on up to row no.5000 Can someone help me to this by macro. Thank you, Regards Pravin

Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

2013-04-12 Thread Chaya
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 naukrikuld...@gmail.comwrote

Re: $$Excel-Macros$$ print all URL details in a PDF file

2013-04-12 Thread Chaya
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _ IgnorePrintAreas:=False End Sub Regards, Chaya On Fri, Apr 12, 2013 at 12:36 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear expert I have a excel file, in a sheet contain some details with URL, is there any formula

Re: $$Excel-Macros$$ Replacement small issue (Ctr+H)

2013-04-12 Thread Chaya
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

Re: $$Excel-Macros$$ print all URL details in a PDF file

2013-04-12 Thread Chaya
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 lakshman_...@yahoo.comwrote: Dear chaya Thanks for prompt reply

Re: $$Excel-Macros$$ Filter Data based on Criteria

2013-04-10 Thread Chaya
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 kumar.bemlmum...@gmail.comwrote: Hi, I need to filter

Re: $$Excel-Macros$$ Re: Extracting word and numbers

2013-04-08 Thread Chaya
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 prince141...@gmail.com wrote: Hi Chaya, I Hope This may Help you. Sub

Re: $$Excel-Macros$$ Re: Extracting word and numbers

2013-04-08 Thread Chaya
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 PM, Prince prince141...@gmail.com wrote: Hi

$$Excel-Macros$$ Extracting word and numbers

2013-04-07 Thread Chaya
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

Re: $$Excel-Macros$$ Extracting word and numbers

2013-04-07 Thread Chaya
. Regards, Chaya On Mon, Apr 8, 2013 at 11:09 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: 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 chayamon...@gmail.com wrote: Dear Experts and folk, I

Re: $$Excel-Macros$$ Changing Color

2013-04-05 Thread Chaya
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 abhishek

Re: $$Excel-Macros$$ Changing Color

2013-04-05 Thread Chaya
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, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Pl see the attached sheet. Warm Regards, Just run the macro. Gawli Anil On Fri, Apr 5, 2013 at 12

Re: $$Excel-Macros$$ Re: Remove Duplicate with Criteria

2013-04-04 Thread Chaya
, 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, Lalit

$$Excel-Macros$$ Changing Color

2013-04-04 Thread Chaya
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

$$Excel-Macros$$ Remove Duplicate with Criteria

2013-04-03 Thread Chaya
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

Re: $$Excel-Macros$$ Re: Remove Duplicate with Criteria

2013-04-03 Thread Chaya
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 mohan.pande...@gmail.com wrote: I am not able to understand your both conditions :(. First select all column

Re: $$Excel-Macros$$ Re: Remove Duplicate with Criteria

2013-04-03 Thread Chaya
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 April 2013 09:34:49 UTC+5:30

Re: $$Excel-Macros$$ Financial year Graph

2013-03-27 Thread Chaya
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) amit.de...@merucabs.comwrote: FYI, ** ** Please find attached altered

Re: $$Excel-Macros$$ Month-Date-Year

2013-03-22 Thread Chaya
I got it Dear Experts, Thanks. Finally i got =EOMONTH(A1,0) On Fri, Mar 22, 2013 at 12:50 PM, Chaya chayamon...@gmail.com 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 provided

$$Excel-Macros$$ Financial year Graph

2013-03-20 Thread Chaya
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

Re: $$Excel-Macros$$ Financial year Graph

2013-03-20 Thread Chaya
* On Wed, Mar 20, 2013 at 4:59 PM, Chaya chayamon...@gmail.com 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 month to Dec but I want the graph which shows for me from financial

Re: $$Excel-Macros$$ Showing 65536 Rows

2013-03-12 Thread Chaya
Sir, i am using Ms office 2010. -Chaya On Tue, Mar 12, 2013 at 11:28 AM, The Viper viper@gmail.com 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 chayamon...@gmail.com wrote: Sir

Re: $$Excel-Macros$$ Code Automatically

2013-03-12 Thread Chaya
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 abhishek@gmail.comwrote: Can you also provide a sample

Re: $$Excel-Macros$$ Code Automatically

2013-03-12 Thread Chaya
).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, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Chaya, Pl find

Re: $$Excel-Macros$$ Showing 65536 Rows

2013-03-11 Thread Chaya
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 viper@gmail.com wrote: you cannot view more than 65536 rows in prior

Re: $$Excel-Macros$$ Textbox Copy Paste

2013-01-29 Thread Chaya
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, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Chaya, Pl find attached sheet. FY I Warm Regards, Gawli Anil On Tue, Jan 29, 2013 at 3

Re: $$Excel-Macros$$ Help in extracting data

2013-01-16 Thread chaya moni
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 aks.sharm...@gmail.comwrote: Hi Chaya Here you go

Re: $$Excel-Macros$$ Help in extracting data

2013-01-16 Thread chaya moni
. regards, Chaya On Thu, Jan 17, 2013 at 11:26 AM, chaya moni chayamon...@gmail.com 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 On Thu

$$Excel-Macros$$ Re: Introduce Yourself !!

2013-01-11 Thread chaya moni
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

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2013-01-11 Thread chaya moni
Thank you all. regards, Chaya On Fri, Jan 11, 2013 at 3:32 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: 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, Prince prince141

Re: $$Excel-Macros$$ Re: Card List view

2013-01-11 Thread chaya moni
, Chaya On Fri, Jan 11, 2013 at 4:35 PM, Prince prince141...@gmail.com 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 wrote: Dear Exceller, While goggling