Re: $$Excel-Macros$$ Re: Code or Formula Required
Hi Paul, Thanks its almost all what I need, but only one additional thing required that is when ever I run a macro the out put alwasy with next row. I mean 1st time in output sheet row 1 2 time in output sheet row2 like this it should go with next row rather then in the same row. Can this be done? If yes it would be great help. Let me know if possilble Thanks Puttu On Mon, Mar 29, 2010 at 1:25 AM, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Puttu, Here it comes... Remark how I unmerge merged fields before grabbing the content... and then I remerge it... Let me know if this helped you out... Greetings Paul Willekens '=== Sub Normalize() Dim cAddress Dim cBusiness Dim cCity Dim cCompany Dim cContact Dim cState Dim nRow nRow = 4 'company name Sheets(Input Data).Select Cells(1, 1).Select cCompany = Selection.Value Sheets(Output).Select Cells(nRow, 1).Value = cCompany 'address Sheets(Input Data).Select Range(B12:C12).MergeCells = False Cells(12, 2).Select cAddress = Selection.Value Range(B12:C12).MergeCells = True Range(B13:C13).MergeCells = False Cells(13, 2).Select cAddress = cAddress vbCrLf Selection.Value Range(B13:C13).MergeCells = True Range(B14:C14).MergeCells = False Cells(14, 2).Select cCity = Selection.Value cAddress = cAddress cCity cCity = Left(cCity, (Len(cCity) - InStrRev(cCity, ))) Range(B14:C14).MergeCells = True Range(B15:C15).MergeCells = False Cells(15, 2).Select cState = Selection.Value cAddress = cAddress cState cState = Trim(Replace(cState, India, )) Range(B15:C15).MergeCells = True Sheets(Output).Select Cells(nRow, 2).Value = cAddress 'city Cells(nRow, 3).Value = cCity 'state Cells(nRow, 4).Value = cState 'contact person Sheets(Input Data).Select Range(D11:D15).MergeCells = False Cells(11, 4).Select cContact = Selection.Value cContact = Trim(Replace(cContact, Contact Person:, )) Range(D11:D15).MergeCells = True Sheets(Output).Select Cells(nRow, 10).Value = cContact 'business details Sheets(Input Data).Select Range(B8:D8).MergeCells = False Cells(8, 2).Select cBusiness = Selection.Value Range(B8:D8).MergeCells = True Sheets(Output).Select Cells(nRow, 11).Value = cBusiness End Sub '=== -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- Putta -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
Re: $$Excel-Macros$$ Outlook and excel integration
Can you please tell me how to work out this? I am bit confused. It would be great if you provide me the instruction. On Sat, Mar 27, 2010 at 1:29 PM, ~ Z A H E E R ~ zk9...@gmail.com wrote: Thank you very much Mahesh. This is what i want. On Wed, Mar 24, 2010 at 7:58 PM, Mahesh parab mahes...@gmail.com wrote: Dear Zaheer I herewith attach sample sheet as per your requirement, u can read further on below mention link, write back if u still find any difficulty http://www.rondebruin.nl/mail/change.htm On Mon, Mar 22, 2010 at 3:09 PM, ~ Z A H E E R ~ zk9...@gmail.comwrote: Dear Members, Is it possible to integrate MS Office 2007 and MS Excel 2007. For Eg. I have 1 excel file contains Employee ID, Employee Name, CID #, CID Expiry date, Passport #, Passport Expiry date, email My requirement : Whenever any employees CID or Passport is near to expiry date, outlook will send an email automatically to respective person notifying him to renew his CID or Passport or both. Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- Putta -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
Re: $$Excel-Macros$$ Code or Formula Required
Attached is the spread sheet. Please do the needful. On Fri, Mar 26, 2010 at 12:49 PM, Puttu puttu...@gmail.com wrote: Hi Group, I have sheet where I get a details of the company in different format, which the output need in one excel row. Example Jamrut Trading Co. Send Mail BusinessEstablished Sales Manufacturer1977250,000 to 1 million USD Deals In Export Of : Spices, grounded spices, processed foods, canned vegetables, dals, rice, pickles, chutneys, jam, papads, agarbattis Email: Send Mail Contact Person: Rajesh Jesrani 605, Cotton Exchange Building 175, Kalbadevi Rd Mumbai 41 Maharashtra India Output Should Be:- Company NameAddress CityState Phone Mobile Fax Email Website Contact Person Bussiness Details Jamrut Trading Co. 605, Cotton Exchange Building 175, Kalbadevi Rd Mumbai 41 Maharashtra India Mumbai Maharashtra Rajesh Jesrani Spices, grounded spices, processed foods, canned vegetables, dals, rice, pickles, chutneys, jam, papads, agarbattis Could you please advise how to do that. Thanks Puttu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- Putta -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. Code Required.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ hi all
How to use that, its not working for me? what is the use of that sheet? On Fri, Mar 19, 2010 at 11:54 AM, ashish koul koul.ash...@gmail.com wrote: just find it on goole see if it useful to u -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- Putta -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
Re: $$Excel-Macros$$ Urgent Badly help needed Excel formula
Thanks, Its working fine. On Thu, Mar 4, 2010 at 8:41 PM, ashish koul koul.ash...@gmail.com wrote: see the attachment r u looking for this but for that u need to create that temp col in sheet1 On Thu, Mar 4, 2010 at 8:14 PM, Puttu puttu...@gmail.com wrote: Hello Team, I need a formula or VB macro where as I have two different sheets with Same data, when it match the result should show in other sheet next column as YES If one value match then the answere should be YES in different xl. example XX #XX Name 100 NORTH FAFA 500 NORTHFA 700 SOUTHFA 900 WESTERNFA 910 CALIFORNIAFA 912 WESTFA 922 PLAINSFA 933 SOUTHXMS 944 GREAT In Different Sheet I have same above details, if it match then the result should show as YES 912 WESTFA If theis match then it should show as 912 WESTFA YES If would be great help if any one send formula or macro code for this. Thanks Putta -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Putta -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe