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