Re: $$Excel-Macros$$ Re: Fix the Shape

2014-11-15 Thread Vaibhav Joshi
Hi You can add floating form with image!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 15, 2014 at 10:50 AM, Eugene Bernard eugene.bern...@gmail.com wrote: Thanks, I am, temporarily doing by this mehod only. regards Eugene On Sat, Nov

Re: $$Excel-Macros$$ Re: Fix the Shape

2014-11-15 Thread Vaibhav Joshi
PM, Vaibhav Joshi v...@vabs.in wrote: Hi You can add floating form with image!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 15, 2014 at 10:50 AM, Eugene Bernard eugene.bern...@gmail.com wrote: Thanks, I am, temporarily doing

Re: $$Excel-Macros$$ Re: Fix the Shape

2014-11-15 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 15, 2014 at 8:42 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, It's GREAT!!! Fantastic :) Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

2014-11-15 Thread Vaibhav Joshi
Can you explain it bit more with one example sample of 9 to 10 lines only... Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 12, 2014 at 4:52 PM, Laxmanan M laxflyflow...@gmail.com wrote: Thanks vabz, How to achieve the second macro using

Re: $$Excel-Macros$$ Need Help

2014-11-15 Thread Vaibhav Joshi
Used this Formula in D2 and drag down. . =SUBSTITUTE(A2, ,) Cheers On Nov 16, 2014 9:32 AM, Imran Khan ikha...@gmail.com wrote: To All:- PLease help me to provide formula to eliminate the space. Example file attached. Regards, *Imran Khan* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

$$Excel-Macros$$ Inbox by Gmail Invite for Excel Macros Group.

2014-11-14 Thread Vaibhav Joshi
Friends, I have few Inbox by Gmail Invite, wish to share with you all. Send me an email if you want one do not reply to this message if you need one. Read more about this product: http://www.tuaw.com/2014/11/12/google-inbox-is-a-handy-way-to-optimize-your-gmail-with-a-few-ca/ Cheers!! --

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-11-13 Thread Vaibhav Joshi
Cheers Mandeep !! On Nov 13, 2014 2:29 PM, Mandeep Baluja rockerna...@gmail.com wrote: Hello All, My name is Mandeep , I have been working as a MIS Executive since 1 year. I have keen interest in excel and love the power of VBA. Hope I will help you in some of your issues. Regards,

Re: $$Excel-Macros$$ regarding 4 step filter

2014-11-13 Thread Vaibhav Joshi
here you go... ensure not to change input sheet name or if you chage them update code.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Nov 13, 2014 at 12:05 PM, Vaibhav Joshi v...@vabs.in wrote: With macro also it is possible quite easy

Re: $$Excel-Macros$$ Macro for word phrase recongnition count of them

2014-11-13 Thread Vaibhav Joshi
Macro goes here... Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Nov 13, 2014 at 1:05 PM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear Ashish, Thanks a lot for your efforts. However, I need the output in the same way as in my

Re: $$Excel-Macros$$ Explanation for VBA

2014-11-13 Thread Vaibhav Joshi
Hi Mandeep Check this...https://www.udemy.com/blog/vba-regex/ http://www.macrostash.com/2011/10/08/simple-regular-expression-tutorial-for-excel-vba/ Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Nov 13, 2014 at 2:47 PM, Mandeep Baluja

Re: $$Excel-Macros$$ Explanation for VBA

2014-11-13 Thread Vaibhav Joshi
This one is for what you are looking for... http://www.regular-expressions.info/email.html + *I did not do this for you. God is here working through me for you.* On Thu, Nov 13, 2014 at 2:47 PM, Mandeep Baluja rockerna...@gmail.com wrote: Please explain the last line !! What's going on

Re: $$Excel-Macros$$ regarding 4 step filter

2014-11-13 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Nov 13, 2014 at 5:59 PM, Pol Ktk polkarnat...@gmail.com wrote: Ultimate Sir Thank you.. On 13 November 2014 16:38, Vaibhav Joshi v...@vabs.in wrote

Re: $$Excel-Macros$$ Macro for word phrase recongnition count of them

2014-11-12 Thread Vaibhav Joshi
Cool bro.. On Nov 13, 2014 10:20 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Amit Sir, Pls check, can it helps. 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 @

Re: $$Excel-Macros$$ Need help to create a user form.

