Hey all-
I have been searching every Excel help site I can find to get a
solution to this. If anyone has any suggestions, it would be awesome.
I have 2 columns of data in a spreadsheet. They look something like
this:
source1
All Visits 1234
Paid 1000
Non-Paid 234
source2
All Visits 1100
Paid 1000
Non-Paid 100
source3
All Visits 500
Paid 250
Non-Paid 250
I want it to look like this:
All Visits Paid Non-Paid
source1 1234 1000 234
source2 1100 1000 100
source3 500 250 250
The thing is, there are 500 sources. So I figured macros would be the
best way to solve this. Any suggestions?
Thanks for your help,
Kristen
--~--~---------~--~----~------------~-------~--~----~
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
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
