$$Excel-Macros$$ how to insert Excel File in powerpoint presentation...

2013-07-15 Thread Dhananjay Pinjan
Hi Friends, I need to insert Excel file in PowerPoint presentation. I used Hyperlink' option. It is working fine on my PC. But when I send the same powerpoint presentation to another user, he is not able to access Excel File. It showing error. Pl. advice. Regards, Dhananjay -- Are you

$$Excel-Macros$$ Re: how to insert Excel File in powerpoint presentation...

2013-07-15 Thread Deepak Singh
*Hi Dhananjay, Do not use it as hyperlink..better go to insert click on object..then create from file..browse your file and then click on display as icon..click ok.. Hope this will help you out.. * -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ MS Excel Password Recovery Software

2013-07-15 Thread riny vangogh
hello Everyone I tell you my self experience about Excel password recoverysoftwarehttp://www.excelpasswordrecovery.net/, a few days ago I have lost my excel file password then I could not remember what was my excel file password then I searched an excel file password recovery software on

Re: $$Excel-Macros$$ how to insert Excel File in powerpoint presentation...

2013-07-15 Thread De Premor
Did you put your excel in same directory with your current Power Point File ? If Not try to do that and then re-link it again. With hyperlink file creation in same folder, it will create hyperlink with dynamic link. Rgds, [dp] On 15/07/2013 14:49, Dhananjay Pinjan wrote: Hi Friends, I need

Re: $$Excel-Macros$$ Sumproduct using VBA

2013-07-15 Thread Chandra Shekar
Hi, Could you please let me know what your are asking for? Thanks in advance. Regards, Chandra On Sat, Jul 13, 2013 at 7:23 AM, Bé Trần Văn betnmtdongna...@gmail.comwrote: With VBA require you to download the file 2013/7/12 Chandra Shekar chandrashekarb@gmail.com Hi, Could you

Re: $$Excel-Macros$$ how to insert Excel File in powerpoint presentation...

2013-07-15 Thread Dhananjay Pinjan
By that way, it is linking. But when I sent this file to another person (who is sitting on another computer network is not there) when he tries to open the Excel File, he is getting error cannot open the specified file On Mon, Jul 15, 2013 at 2:09 PM, De Premor d...@premor.net wrote: Did you

Re: $$Excel-Macros$$ how to insert Excel File in powerpoint presentation...

2013-07-15 Thread Deepak Singh
Hi Dnananjay, As you said there is no Network between computer, So you need to put the Excel file on same location on another computer as mention in Hyperlink address. Without saving excel file on another system, you can not use it. Otherwise you can Attach the excel file on Powerpoint That

$$Excel-Macros$$ Different Validateion

2013-07-15 Thread Manoj Kumar
Dear Expert, In validation we select a range and put the text but i want a different validation. We can put any value in a cell but when we put No it will be not consider. Regard Manoj -- 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

$$Excel-Macros$$ Challanging queri

2013-07-15 Thread priti verma
Hi group , Please try to solve this. Queri based on conditional formating If b2 a2 then up arrow and coluor should be green . if b2a2 then Down arrow and colour should be red. See PFA For more clearification Regards , Priti verma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

$$Excel-Macros$$ Re: Different Validateion

2013-07-15 Thread Deepak Singh
*select Cell B1 and Go to Datavalidation then select Custom and put this formula..=ISTEXT(B1) * -- 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)

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread Ahmed Honest
​Dear Priti, Please find attach the solution. It is too simple On Mon, Jul 15, 2013 at 1:34 PM, priti verma pritiverma1...@gmail.comwrote: Hi group , Please try to solve this. Queri based on conditional formating If b2 a2 then up arrow and coluor should be green . if b2a2 then

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread Rupali Joshi
Hi priti, Please find the solution. In this first select home-- symbol-- font(Arial)--Up and down arrows , then select the range where you have to put the formula using conditional formatting use formula =B2A2 then format---Numbercustom to set colour and arrow. Regards, Rupali Joshi On

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread priti verma
HI rupali , good job On Mon, Jul 15, 2013 at 4:43 AM, Rupali Joshi rpljs...@gmail.com wrote: Hi priti, Please find the solution. In this first select home-- symbol-- font(Arial)--Up and down arrows , then select the range where you have to put the formula using conditional formatting

Fwd: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread Pravin Gunjal
And what about if the value is same in both columns. -- Forwarded message -- From: priti verma pritiverma1...@gmail.com Date: Mon, Jul 15, 2013 at 5:28 PM Subject: Re: $$Excel-Macros$$ Challanging queri To: excel-macros@googlegroups.com HI rupali , good job On Mon, Jul 15,

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread priti verma
If the value is same in both column ,then up arrow should be apply On Mon, Jul 15, 2013 at 6:04 AM, Pravin Gunjal isk1...@gmail.com wrote: And what about if the value is same in both columns. -- Forwarded message -- From: priti verma pritiverma1...@gmail.com Date: Mon, Jul

Re: Fwd: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread devanand nayak
Hi every one pl tell me where can I learn excel Pravin Gunjal isk1...@gmail.com wrote: And what about if the value is same in both columns. -- Forwarded message -- From: priti verma pritiverma1...@gmail.com Date: Mon, Jul 15, 2013 at 5:28 PM Subject: Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread devanand nayak
I have a full sheet of monthly party sales on day today basis with qty tin no net amount vat amt . I want it to patywise tinwise total Kindly inform me priti verma pritiverma1...@gmail.com wrote: If the value is same in both column ,then up arrow should be apply On Mon, Jul 15, 2013 at 6:04

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread priti verma
can you please share an example file. On Mon, Jul 15, 2013 at 6:44 AM, devanand nayak devnayak_...@hotmail.comwrote: I have a full sheet of monthly party sales on day today basis with qty tin no net amount vat amt . I want it to patywise tinwise total Kindly inform me priti verma

Re: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread De Premor
PFA Pada 15/07/2013 17:34, priti verma menulis: Hi group , Please try to solve this. Queri based on conditional formating If b2 a2 then up arrow and coluor should be green . if b2a2 then Down arrow and colour should be red. See PFA For more clearification Regards , Priti verma -- Are you

Re: $$Excel-Macros$$ Re: how to insert Excel File in powerpoint presentation...

2013-07-15 Thread Bé Trần Văn
Thank you Deepak Singh. 2013/7/15 Deepak Singh dpk85si...@gmail.com *Hi Dhananjay, Do not use it as hyperlink..better go to insert click on object..then create from file..browse your file and then click on display as icon..click ok.. Hope this will help you out.. * -- Are you

Re: $$Excel-Macros$$ how to insert Excel File in powerpoint presentation...

2013-07-15 Thread Bé Trần Văn
Open powerpoint 2003, Click to add title frames delete, click on Click to add text box and type the first letter dot to remove Click to add text (if not included in the table to the words it still can not be deleted). From the Insert menu choose Object, warm Insert Object window appears, check

Re: $$Excel-Macros$$ Different Validateion

2013-07-15 Thread Bé Trần Văn
In Datavalidation window, you select the error alert Tab, uncheck the Show Error Alert after invalid data is entered, then press OK, now you will not be data entry errors. 2013/7/15 Manoj Kumar manoj.11...@gmail.com Dear Expert, In validation we select a range and put the text but i want a

Re: $$Excel-Macros$$ how to insert Excel File in powerpoint presentation...

2013-07-15 Thread Pooja Sharma
Hi Dhananjay, Rather than using Hyperlink, try using Insert - Object-Create from file-Browse and then give the path of the file and insert the required file as an object on your ppt. Regards Pooja On Mon, Jul 15, 2013 at 1:19 PM, Dhananjay Pinjan dppin...@gmail.comwrote: Hi Friends, I need

Re: $$Excel-Macros$$ Extract Data Based on Criteria

2013-07-15 Thread Hilary Lomotey
excellent buddy. super thanks On Mon, Jul 15, 2013 at 6:22 PM, De Premor d...@premor.net wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (d...@premor.net) Add cleanup

Re: $$Excel-Macros$$ Extract Data Based on Criteria

2013-07-15 Thread De Premor
You're welcome Pada 16/07/2013 0:45, Hilary Lomotey menulis: excellent buddy. super thanks On Mon, Jul 15, 2013 at 6:22 PM, De Premor d...@premor.net mailto:d...@premor.net wrote: Boxbe https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (d...@premor.net

$$Excel-Macros$$ Copy and Paste to New Spreadsheet then delete Macro HELP!

2013-07-15 Thread yas
Hi, Im chasing help. I have two spreadsheets in which someone will enter data in one and it will copy over the data to the next speadsheet and then the original data will be deleted to start again. I have done this so far that the data transfers over but cannot get the data to clear once it

Re: $$Excel-Macros$$ Copy and Paste to New Spreadsheet then delete Macro HELP!

2013-07-15 Thread De Premor
If we have sample data on worksheet this will be more easy, but i'll try to do without it. Sub EnterData() Dim Sh As Worksheet Dim Src As Range Set Sh = ActiveSheet Set Src = Sh.Range(D2:D8) Src.Copy 'Sheets(Register). Sheets(Sheet1).Activate

Fwd: $$Excel-Macros$$ Challanging queri

2013-07-15 Thread Pravin Gunjal
Hi DP I too applied the same condition (pl see the green background in same sheet), but the result shown is different. Regards Pravin Gunjal. -- Forwarded message -- From: De Premor d...@premor.net Date: Mon, Jul 15, 2013 at 7:30 PM Subject: Re: $$Excel-Macros$$ Challanging

$$Excel-Macros$$ Re: Copy and Paste to New Spreadsheet then delete Macro HELP!

2013-07-15 Thread yas
Ill add my spreadsheet to help. Its meant to work as a submit button, then transfer over data, then clear Form 2 for someone else to add information. On Tuesday, 16 July 2013 13:20:14 UTC+10, yas wrote: Hi, Im chasing help. I have two spreadsheets in which someone will enter data in

$$Excel-Macros$$ Re: Copy and Paste to New Spreadsheet then delete Macro HELP!

2013-07-15 Thread yas
It wont let me add my spreadsheet. Your answer came up with a Runtime Error 9? On Tuesday, 16 July 2013 13:20:14 UTC+10, yas wrote: Hi, Im chasing help. I have two spreadsheets in which someone will enter data in one and it will copy over the data to the next speadsheet and then the

$$Excel-Macros$$ Re: Copy and Paste to New Spreadsheet then delete Macro HELP!

2013-07-15 Thread yas
On Tuesday, 16 July 2013 13:20:14 UTC+10, yas wrote: Hi, Im chasing help. I have two spreadsheets in which someone will enter data in one and it will copy over the data to the next speadsheet and then the original data will be deleted to start again. I have done this so far that the