2014-11-12 Thread Vaibhav Joshi
Great one buddy! On Nov 13, 2014 4:13 AM, Bé Trần Văn betnmtdongna...@gmail.com wrote: Opening a file to show form. To import the data: Typing data into the form and click the Data Entry To edit data:Click listbox to select data, The data will appear on the form, Edit the data needed, and

Re: $$Excel-Macros$$ regarding 4 step filter

2014-11-12 Thread Vaibhav Joshi
send otherwise its ok thanks On 13 November 2014 11:26, Vaibhav Joshi v...@vabs.in wrote: Hi Check this.. You need to create helper sheet to list all unique values if condition matched.. First i created unique list for first condition met then for second third for 4th

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

2014-11-11 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Nov 11, 2014 at 4:49 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, It's great. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Insertion of calculation column in Pivot

2014-11-11 Thread Vaibhav Joshi
snapshot has been attached. If possible then please a sample solution file i will learn from it but unfortunately i unable to make done% as a part of pivot. Thanks, On 11/9/14, Vaibhav Joshi v...@vabs.in wrote: Check this... You need to select Pvt Tbl Tools, Options, Formulas then Calculated

Re: $$Excel-Macros$$ VBA help

2014-11-11 Thread Vaibhav Joshi
Hi Can you share sample data with desired result.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Nov 11, 2014 at 1:17 PM, Mandeep Baluja rockerna...@gmail.com wrote: I have made this code for I have two worksheets that are in the same workbook.

Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

2014-11-11 Thread Vaibhav Joshi
check this code for macro 1 Option Explicit Sub Check_Dupe_2() Dim n, i, str() As String Application.ScreenUpdating = False n = Range(A Rows.Count).End(xlUp).Row ReDim str(1 To n + 1) With CreateObject(Scripting.Dictionary) For i = 1 To n str(i) = Cells(i, C) Chr(30) Cells(i, AF)

Re: $$Excel-Macros$$ Re: For Information

2014-11-11 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Nov 11, 2014 at 4:06 PM, Mandeep Baluja rockerna...@gmail.com wrote: One thing I let you know that you're are truely awesome in excel and in concepts the way you answering the questions of Excel VBA

Re: $$Excel-Macros$$ Re: VBA help

2014-11-11 Thread Vaibhav Joshi
Check this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Nov 11, 2014 at 1:33 PM, Mandeep Baluja rockerna...@gmail.com wrote: I have made this code for I have two worksheets that are in the same workbook. On Tuesday, November 11, 2014

Re: $$Excel-Macros$$ - Fetching Vertical data into Horizontal

2014-11-10 Thread Vaibhav Joshi
Hi Pl check this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Nov 10, 2014 at 4:15 PM, Amit Gandhi silkyro...@gmail.com wrote: Hi All I am using Excel 2010. I have Raw Data shown in range C1:M9. I need a vba macro to get desired output as

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-10 Thread Vaibhav Joshi
Once you are in the Account Settings, look under 'Personal Info', and look at the current Country/Region of your account it should be Czech Republic to change it to comma instead of dot. + *I did not do this for you. God is here working through me for you.* On Tue, Nov 11, 2014 at 2:56 AM,

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-11-09 Thread Vaibhav Joshi
Hey Paul R Cheers n nice to see you! On Nov 9, 2014 6:17 AM, Paul Reader intuita...@gmail.com wrote: Hi all, I'm Paul from Australia. A former corporate IT trainer and small solution developer interested in bringing my knowledge up to date. My other interests include photography, web

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-11-09 Thread Vaibhav Joshi
Namaste Vaibhav Joshi I'm still learner like you.. And the is only one way to learn.. Participate even though you know it or not! This will invoke a keen learning habit n openes up new avenues. Cheers buddy!! On Nov 9, 2014 10:42 AM, Vaibhav Joshi vaibhav...@gmail.com wrote: Hi I am

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-09 Thread Vaibhav Joshi
Hi Try this, Run macro by clicking blue button, select range containing number when prompted!! You will get output as desired without help of any helper sheet. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 8, 2014 at 1:46 PM, ivavok

Re: $$Excel-Macros$$ Transpose Several Rows to Columns

2014-11-09 Thread Vaibhav Joshi
Hi Rashid, PFA, i have made it to select any range as Input with specific cell as destination. On prompting first select entire range Range A1:E3 in this case, then on prompt select destination cell i.e.cell H1 or any cell you want... Cheers!! + *I did not do this for you. God is here

