Re: $$Excel-Macros$$ gogmap

2014-08-31 Thread Vaibhav Joshi
Hi Try this: http://excelvbaprogramming.tumblr.com/post/36670791168 http://www.excelvbamacros.in/2012/12/plot-locations-on-google-chart-map-by.html Cheers!! On Sat, Aug 30, 2014 at 7:49 PM, wrote: > Sir, > need help to create a macro to show slowly movement on google map or > google earth >

Re: $$Excel-Macros$$ Copy paste help needed in macro

2014-08-31 Thread Vaibhav Joshi
hi use this 2 lines in top Dim myloc As Range Set myloc = ActiveCell & use this line in bottom myloc.Select Cheers!! On Mon, Sep 1, 2014 at 8:21 AM, AED wrote: > I have the following code that copies a range and pastes it every 20 > seconds on the next line in Sheet2. Here is the probl

Re: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell in calculation

2014-08-31 Thread Vaibhav Joshi
Hi How excel will know the starting month & current month for which you are calculating formula? On Sun, Aug 31, 2014 at 3:31 PM, Nitin Balodi wrote: > Hi Experts, > > I am in fix over this part of my report automation and require your help. > > Please refer to attached file. Description is

Re: $$Excel-Macros$$ Re: Filter Issue

2014-08-31 Thread Vaibhav Joshi
yep, chk this... Cheers!! On Mon, Sep 1, 2014 at 7:49 AM, Bill Q wrote: > Can bé trần văn attachment be modified so that the two select criterias > also includes blanks ? This will solve my problem. > > > On Thursday, 14 August 2014 10:37:09 UTC-4, Bill Q wrote: >> >> Hi Guys, >> >> PSA. >> >

Re: $$Excel-Macros$$ Fwd: HELP REQUIRE TO PREPARE CHART

2014-08-31 Thread Vaibhav Joshi
chek this.. Cheers!! On Mon, Sep 1, 2014 at 9:44 AM, big smile wrote: > Vaibhav Joshiji > > It works properly. Thank you very much. > > But if u do not mind then please i want still some correction that > > if i type in C6 = 22 then automatically sheet make the calculation of 22 > years > > bu

Re: $$Excel-Macros$$ Fwd: HELP REQUIRE TO PREPARE CHART

2014-08-31 Thread big smile
Vaibhav Joshiji It works properly. Thank you very much. But if u do not mind then please i want still some correction that if i type in C6 = 22 then automatically sheet make the calculation of 22 years but i want that last total amount should come in C5. & so on On Sun, Aug 31, 2014 at 1:

$$Excel-Macros$$ Copy paste help needed in macro

2014-08-31 Thread AED
I have the following code that copies a range and pastes it every 20 seconds on the next line in Sheet2. Here is the problem, when it fires off it jumps to Sheet2 performs the task and the pauses for 20 seconds and then loops again. So if I am on Sheet1 is routes me to Sheet2 and leave me there

$$Excel-Macros$$ Re: Filter Issue

2014-08-31 Thread Bill Q
Can bé trần văn attachment be modified so that the two select criterias also includes blanks ? This will solve my problem. On Thursday, 14 August 2014 10:37:09 UTC-4, Bill Q wrote: > > Hi Guys, > > PSA. > > What I am ultimately looking for is a formula that would automatically > return all t

Re: $$Excel-Macros$$ Transpose data

2014-08-31 Thread Ashish Kumar
Hi Vaibhav, Macro sheet or Formula sheet both are working fine. Great work bro...!!! 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 RUL

Re: $$Excel-Macros$$ Fwd: HELP REQUIRE TO PREPARE CHART

2014-08-31 Thread Vaibhav Joshi
Check this. Cheers. On Aug 31, 2014 8:29 AM, "big smile" wrote: > Respected All, > > Please find the attached excel sheet > > I want to have one macro or any solution so that i can do the following > problem. > > If i write Term 20 Years in C6 then my Raw chart increase automatically > extend up

Re: $$Excel-Macros$$ Transpose data

2014-08-31 Thread Vaibhav Joshi
Cheers. On Aug 31, 2014 1:41 PM, "Rupesh Patil" wrote: > Hi Vaibhav, > > Very very thanks, > it is working as expected. > > > Thanks and regards > Rupesh > > > On Sun, Aug 31, 2014 at 12:44 PM, Vaibhav Joshi wrote: > >> Cheers Bro.. >> >> Check this it has macro, i assume if lines are in millio

Re: $$Excel-Macros$$ Transpose data

2014-08-31 Thread Rupesh Patil
Hi Vaibhav, Very very thanks, it is working as expected. Thanks and regards Rupesh On Sun, Aug 31, 2014 at 12:44 PM, Vaibhav Joshi wrote: > Cheers Bro.. > > Check this it has macro, i assume if lines are in millions than formula > will get slower.. > > Click run macro, select input sheet ha

Re: $$Excel-Macros$$ Transpose data

2014-08-31 Thread Vaibhav Joshi
Cheers Bro.. Check this it has macro, i assume if lines are in millions than formula will get slower.. Click run macro, select input sheet having data, select output sheet & done.. Cheers!! On Sun, Aug 31, 2014 at 10:29 AM, Ashish Kumar wrote: > Hi Vaibhav, > > Bro its superb solution. > > >