$$Excel-Macros$$ urgent help

2013-07-22 Thread devanand nayak
hi i have one sheet which consists of data on daily basis for whole year e.g. datecustomer name tin no net 12.5% vat 12.5% net 5% vat 5% oms tranpsort total i need this with tinwise total for whole year and whole year net total and whole year vat total any one can help me

$$Excel-Macros$$ Un protect the excel file

2013-07-22 Thread Prafull Jadhav
Dear Experts, I have given password excel file but I have forget the password ..Is there any way to recovery password. Thanks in advance. Regards, Prafull Jadhav. -- 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

$$Excel-Macros$$ spit varios sheets of one excel file to related other excel file

2013-07-22 Thread Sagar Kasangottuwar
Dear Excel experts, I want one macro which can spit varios sheets of one excel file to related other excel file. I have one excel file where 10 sheets are available ex. a, b, c, d and I have files for same sheets ex. a, b, c, d. So I want to transfer a, b, c, d sheets to a, b, c, d file. Kindly

$$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

2013-07-22 Thread Vijay Gande
Hi there, I'm amateur with excel macros and need help with the following task, I've an excel workbook with 16 sheets, all the sheets have same # of columns but different # of rows. My task is to copy the data from each of these 16 sheets and past in the consolidate sheet in the same workbook

Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

2013-07-22 Thread priti verma
Hi vijay, PFA On Mon, Jul 22, 2013 at 8:26 AM, Vijay Gande wrote: > Hi there, > > I'm amateur with excel macros and need help with the following task, > > > > I've an excel workbook with 16 sheets, all the sheets have same # of > columns but different # of rows. My task is to copy the

Re: $$Excel-Macros$$ spit varios sheets of one excel file to related other excel file

2013-07-22 Thread priti verma
Try this code Change Strpath as per your Path Sub creatnewWkb() Dim wkb As Workbook Dim strpath As String Dim wks As Worksheet Dim wkbnwebook As Workbook Set wkb = ThisWorkbook strpath = wkb.Path For Each wks In wkb.Worksheets wks.Copy wks.Paste ActiveWorkbook.SaveAs _ Filename:=

Re: $$Excel-Macros$$ Need help

2013-07-22 Thread Dhaval Shah
Thanks Ravinder :) On Mon, Jul 22, 2013 at 4:05 PM, ravinder negi wrote: > PFA.. > -- > *From:* Dhaval Shah > *To:* excel-macros@googlegroups.com > *Sent:* Monday, July 22, 2013 3:46 PM > *Subject:* $$Excel-Macros$$ Need help > > Friends > > i want to find out

$$Excel-Macros$$ index and match in VBA

2013-07-22 Thread Hilary Lomotey
Hello VBA You solution was perfect. thanks for the help, am really grateful. thanks -- 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 RULES 1) Use concise,

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-22 Thread ravinder negi
Hi, if you want through VBA then you can use below function  Function reversetext(rtext As String) reversetext = StrReverse(rtext) End Function thanks and regards Ravinder Negi From: Prafull Jadhav To: excel-macros@googlegroups.com Sent: Monday, July 22,

Re: $$Excel-Macros$$ Re: NEED FORMUALE TO PLACE DIFFERENT TYPE OF BOTTLES IN ROWS (NO DIFFERENT BOTTLES ON SAME ROW)

2013-07-22 Thread vijay yadav
Dear Excel experts, Kindly help Regards Vijay yadav On Friday, 19 July 2013 13:57:52 UTC+5:30, vijay yadav wrote: > > > Dear CGMAURYA, > > The file is attached along with this post. > > All details are mentioned below and same is also mentioned in my first > post along with attached file. > >

$$Excel-Macros$$ Need MP file templates

2013-07-22 Thread Prabhu Pinky
Hi experts pls help me with manpower planning file templates. -- 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 RULES 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

2013-07-22 Thread P.VIJAYKUMAR
Respected Bheema Shakar, Please check the links which will help with your problem. http://www.contextures.com/exceluserformdependentcomboboxes.html http://www.youtube.com/watch?v=eJslb49T0Bk Regards, VIjaykuar On Mon, Jul 22, 2013 at 12:20 PM, Shankar Bheema wrote: > Hai everyone > > I attache

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-22 Thread P.VIJAYKUMAR
Respected Ashish, Simply use the attached add-in. On Mon, Jul 22, 2013 at 12:00 PM, Ashish Kumar wrote: > Dear Seniors, > > Thank to all of you. Your help means a lot for me. thanks. > > > thanks, > Ashish > > > On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote: > >> Hi, >> >> I

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

2013-07-22 Thread Abhishek Jain
What is your criteria? Suppose I select one value in gp combo, what values should be selected in the other two? On Mon, Jul 22, 2013 at 12:20 PM, Shankar Bheema wrote: > Hai everyone > > I attached an excel sheet which contains a form. In that I placed three > nos. of combo boxes. Each have it