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 kumar.ashish...@gmail.com wrote: Hi Vaibhav, Bro its

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 v...@vabs.in 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

Re: $$Excel-Macros$$ Transpose data

2014-08-31 Thread Vaibhav Joshi
Cheers. On Aug 31, 2014 1:41 PM, Rupesh Patil patil.rupesh1...@gmail.com 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 v...@vabs.in wrote: Cheers Bro.. Check this it has macro, i assume if

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 bigsmile...@gmail.com 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

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

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

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

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

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 bigsmile...@gmail.com 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

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 ronsmith...@gmail.com 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,

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 nitinbal...@live.com wrote: Hi Experts, I am in fix over this part of my report automation and require your help. Please refer to attached file.

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 annedimag...@gmail.com wrote: I have the following code that copies a range and pastes it every 20 seconds on the next line in

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, adityagalaxy1...@gmail.com wrote: Sir, need help to create a macro to show slowly movement on