Re: $$Excel-Macros$$ Insertion of calculation column in Pivot

2014-11-09 Thread Vaibhav Joshi
Check this... You need to select Pvt Tbl Tools, Options, Formulas then Calculated Item... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 8, 2014 at 1:26 PM, Tarun Verma bhawani.pa...@gmail.com wrote: Hi Team, Today i am tucked in a problem

Re: $$Excel-Macros$$ Formula Help !

2014-11-09 Thread Vaibhav Joshi
Check this if it helps... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 8, 2014 at 6:10 PM, Ajay AJ ajay@gmail.com wrote: ​​ Hey, So the basic concept is that he dates are for PPM Schedule so which means whenever it was left off, it

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-09 Thread Vaibhav Joshi
Ok, here you go.. Also do you need to change no. format to match with your native currency? + *I did not do this for you. God is here working through me for you.* On Sun, Nov 9, 2014 at 11:49 PM, ivavok ivana.vokrouhlik...@gmail.com wrote: Hi, that´s perfect! Thanks. Just the comma is

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-11-08 Thread Vaibhav Joshi
Welcome Tarun... Cheers!! On Nov 8, 2014 1:23 PM, Tarun Verma bhawani.pa...@gmail.com wrote: Hi Excel Racers, I am working in MNC as Sr. MIS Executive for Reporting Analytics. I used this forum for learning new excel things I visit daily this forum to learn one new thing daily and this

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-11-08 Thread Vaibhav Joshi
Hi I am vaibhav joshi from Mumbai working for a cosmetic company in accounts dept. This group is very useful for me since I come to know various hidden talented function formulas. I am very curious about excel would like to learn how to create Macro's their use in day to day working. My name

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-07 Thread Vaibhav Joshi
Hi I see there is a space between number and Kč so use Kč instead. Cheers !! On Nov 7, 2014 8:15 PM, ivavok ivana.vokrouhlik...@gmail.com wrote: Hi, I would appreciate if you could help me with this macro: *Columns(C:C).Select* *Selection.Replace What:=Kč, Replacement:=,

Re: $$Excel-Macros$$ How to get value in next cell

2014-11-05 Thread Vaibhav Joshi
check last 2 column, you can use them as helper column then do vlookup. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Nov 4, 2014 at 10:36 PM, Bholanath Verma bholanathve...@gmail.com wrote: Hi Group Please find attached file, i am locking

Re: $$Excel-Macros$$ Can't show results of a calculation

2014-11-05 Thread Vaibhav Joshi
here you go... Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 5, 2014 at 4:35 AM, takis aravid...@gmail.com wrote: Hello! I have a problem with this document. I make some simple calculations of ranges but in the last step when I need to get

Fwd: $$Excel-Macros$$ Automatic update excel file from website

2014-11-04 Thread Vaibhav Joshi
FYI + *I did not do this for you. God is here working through me for you.* -- Forwarded message -- From: Vaibhav Joshi v...@vabs.in Date: Sat, Nov 1, 2014 at 3:17 PM Subject: Re: $$Excel-Macros$$ Automatic update excel file from website To: excel-macros@googlegroups.com excel

Re: $$Excel-Macros$$ how to copy a text from a cell into several rows

2014-11-04 Thread Vaibhav Joshi
here you go... Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 5, 2014 at 2:00 AM, ivavok ivana.vokrouhlik...@gmail.com wrote: Great, that´s just perfect! Thank you very much! What if the initial row with the text to be copied should be deleted

Re: $$Excel-Macros$$ Re: Four options to every question need to be randomized

2014-11-04 Thread Vaibhav Joshi
Thanks for posting. + *I did not do this for you. God is here working through me for you.* On Wed, Nov 5, 2014 at 9:40 AM, Rajnish Malhotra freeofcosthotels...@gmail.com wrote: I got an answer at excelforum and thought I should update the link

$$Excel-Macros$$ Userform - Login Disable Add-ins

2014-11-03 Thread Vaibhav Joshi
myxlguru, Add new module in this macro with follo. code. Call this macro whenever there is unsuccessful event. Once macro is ready create add-in of macro file install it. So whenever is excel is loaded it will disable addins if unsucessfull login.. code: Sub Disable_Addin() Dim

Re: $$Excel-Macros$$ how to copy a text from a cell into several rows

2014-11-03 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Nov 4, 2014 at 11:56 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, It's perfect. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ My macro won't work in Excel 2013. Please help.

2014-11-03 Thread Vaibhav Joshi
Hi Use this code: Sub Macro1() If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData End If Range(F4:F16).ClearContents ActiveSheet.Range($A$1:$E$279).AutoFilter Field:=1, Criteria1:=RGB(255, _ 0, 0), Operator:=xlFilterCellColor a = Range(A Rows.Count).End(xlUp).Row Set Rng =

Re: $$Excel-Macros$$ how to copy a text from a cell into several rows

2014-11-02 Thread Vaibhav Joshi
Iva Check this, do let us know for further help. Cheers! + *I did not do this for you. God is here working through me for you.* On Mon, Nov 3, 2014 at 12:47 AM, ivavok ivana.vokrouhlik...@gmail.com wrote: Hello, I would appreciate if you could help me with this macro: The macro

Re: $$Excel-Macros$$ Automatic update excel file from website

2014-11-01 Thread Vaibhav Joshi
check this... cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Oct 31, 2014 at 8:42 PM, Vaibhav Joshi v...@vabs.in wrote: Though it looks simple, but not the same! I will try send you working file for MCA too. Cheers!! + *I did not do

Re: $$Excel-Macros$$ A simple standard listbox to call subrotines

2014-11-01 Thread Vaibhav Joshi
Hi Luciano Do let Us know if you need further help. Cheers On Oct 30, 2014 6:47 PM, luciano de souza luchya...@gmail.com wrote: The solution is really very well. Dropdown menus are very accessible for screen readers. I think 90% of problems are solved. Why 90%? Becose sometimes macros are

Re: $$Excel-Macros$$ Pasting Data from Different Files in One Worksheet

2014-11-01 Thread Vaibhav Joshi
Ujjwal Check this thread $$Excel-Macros$$Merge files with few criteria of pasting Cheers! On Oct 31, 2014 7:16 PM, Ujjwal Desai ujjwal1...@gmail.com wrote: Hello , Can we get the combined output in a new worksheet with the help of this macro. Thanks, Ujjwal On Saturday, October 18,

Re: $$Excel-Macros$$ Automatic update excel file from website

2014-10-31 Thread Vaibhav Joshi
sharing one more file which have to extract data from mca website. ​Can you please please do the same programming in this file too... Thanks Regards, BS​ ​ *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi *Sent:* Thursday, 30

Re: $$Excel-Macros$$ Automatic update excel file from website

2014-10-30 Thread Vaibhav Joshi
*From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi *Sent:* Thursday, 30 October, 2014 12:11 AM *To:* excel-macros@googlegroups.com *Cc:* Rajan Verma *Subject:* Re: $$Excel-Macros$$ Automatic update excel file from website Check

Re: $$Excel-Macros$$ A simple standard listbox to call subrotines

2014-10-30 Thread Vaibhav Joshi
Hi Luciana, I suggest simple way, using data validation in excel. Goto cell A1, assign data validation to it. By pressing Alt + D then V then L will invoke data validation menu. Under Setting tab, under Allow select List. Keep Ignore blank In cell dropdown as checked. Under source type

Re: $$Excel-Macros$$ Automatic update excel file from website

2014-10-30 Thread Vaibhav Joshi
Cheers Bro.. + *I did not do this for you. God is here working through me for you.* On Thu, Oct 30, 2014 at 7:08 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, It's great.!! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Automatic update excel file from website

2014-10-29 Thread Vaibhav Joshi
Check this you will need to press enter when error appears or just disble IE dialogues. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Oct 25, 2014 at 2:17 PM, B Sharma sharma@gmail.com wrote: Dear Excel Gurus, I am trying to update my

Re: $$Excel-Macros$$ Automatic update excel file from website

