$$Excel-Macros$$ Need help in picking data and updating in new sheet via Macro

2013-04-08 Thread Jai Deep
Hi Group... Would appreciate if someone can help me in creating a macro or any formulated template to pick data from one sheet and update in other sheet. Process:--- Input sheet has 3 tabs: '*IntraState-Inter InterLata SDN'*, '*International Outbound'* and '*Mobile Offshore'.* ** Output sheet ha

$$Excel-Macros$$ Right approach to learn macro coding

2011-10-22 Thread deep
Hi frnzz.. i m new to this group so jst wnt to ask u people wat should be d ryt approach to start wid macrosryt nw i m going thru some of the Pdf files i have downloaded from the net. If anybody cn share any material i wud realy appreciate dat...or else if anybdy cn let me any institute or some

Re: $$Excel-Macros$$ Re: Kindly Help

2011-10-22 Thread deep
Hi Karan, Try dis one TRIM(MID(E13,FIND("Teacher",E13,1)-25,20)) Thnks On Oct 21, 6:12 pm, "dguillett1" wrote: > Sub extractstring() > On Error Resume Next > For Each c In Range("i1:i2") > f1 = InStr(c, ")") + 1 > f2 = InStr(c, "Enrol") > c.offset(,1)=Mid(c, f1, f2 - f1) > Next > End Sub > > Do

$$Excel-Macros$$ INFORMATION REQUIRED

2010-06-27 Thread CA MAGAN DEEP AGGARWAL
A TEXT OR NAME OF A EMPLOYEE. ALL OTHER WORKSHEETS ARE ALSO NAMED AS EMPLOYEE NAMES. THE INFORMATION IN THESE WORKSHEETS SHOULD GET VALUE FROM MASTER WORKSHEETS DEPENDING UPON THE NAME OF THE EMPLOYEE. PLEASE GUIDE ME FOR THIS. THANKS IN ADVANCE. REGARDS CA MAGAN DEEP AGGARWAL

$$Excel-Macros$$ Help

2010-06-04 Thread Gagan Deep Gupta
Please help in getting code for Dynamically copy and paste a formula for the no of occoupied eows in excel. Best Regards Gagan Deep Gupta -- -- Some important links for excel users: 1. Follow us on TWITTER for

$$Excel-Macros$$ Help Needed for Debit Credit entries

2009-09-16 Thread Deep
Dear Freinds, I am attaching one file which contains debit & credit amounts in same column. But previous column have D or C written which represents the amount is Debit or Credit [D for debit & C for Credit] I want to nullify {neutralise} if debit & credi

$$Excel-Macros$$ Please provide help on mail merge numerical value

2009-07-22 Thread Deep
--~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at htt