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