The attached Workbook contains a macro (SplitTags) that splits your tags into individual columns. If you have any problems lt me know. Tom.
On Sun, Jan 25, 2009 at 2:07 PM, agrinshtein <agrinsht...@gmail.com> wrote: > > Hey Tom and everyone else, > > http://is.gd/hbjF -- here is the link to the raw data. > > You will see that the tags for each item are in one cell. What I want > to do is split up the tags and put them into the next columns. It is > too tedious to split them up by themselves every time. > > Does anybody have any idea of what sort of macro I could make for > that? > > Thanks! > > On Jan 25, 3:45 pm, Tom Jeffries <tjeff...@gmail.com> wrote: > > It is not clear what you are trying to do. Can you provide a sample of > your > > raw data? > > Tom > > > > On Sun, Jan 25, 2009 at 3:18 AM, agrinshtein <agrinsht...@gmail.com> > wrote: > > > > > I am importing my financial data from the internet to excel as I would > > > like to view it in excel due to its powerful pivot tables. All of my > > > expenses come imported with their tags. However all of the tags > > > appear in only one column. I would like to make a macro which > > > separates the tags and puts them in different columns. The only > > > problem is that when I record the macro it limits it to the one cell > > > that I separated the tags on. I would like to write on one cell and > > > than the macro automatically works on the rest of them. Here is the > > > code, can anyone help me out? > > > > > Sub Tagging2() > > > ' > > > ' Tagging2 Macro > > > ' setting up tags to enable use for pivot tables > > > ' > > > > > ' > > > ActiveCell.FormulaR1C1 = "3DAILYLIVING Food " > > > Range("G21").Select > > > ActiveSheet.Paste > > > Range("E21").Select > > > ActiveCell.FormulaR1C1 = "3DAILYLIVING " > > > Range("F21").Select > > > ActiveSheet.Paste > > > Range("H20").Select > > > End Sub > > > > > Thanks, > > > Aron > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
SplitTags.xls
Description: MS-Excel spreadsheet