2014-10-29 Thread Vaibhav Joshi
to run macro, click blue button, on prompt select range with TIN no. and press OK + *I did not do this for you. God is here working through me for you.* On Thu, Oct 30, 2014 at 12:11 AM, Vaibhav Joshi v...@vabs.in wrote: Check this you will need to press enter when error appears

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-28 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Oct 28, 2014 at 1:35 PM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: Hi Vaibhav Bhai, Working Perfectly. Thanks... Superb...!! You are amazing *Thanks,* *Nilkanth Raval* *+91 900 428 0

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-28 Thread Vaibhav Joshi
Check this.. + *I did not do this for you. God is here working through me for you.* On Tue, Oct 28, 2014 at 3:11 PM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: Hi Vaibhav bhai, Your code is working perfectly but in attached file, your code is not working correctly. can you please

Re: $$Excel-Macros$$ How to pull ID#s that meet yes to different criteria columns into seperate sheet

2014-10-28 Thread Vaibhav Joshi
can you share sample sheet? + *I did not do this for you. God is here working through me for you.* On Tue, Oct 28, 2014 at 10:19 PM, Jessica jesswi...@gmail.com wrote: I have an excel spreadsheet with client ID#s and varying criteria in each column header. If they meet yes criteria in 5

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-27 Thread Vaibhav Joshi
For each tab color separate workbook or colored WS in separate WB? Want to copy or move WS? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 27, 2014 at 1:33 PM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: On 26 October 2014 09:06, Ashish Kumar

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-27 Thread Vaibhav Joshi
Check this sheet with code under module Move_Same_ColoredTab This will move all same colored sheets to new WB with existing WB name with suffix 1,2 ,3 etc. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 27, 2014 at 1:33 PM, Nilkanth Raval

Re: $$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-26 Thread Vaibhav Joshi
Hi check this.. before generating new file all data will get cleared post generate file... you will get msg once file is generated and folder containing file will get opened too + *I did not do this for you. God is here working through me for you.* On Sun, Oct 26, 2014 at 11:27 AM,

Re: $$Excel-Macros$$ Macro needed to move multiple choice questions into an excel row with a fixed format

2014-10-26 Thread Vaibhav Joshi
where you want output from each sheets?? + *I did not do this for you. God is here working through me for you.* On Sat, Oct 25, 2014 at 11:57 PM, Noam Fischman noamfisch...@gmail.com wrote: Hi all, I need to convert multiple choice questions into a rows in an excel file in a fixed

Re: $$Excel-Macros$$ Macro needed to move multiple choice questions into an excel row with a fixed format

2014-10-26 Thread Vaibhav Joshi
Chek this file... I have created macro that will merge all sheets in conso sheet... Click blue button to run macro... Revert back for any query Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Oct 26, 2014 at 1:43 PM, Vaibhav Joshi v...@vabs.in

Re: $$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-26 Thread Vaibhav Joshi
Cheers !! On Oct 26, 2014 2:48 PM, Laxmanan M laxflyflow...@gmail.com wrote: Dear VAbz, i dont have a special words to say thanks..It's charm.. lax On Sunday, October 26, 2014 12:56:50 PM UTC+5:30, Vabz wrote: Hi check this.. before generating new file all data will get cleared

Re: $$Excel-Macros$$ Macro needed to move multiple choice questions into an excel row with a fixed format

2014-10-26 Thread Vaibhav Joshi
That's great... Cheers! On Oct 26, 2014 10:10 PM, Noam Fischman noamfisch...@gmail.com wrote: works like a charm! :) thanks again. On Sun, Oct 26, 2014 at 11:17 AM, Vaibhav Joshi v...@vabs.in wrote: Chek this file... I have created macro that will merge all sheets in conso sheet

Re: $$Excel-Macros$$ Happy Diwali

2014-10-25 Thread Vaibhav Joshi
Very happy Diwali and prosperous new year to all friends.. On Oct 25, 2014 10:39 AM, amar takale amartak...@gmail.com wrote: Dear All excel champs Wishing you a very happy and prosperous Diwali to all my friends. Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-25 Thread Vaibhav Joshi
hi can you explain how data is fetched for this 2.. For w12 W13??? + *I did not do this for you. God is here working through me for you.* On Sat, Oct 25, 2014 at 9:15 PM, Laxmanan M laxflyflow...@gmail.com wrote: Pls help me.. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-25 Thread Vaibhav Joshi
Check this... Click blue button to run macro.. When prompted select month name in data sheet, in your case it will be cell AP3 (cell highlighted with green color for current example, you can select any other month too) you will get output file as desired.. Note, i have kept same file / sheet

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-25 Thread Vaibhav Joshi
what exactly you are trying to achieve? + *I did not do this for you. God is here working through me for you.* On Fri, Oct 24, 2014 at 8:46 PM, Nilkanth Raval nilkanth.ra...@gmail.com wrote: Dear Sir, I need your help in Moving Multiple worksheets by tab color. I write the below code,

Re: $$Excel-Macros$$ automatically expanding stock/forex prices

2014-10-25 Thread Vaibhav Joshi
can you share you existing code with sample input data output data.. + *I did not do this for you. God is here working through me for you.* On Fri, Oct 24, 2014 at 1:41 AM, paidtosignups1 paidtosign...@gmail.com wrote: How do you do an excel spreadsheet, where each new price of a stock

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-25 Thread Vaibhav Joshi
check this: http://www.ozgrid.com/VBA/group-sheets.htm revert if you need help... + *I did not do this for you. God is here working through me for you.* On Sun, Oct 26, 2014 at 1:34 AM, Vaibhav Joshi v...@vabs.in wrote: what exactly you are trying to achieve? + *I did not do

Re: $$Excel-Macros$$ New Member

2014-10-23 Thread Vaibhav Joshi
Hey welcome More you participate more you will learn. .. On Oct 23, 2014 5:50 PM, Laxmanan M laxflyflow...@gmail.com wrote: Hi There, Am new to this forum and i want to learn things in VBA..Had a look on this forum for past one month..I really like it and impressed a lot.Also have read the

Re: $$Excel-Macros$$ Write X,Y,Z Data

2014-10-22 Thread Vaibhav Joshi
Try this... Make sure data is in same format, run macro you will get desired output... Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Oct 22, 2014 at 6:53 AM, josua sitinjak josuasitinja...@gmail.com wrote: Hello MS EXCEL AND VBA MACROS member.

Re: $$Excel-Macros$$ Re: How can one control data entry and truly protect a verified entry

2014-10-22 Thread Vaibhav Joshi
you can use this to work on VBA Sub RB() Dim Avar As String, Nvar As Long Dim Frow As Integer, Fcol As Integer ' Start row data entry Frow = 9: Fcol = 1 ' aka A Cells(Frow, Fcol).Select Avar = Application.InputBox(Enter value!!, Type:=3) ' want to wait for user entry; obviously i

Re: $$Excel-Macros$$ Re: How can one control data entry and truly protect a verified entry

2014-10-22 Thread Vaibhav Joshi
see this file.. + *I did not do this for you. God is here working through me for you.* On Wed, Oct 22, 2014 at 2:29 PM, Vaibhav Joshi v...@vabs.in wrote: you can use this to work on VBA Sub RB() Dim Avar As String, Nvar As Long Dim Frow As Integer, Fcol As Integer ' Start row data

Re: $$Excel-Macros$$ Re: Pasting Data from Different Files in One Worksheet

2014-10-21 Thread Vaibhav Joshi
cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Oct 21, 2014 at 5:08 PM, Hasnain Raja mhr...@gmail.com wrote: Thanks guys for your help actually I was able to fix my code with line from Vabz. I wasn't able to open the file sent due to firewall at

Re: $$Excel-Macros$$ Re: How can one control data entry and truly protect a verified entry

2014-10-20 Thread Vaibhav Joshi
Hi can you share sample files... + *I did not do this for you. God is here working through me for you.* On Mon, Oct 20, 2014 at 3:34 AM, Robert Baer robertgurrb...@gmail.com wrote: On Saturday, October 18, 2014 8:16:05 PM UTC-7, Robert Baer wrote: Assume one has a spreadsheet with

Re: $$Excel-Macros$$ Sending Automatic Emails On Deadline : Google Doc Spreadsheet

2014-10-19 Thread Vaibhav Joshi
functions are not tested due to trigger issue, so if you find any problems please guide me as this is my first time with Google forms Java Script. Regards, Hasnain On Thu, Oct 16, 2014 at 6:18 PM, Vaibhav Joshi v...@vabs.in wrote: Ok. Send me your whole code. Will add on time trigger

Re: $$Excel-Macros$$ Sending Automatic Emails On Deadline : Google Doc Spreadsheet

2014-10-18 Thread Vaibhav Joshi
with Google forms Java Script. Regards, Hasnain On Thu, Oct 16, 2014 at 6:18 PM, Vaibhav Joshi v...@vabs.in wrote: Ok. Send me your whole code. Will add on time trigger. On Oct 16, 2014 2:54 PM, Hasnain Basit smhasnai...@gmail.com wrote: Thanks a lot, it solved my supplementary problem

Re: $$Excel-Macros$$ Re: Pasting Data from Different Files in One Worksheet

2014-10-18 Thread Vaibhav Joshi
add this line before... wsMain.select : wsRD.select cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Oct 18, 2014 at 7:31 PM, Hasnain Raja mhr...@gmail.com wrote: Yes exactly. On Saturday, 18 October 2014 14:29:09 UTC+1, Hasnain Raja wrote: Hi

Re: $$Excel-Macros$$ Pasting Data from Different Files in One Worksheet

2014-10-18 Thread Vaibhav Joshi
Ashish its working great, tested on 11K line items.. + *I did not do this for you. God is here working through me for you.* On Sat, Oct 18, 2014 at 7:42 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: HI, PFA.!! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Need a macro to get consolidated report

2014-10-17 Thread Vaibhav Joshi
Great.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Oct 17, 2014 at 1:42 AM, Ujjwal Desai ujjwal1...@gmail.com wrote: Thanks Vaibhav !!! Your file is working perfectly matching with my requirement. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ Sending Automatic Emails On Deadline : Google Doc Spreadsheet

2014-10-16 Thread Vaibhav Joshi
Ok. Send me your whole code. Will add on time trigger. On Oct 16, 2014 2:54 PM, Hasnain Basit smhasnai...@gmail.com wrote: Thanks a lot, it solved my supplementary problem but my main problem of sending Reminder before deadline is still there. I am unable to find solution for it. Closest

Re: $$Excel-Macros$$ Sending Automatic Emails On Deadline : Google Doc Spreadsheet

2014-10-15 Thread Vaibhav Joshi
hey check this..do let us know if you need any help further.. http://www.labnol.org/internet/auto-confirmation-emails/28386/ Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Oct 15, 2014 at 7:32 PM, Hasnain Basit smhasnai...@gmail.com wrote: Hello

Re: $$Excel-Macros$$ Need a macro to get consolidated report

2014-10-15 Thread Vaibhav Joshi
hey somehow not able to take time in preparing macro for you, emantime you can use this code to consol your files do manually PVT. Run macro select folder to import data directly... Hope this helps // Cheers + *I did not do this for you. God is here working through me for you.* On Tue,

Re: $$Excel-Macros$$ Report

2014-10-14 Thread Vaibhav Joshi
welcome bro.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 3:23 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi v...@vabs.in wrote: Thanks bro... On Oct 12

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-14 Thread Vaibhav Joshi
cheers man... + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 3:46 PM, Waseem Saifi waseemsa...@gmail.com wrote: thank you vaibhav, it's perfect On Sun, Oct 12, 2014 at 4:39 PM, Vaibhav Joshi v...@vabs.in wrote: check this... + *I

Re: $$Excel-Macros$$ Excel - Return on Investment

2014-10-14 Thread Vaibhav Joshi
Is re-payment is monthly or annually? + *I did not do this for you. God is here working through me for you.* On Tue, Oct 14, 2014 at 1:04 PM, Falina Gan falina...@gmail.com wrote: To Whom It May Concern, May I ask, how do we calculate the ROI as I have upload the excel. Thanks. --

Re: $$Excel-Macros$$ Re: Excel - Return on Investment

2014-10-14 Thread Vaibhav Joshi
Ok, check revise sheet, if payment mode is annual then you need to calculate emi for a year not month. Check revise sheet.. + *I did not do this for you. God is here working through me for you.* On Tue, Oct 14, 2014 at 2:10 PM, Falina Gan falina...@gmail.com wrote: yearly On Tuesday,

Re: $$Excel-Macros$$ Need a macro to get consolidated report

2014-10-13 Thread Vaibhav Joshi
can you share sample for conso file too.. + *I did not do this for you. God is here working through me for you.* On Mon, Oct 13, 2014 at 1:27 AM, Ujjwal Desai ujjwal1...@gmail.com wrote: Hello , I am in need of a macro which will help me to get a consolidated report of daily data saved

Re: $$Excel-Macros$$ Report

2014-10-12 Thread Vaibhav Joshi
that updates the formula in final sheet based on STD. Right now i need to manually change formula in every new Final sheet. i.e. VLOOKUP range. On Sat, Oct 11, 2014 at 12:22 AM, Vaibhav Joshi v...@vabs.in wrote: Ok. .Cheers On Oct 10, 2014 1:27 AM, joseph camill joseph.cam...@gmail.com wrote: Hi

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-12 Thread Vaibhav Joshi
cell. On Sat, Oct 11, 2014 at 6:22 AM, Vaibhav Joshi v...@vabs.in wrote: how do you want output? Formula or thru Macro? + *I did not do this for you. God is here working through me for you.* On Sat, Oct 11, 2014 at 10:19 AM, Waseem Saifi waseemsa...@gmail.com wrote: Hi Experts

Re: $$Excel-Macros$$ Report

2014-10-12 Thread Vaibhav Joshi
Thanks bro... On Oct 12, 2014 6:05 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, Nice Solution. Sheet is working Great. 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

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-11 Thread Vaibhav Joshi
how do you want output? Formula or thru Macro? + *I did not do this for you. God is here working through me for you.* On Sat, Oct 11, 2014 at 10:19 AM, Waseem Saifi waseemsa...@gmail.com wrote: Hi Experts, I have attached a file which contain text in cell A15. I want to split this

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-11 Thread Vaibhav Joshi
check this..you can combine formula to get final result. + *I did not do this for you. God is here working through me for you.* On Sat, Oct 11, 2014 at 7:02 PM, Swapnil Palande palande.swapni...@gmail.com wrote: Hi, Try text to column option. Regards, Swapnil On 11-Oct-2014 10:19

Re: $$Excel-Macros$$ Excel calculating repayment and interest

2014-10-11 Thread Vaibhav Joshi
On Fri, Oct 10, 2014 at 6:39 PM, Vaibhav Joshi v...@vabs.in wrote: pl share excel file. + *I did not do this for you. God is here working through me for you.* On Fri, Oct 10, 2014 at 10:54 AM, Falina Gan falina...@gmail.com wrote: To Whom It May Concern, May I ask how do you calculate

Re: $$Excel-Macros$$ Excel calculating repayment and interest

2014-10-10 Thread Vaibhav Joshi
pl share excel file. + *I did not do this for you. God is here working through me for you.* On Fri, Oct 10, 2014 at 10:54 AM, Falina Gan falina...@gmail.com wrote: To Whom It May Concern, May I ask how do you calculate the table that show per-attachment especially on the principle

Re: $$Excel-Macros$$ Report

2014-10-10 Thread Vaibhav Joshi
and do a final check. On Fri, Oct 10, 2014 at 12:48 AM, Vaibhav Joshi v...@vabs.in wrote: Joseph Did you tried this. . -- Forwarded message -- From: Vaibhav Joshi v...@vabs.in Date: Oct 7, 2014 10:51 AM Subject: Re: $$Excel-Macros$$ Report To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-10-06 Thread Vaibhav Joshi
Hey Sanjay.. warm welcome.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Oct 5, 2014 at 11:07 PM, sanjay kumar sanjay.kr2...@gmail.com wrote: hello, My name is Sanjay and I work at HCL in Noida. I use Excel, VBA and some other tools for daily

Re: $$Excel-Macros$$ Report

2014-10-06 Thread Vaibhav Joshi
.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working

Re: $$Excel-Macros$$ Refresh BackgroundQuery:=False doesn't work

2014-10-06 Thread Vaibhav Joshi
check this... its working for me. but lil time consuming.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Oct 5, 2014 at 9:58 PM, Nur Hossain nur2...@gmail.com wrote: Dear all , I was using attached macro since last few months . and I didn’t get

Re: $$Excel-Macros$$ Report

2014-10-06 Thread Vaibhav Joshi
, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, You have 2 sheets in this excel workbook, I am creating new sheets after sheet 2 for each students, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-10-06 Thread Vaibhav Joshi
Warm welcome Chandru!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:22 PM, Chandru chandr...@gmail.com wrote: Hello All, I Am Chandru from Chennai and I work at Logitek. Regards, Chandru On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav

Re: $$Excel-Macros$$ Report

2014-10-06 Thread Vaibhav Joshi
, 2014 at 1:44 PM, Vaibhav Joshi v...@vabs.in wrote: what other requests? + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any

<    1   2   3   4   5   6   7   8   9   10   >