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

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

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

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!

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

Fwd: $$Excel-Macros$$ Challanging queri

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 Date: Mon, Jul 15, 2013 at 7:30 PM Subject: Re: $$Excel-Macros$$ Challanging queri To: excel-macr

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

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 Range(Range("

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

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 ha

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

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 > wrote: Boxbe This message is eligible for Automatic Cleanup! (d...@premor.net

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

excellent buddy. super thanks On Mon, Jul 15, 2013 at 6:22 PM, De Premor wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (d...@premor.net) Add cleanup > rule

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

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 wrote: > Hi Friends, > > I need to insert E

Re: $$Excel-Macros$$ Different Validateion

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 > > Dear Expert, > > In validation we select a range and put the text but i want a different > validat

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

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$$ Re: how to insert Excel File in powerpoint presentation...

Thank you Deepak Singh. 2013/7/15 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

Re: $$Excel-Macros$$ Challanging queri

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 b2Are 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 Fac

Re: $$Excel-Macros$$ Challanging queri

can you please share an example file. On Mon, Jul 15, 2013 at 6:44 AM, devanand nayak wrote: > 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 wrote: > > If the value is

Re: $$Excel-Macros$$ Challanging queri

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 wrote: 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 wrote:

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

Hi every one pl tell me where can I learn excel Pravin Gunjal wrote: And what about if the value is same in both columns. -- Forwarded message -- From: priti verma Date: Mon, Jul 15, 2013 at 5:28 PM Subject: Re: $$Excel-Macros$$ Challanging queri To: excel-macros@googlegroups.c

Re: $$Excel-Macros$$ Challanging queri

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 wrote: > And what about if the value is same in both columns. > > -- Forwarded message -- > From: priti verma > Date: Mon, Jul 15, 2013 at 5:28 PM > Subject: Re: $$

Fwd: $$Excel-Macros$$ Challanging queri

And what about if the value is same in both columns. -- Forwarded message -- From: priti verma 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, 2013 at 4:43 AM, Rupali Josh

Re: $$Excel-Macros$$ Challanging queri

HI rupali , good job On Mon, Jul 15, 2013 at 4:43 AM, Rupali Joshi 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 & use formula

Re: $$Excel-Macros$$ Challanging queri

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 "=B2>A2" then format--->Number>custom to set colour and arrow. Regards, Rupali Josh

Re: $$Excel-Macros$$ Challanging queri

​Dear Priti, Please find attach the solution. It is too simple On Mon, Jul 15, 2013 at 1:34 PM, priti verma wrote: > Hi group , > > Please try to solve this. > > Queri based on conditional formating > > If b2 >a2 then up arrow and coluor should be green . > > if b2 > See PFA For more cl

$$Excel-Macros$$ Re: Different Validateion

*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)

$$Excel-Macros$$ Challanging queri

Hi group , Please try to solve this. Queri based on conditional formating If b2 >a2 then up arrow and coluor should be green . if b2https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pro

$$Excel-Macros$$ Different Validateion

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 of

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

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 wil

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

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 wrote: > Did you put your ex

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

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 wrote: > With VBA require you to download the file > > 2013/7/12 Chandra Shekar > >> Hi, >> >> Could you please let me know how to use sumproduct using

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

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 to

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

hello Everyone I tell you my self experience about Excel password recoverysoftware, 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

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

*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 =TIME(2,DO:IT,N:O

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

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 =EXP(E: