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 wrote: > Hi, > > Can añy one would suggest ; > > 1. How to copy data from specific worksheeet . data range is dynamic > meaning end row is varying but hea

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 wrote: > Hi, > > I

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 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 > > -- > Are you =E

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

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 pag

$$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 idea

$$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

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 > depreciatio

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 wrote: > Dear Expert. > > I faced on problem while calculating working hours between 2 time (maybe

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" 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!!

$$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 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 wrote: >> >>> Hello, >