$$Excel-Macros$$ membership

i was getting the posts of this group regularly but lst week, i thru oversight clicked "unsubscribe" and not getting posts. Please continue my membership and send me posts as its very useful for me to learn. -- Nemi Gandhi 98204 92963 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo

Re: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Hi Joseph, PFA Regards Ashish -- 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 Ple

Re: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Thank you Ashish and Ravi. It has still not hit the bulls eye. I am not sure if this is possible. but let me explain this again. Ravi, your concept is right, I am getting the result as per my instruction in the file. but what i am looking for is, if I click "RAV", it cleards existing data from Fi

RE: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Hi, Click on the button and result would be populate below. Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Kumar Sent: Friday, November 28, 2014 9:57 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Mac

Re: $$Excel-Macros$$ Need help to click on Ok button when message from web page

hi you can try adding either of foll lines... Application.SendKeys("{enter}") or Application.SendKeys("~") however its always not the same thing what we percieve, if it doent work pl share ur code to chek further... Cheers!! + *I did not do this for you. God is here working through me for

RE: $$Excel-Macros$$ Need help to click on Ok button when message from web page

Hi, Add below line in your code. Might be it works webbrowser.Silent = True ‘webbrowser’ is your webbrowser object name like if you are using ‘ie’ so use ie instead of ‘webbrowse’ Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com

$$Excel-Macros$$ Need help to click on Ok button when message from web page

Hi there, recently i am doing IE automaton. However this is dealing with one ASP site,, and i am accessing internal objects almost i am reaching to close this project, But at there end there is close claim button once i click through vba code there is one alert saying message from web page,, a

Re: $$Excel-Macros$$ row data copy to next sheet

Hi Daya, Check this macro.. you need to ensure that heading in both sheet matches then it doesn't matter order of column, its dynamic to place data below matching column... Delete data from row 2 in sheet Out & try code... Cheers!! + *I did not do this for you. God is here working through

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

Try this...some minor correction.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Nov 28, 2014 at 2:12 PM, Vaibhav Joshi wrote: > Son > > Can you test this file... i have tried building UDF since fomula is going > too complexx... > > Cheers!! > > ++

Re: $$Excel-Macros$$ Re: row data copy to next sheet

better thank this from any expert ? On 28 November 2014 at 18:11, daya p wrote: > thank you sir > > On 28 November 2014 at 16:33, Mandeep Baluja > wrote: > >> >> Kindly find the solution i have used two helper column and a macro. >> >> Regards, >> Mandeep Baluja >> Excel Specialist. >> https://

Re: $$Excel-Macros$$ Re: row data copy to next sheet

thank you sir On 28 November 2014 at 16:33, Mandeep Baluja wrote: > > Kindly find the solution i have used two helper column and a macro. > > Regards, > Mandeep Baluja > Excel Specialist. > https://www.linkedin.com/profile/view?id=312532939 > https://www.facebook.com/VBAEXCELSQL?ref=hl > > > > >

$$Excel-Macros$$ need help

Dear sir's, I have 3 excel files, which are very old, i kept password protected, but now i have forgotten those password, plz help me to recovery password. regards, thameem.m -- 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 Facebo

$$Excel-Macros$$ Re: row data copy to next sheet

Kindly find the solution i have used two helper column and a macro. Regards, Mandeep Baluja Excel Specialist. https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Thursday, November 27, 2014 8:00:57 PM UTC+5:30, daya p wrote: > > Sir, > good even

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

Son Can you test this file... i have tried building UDF since fomula is going too complexx... Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Nov 27, 2014 at 11:10 PM, Vaibhav Joshi wrote: > Did this worked? > On Nov 27, 2014 1:38 PM, "Vaibhav Joshi