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