Re: $$Excel-Macros$$ Please solve this sheet its very urgent

2014-08-16 Thread Rajan Verma
Wow On Monday, 11 August 2014 12:57:05 UTC-6, kapil Gupta wrote: Thanks you really genius. Regards, Kapil Gupta On Monday, August 11, 2014 3:57:39 PM UTC+5:30, Vabz wrote: Hi FA Cheers!! On Mon, Aug 11, 2014 at 1:03 PM, kapil Gupta kgup...@gmail.com wrote: Hello, Please

$$Excel-Macros$$ Re: Help needed

2014-08-16 Thread 'Sleek' via MS EXCEL AND VBA MACROS
right click to select all sheets, then use Find Feature. On Saturday, August 16, 2014 8:29:28 AM UTC+3, Kaushik wrote: Hi Team In the attached excel file I want to do the following to obtain the desired result 1. I want to find each cell in whole workbook and to see its repeating

Re: $$Excel-Macros$$ Please solve this sheet its very urgent

2014-08-16 Thread Vaibhav Joshi
Cheers !! On Aug 16, 2014 4:38 PM, Rajan Verma rajanverma1...@gmail.com wrote: Wow On Monday, 11 August 2014 12:57:05 UTC-6, kapil Gupta wrote: Thanks you really genius. Regards, Kapil Gupta On Monday, August 11, 2014 3:57:39 PM UTC+5:30, Vabz wrote: Hi FA Cheers!! On Mon, Aug

Re: $$Excel-Macros$$ Calculating working hours between 2 days with break time

2014-08-16 Thread Vaibhav Joshi
Hi Check cell in green with formula to calculate net working hours, put holiday in cell J so it will exclude 8 hours from total worked hours. Cheers!! On Wed, Aug 13, 2014 at 1:57 PM, son nguyen sonnguye...@gmail.com wrote: Dear Expert. I faced on problem while calculating working hours

Re: $$Excel-Macros$$ WDV Method

2014-08-16 Thread Vaibhav Joshi
The formula gives you annual rate hence in last year it gives 12 months dep not for remaining period. Cheers!! On Sat, Aug 16, 2014 at 11:01 AM, Kanwaljit Singh Dhunna kanwal...@gmail.com wrote: Dear All, I am trying to calculate Written Down Value Rate for calculating depreciation on

$$Excel-Macros$$ Need a quick help

2014-08-16 Thread Ujjwal Desai
Hello i have a file which contains a macro to convert excel data to .xml format. I am very new to vba but trying to find a solution. i would appreciate if anyone can help me with the below query : 1.File contains field of purchase order with 00(10 times 0) but when converted to xml

$$Excel-Macros$$ VBA Email Automation

2014-08-16 Thread Elissa Blank
Hi, I need help with my code. I want an excel file to save (stamp time), every thirty minutes, and send it to me . I have gotten the file to save (stamp time) and send it to me. however, when I try to do this continuously for 30 min, I run into issues. below is my code, anyone have any

Re: $$Excel-Macros$$ Fwd: Help needed

2014-08-16 Thread Kaushik
Hi Team, Finding each cell in whole workbook would be very time consuming with ctrl + f. Can u pls suggest some short cut to get the desired results. Regards, Kaushik -- 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

Re: $$Excel-Macros$$ Need a quick help

2014-08-16 Thread Vaibhav Joshi
Hey Ujwal FA per your need. Multiple files with SAP doc name will be created in destination folder. Cheers!! On Sat, Aug 16, 2014 at 10:34 PM, Ujjwal Desai ujjwal1...@gmail.com wrote: Hello i have a file which contains a macro to convert excel data to .xml format. I am very new to vba

Re: $$Excel-Macros$$ Fwd: Help needed

2014-08-16 Thread Vaibhav Joshi
Kaushik bhai, Did you checked link i gave?? On Sun, Aug 17, 2014 at 6:09 AM, Kaushik savla.kaus...@gmail.com wrote: Hi Team, Finding each cell in whole workbook would be very time consuming with ctrl + f. Can u pls suggest some short cut to get the desired results. Regards, Kaushik

Re: $$Excel-Macros$$ VBA Email Automation

2014-08-16 Thread Vaibhav Joshi
Hi If you know how to code then use on time function in VBA to create new macro to call your main macro every 30 minutes. So by doing so you can also use excel simultaneously. Do let us know if you need further help. Cheers!! On Sun, Aug 17, 2014 at 3:06 AM, Elissa Blank

Re: $$Excel-Macros$$X Copy sand paste dynamic data range

2014-08-16 Thread Vaibhav Joshi
Hi Browse thru forum, solution to mass mailer is available, you can use that template. Cheers!! On Fri, Aug 15, 2014 at 1:20 AM, C.G.Kumar kumar.bemlmum...@gmail.com wrote: Hi, Can añy one would suggest ; 1. How to copy data from specific worksheeet . data range is dynamic meaning end