$$Excel-Macros$$ parsing multi line data
I have data entries that take up three lines here is an example: LIC # BUSINESS NAME ISSUED TYPE CLASSIFICATION BUSINESS ADDRESSOWNER NAME ADDRESSBUS PHONE # 10-5319 #1 DRAGON HOUSE 5/11/09 RNW RESTAURANT/ BAR 1799 KIOWA AVE 112 LEE, CHUNG BOU 928-505-8367 LAKE HAVASU CITY AZ 86403 448 SUNFIELD DR, LAKE HAVASU CITY AZ 86406 10 00020531 AMERICAN PACIFIC MORTGAGE 8/10/09 NEW SERVICE: MORTGAGE BANKER BRANCH #53 MYERS KEVIN JENSEN TWYLA928 854 2053 60 ACOMA BLVD S B100 60 ACOMA BLVD S B 100 LAKE HAVASU CITY AZ 86403 LAKE HAVASU CITY AZ 86403 10-7286 #1 NAILS EXPERT MORE 1/14/09 RNW SERVICE: NAIL SALON 34 LAKE HAVASU AVE N 8 VU, VIET HUNG PHAN, MICHELLE 928-854-6080 LAKE HAVASU CITY AZ 86403 34 LAKE HAVASU AVE STE 8, LAKE HAVASU CITY AZ 86403 10-00015642 #1 NAILS EXPERT MORE 2/05/09 RNW SERVICE: NAIL SALON 1460 BENTLEY BLVD NGUYEN, ANH 928-680-1899 LAKE HAVASU CITY AZ 86403 1451 BENTLEY BLVD, UNKNOWN AZ 10-00015643 #1 NAILS EXPERT MORE 2/05/09 RNW SERVICE: NAIL SALON 1850 MCCULLOCH BLVD N C3NGUYEN, ANH 928-680-1699 LAKE HAVASU CITY AZ 86403 1460 BENTLYE BLVD, LAKE HAVASU CITY AZ 86404 10-4380 #1 NAILS EXPERT MORE INC 1/05/09 RNW SERVICE: NAIL TECHNICIAN 2231 MCCULLOCH BLVD N 102 #1 NAILS EXPERT MORE INC 928-854-7100 LAKE HAVASU CITY AZ 86403 2231 MCCULLOCH BLVD N STE 102, LAKE HAVASU CITY AZ 86403 10-00020217 HANDS ON THERAPEUTIC MASSAGE 5/06/09 NEW SERVICE: MASSAGE THERAPY 645 MANZANITA DRBERGER, BONNIE LYNNE928-208-3858 LAKE HAVASU CITY AZ 86404 645 MANZANITA DR, LAKE HAVASU CITY AZ 86404 10 00013426 AMEC EARTH ENVIRONMENTAL INC 1/20/09 RNW SERVICE: ENGINEERING 10706 SIKES PL STE 250 AMEC EARTH ENVIRONMENTAL INC 928 854 8030 CHARLOTTE NC 2827710706 SIKES PL STE 250 CHARLOTTE NC 28277 I would like to be able to parse everything in each entry, I have been trying to do this for days but can't get any real good results. I don't know much about this programming stuff so I beg and plead with all of you to help me find a solution. The placement is exactly as it shows in the file so almost nothing lines up correctly. So I can't do text to columns. Ideally I would like each bit of info in it's own column: LIC #/BUSINESS NAME//ISSUED//TYPE//CLASSIFICATION//BUSINESS ADDRESS// OWNER ADDRESS...ETC Thanks for your time and please please please be kind enought to help me out! thanks! -BMWFLYBOY --~--~-~--~~~---~--~~ -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ vba password
hello excel experts i want a software to break excel vba password breaker urgent help required regards Shefali Singh --~--~-~--~~~---~--~~ -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Computation of Tax payment Tax Code Wise.
Dear Member, Monthly i take report of Sales for the previous months with respect to which Sales Tax is payable from our database. It gives in the format attached.Since, for filling of return, i require the sales tax payable tax rate wise, i have to mannualy insert a column and sort it first by CST then by rate and then do the manual add the Sales, Sales tax and Invoice. For example, i took the report for the month of 01.08.09 - 31.08.2009, (deleted the more than 100 recods as it would have file bulky) and then did accordingly to get the report as attached. Could you provide a macro to ease the manoeuvre. I am looking farward for your reply. Regards, Kumar --~--~-~--~~~---~--~~ -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- TAX PAYMENT.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: 2 FILTER IN SINGLE SHEET
Respected members of group, I want the 2 filter option in Raws not in Columns. Is it possible. Thanks On Thu, Sep 24, 2009 at 10:21 AM, big smile bigsmile...@gmail.com wrote: Hellow group members, Have a nice time with excel master. I have query that can it possible to have 2 filer option in single sheet.- if yes how can be done. with the helo of macro or without the help of macro. I have tried one filter -- then i have added another filer on another raw - then 1 st filter goes. J. C. Shah. Thanks in advance. --~--~-~--~~~---~--~~ -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Forgotten Password
Hi, I have downloaded the software but its asking me serial number. Please confirm what do I need to use Thanks Regards, Ramkrishna T. Padhi On Fri, Sep 25, 2009 at 10:44 AM, N.Shivkumar shiv1...@gmail.com wrote: Thanx it now working fine Bye N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com --~--~-~--~~~---~--~~ -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Splitting a text file
Hi Dilip, Can I have the password for that macro because I am not able to view the code. Thanks Regards, Ramkrishna T. Padhi On Fri, Sep 25, 2009 at 11:06 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Saurabh, One catch could be to check the file for spaces in the file name e.g.:- Reservation data.txt OR Reservation data.csv = incorrect as file name has space Reservationdata.txt OR Reservationdata.csv = correct file name, s it do not have spaces in the file name. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/25/09, Saurabh saurabh.pa...@in.aegisglobal.com wrote: Hi Dilip, Thanks for the solution, just facing a small difficulty in importing a file. Attached is the screenshot of the error. *Regards,* *Saurabh Patel* *+91982814* *“The earth is enjoyed by heroes”—this is the unfailing truth. Be a hero. Always say, “I have no fear.” - Swami Vivekanand*** -- *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *Dilip Pandey *Sent:* Sunday, September 20, 2009 10:58 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Splitting a text file Hi Saurabh, Solution is attached herewith. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/18/09, *Saurabh* saurabh.pa...@in.aegisglobal.com wrote: Hi All, I am importing a text file into excel where there is more data than 65536 rows. Can I have any macro, xla file or any addin to spilt the text file into different sheets. *Regards,* *Saurabh Patel* *+91982814* *“The earth is enjoyed by heroes”—this is the unfailing truth. Be a hero. Always say, “I have no fear.” - Swami Vivekanand* DISCLAIMER:The information contained in this electronic message and in any attachments to this message is confidential, legally privileged and intended only for the person or entity to which this electronic message is addressed. If you are not the intended recipient, please notify the system manager and you are hereby notified that any distribution, copying, review, retransmission, dissemination or other use of this electronic transmission or the information contained in it is strictly prohibited. Please accordingly also note that any views or opinions presented in this email are solely those of the author and may not represent those of the Company or bind the Company. This message has been scanned for viruses and dangerous content by Mail Scanner, and is believed to be clean. The Company accepts no liability for any damage caused by any virus transmitted by this email. DISCLAIMER:The information contained in this electronic message and in any attachments to this message is confidential, legally privileged and intended only for the person or entity to which this electronic message is addressed. If you are not the intended recipient, please notify the system manager and you are hereby notified that any distribution, copying, review, retransmission, dissemination or other use of this electronic transmission or the information contained in it is strictly prohibited. Please accordingly also note that any views or opinions presented in this email are solely those of the author and may not represent those of the Company or bind the Company. This message has been scanned for viruses and dangerous content by Mail Scanner, and is believed to be clean. The Company accepts no liability for any damage caused by any virus transmitted by this email. --~--~-~--~~~---~--~~ -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Loop to lookup variables and copy row to new sheet
Hi, I’ve seen a few queries that are similar to mine, but I can’t get any of them to work for me. I am very grateful for any assistance that you able to give. I have a spreadsheet like this: (Sheet name: Input) Col A: Sales person name Col B: Unit Col C to Z other data Col A Clo b Col C JohnDvd $543 Mary tv $123 Sam Cd $245 JohnCd $321 Sam Dvd $543 I need to copy all the rows with “DVD” in colcumn B from my “Input” sheet to a Sheet called “DVD”, all the rows with “CD” to a sheet called “CD” etc. I want to copy the entire row. This is a very simplified version of my actual data, I could have 20 to 50 different units so I would like it if the macro could take the search value from a list (this list could be in the “Input” sheet, in the range A8000: A8100) and then populate the prenamed sheets, or if it is easier to program it could create a sheet with the same name as the unit and copy the rows to that. If this isn’t possible then I would need code that would have the 50 units themselves written into the code instructing it to look for a specific unit, copy it to the relevant sheet, go back and look for another unit, until it looked for all 50. I hope I have explained this adquatly and thanks again. Regards, Tyson --~--~-~--~~~---~--~~ -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: How to save a DBF file in Excel 2007
Unfortunately Excel 2007 cannot save dbf files. You can open them but cannot save them after edit. Check out the add-in at http://thexlwiz.blogspot.com or you can also re-install Excel 2003 (the new 2007 and old versions can co-exist) and use it for dbf editing. Hope this helps. Gyula On Sep 24, 9:13 pm, Upendra Singh upendrasinghsen...@gmail.com wrote: Hi Sudhir, You can openDBFfiles directly in Excel 2007 or you can use save as dialog box to save a file as .dbf. Just use the filetype in the save as dialog box. Thanks and Regards, Upendra Singh +91-9910227325 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of SUDHIR AGRAWAL Sent: Thursday, September 24, 2009 3:47 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to save aDBFfile in Excel 2007 Please help --~--~-~--~~~---~--~~ -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Overriding excel Default charts
Once you click on the excel add a Bar chart from the standard, it inserts the chart with a excel formatting like color, background, border etc. The formatting is a excel standard chart, how can I override this to have formatting specific to my organization. Where are these templates saved in the machine how to edit it. or can I add a separate tab for my organization in the chart wizard? Thanks Ganesh --~--~-~--~~~---~--~~ -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: how to change decimal ccoordinates into DDMMSS fromat
*See attached file* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Sep 25, 2009 at 4:32 PM, Mahesh mahender.bi...@gmail.com wrote: Dear friends, Need your help. i want to convert decimal coordinates into DDMMSS. 9.73877= 09 44 20 -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- fdfd.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: how to change decimal coordinates into DDMMSS format
Hi Mahesh, Here's How to do Logic: 1.The whole units of degrees will remain the same (i.e. in 9.73877° Decimal, start with 9°). 2.Multiply the decimal by 60 (i.e. .73877 * 60 = 44.3262). 3.The whole number becomes the minutes (44'). 4.Take the remaining decimal and multiply by 60. (i.e. .3262 * 60 = 19.572). 5.The resulting number becomes the seconds (6). Seconds can remain as a decimal. 6.Take your three sets of numbers and put them together, using the symbols for degrees (°), minutes (‘), and seconds () (i.e. 9°44'19.572 Degree). Below are the formulas to achieve this in excel: Decimal Degree Minute Seconds 9.73877 =INT(A2) =INT((A2-INT(A2))*60) =(((A2-INT(A2))*60)-INT((A2-INT(A2))*60))*60 Thanks and Regards, Upendra Singh +91-9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Mahesh Sent: Friday, September 25, 2009 4:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ how to change decimal ccoordinates into DDMMSS fromat Dear friends, Need your help. i want to convert decimal coordinates into DDMMSS. 9.73877= 09 44 20 -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- 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 http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
