Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. paconovellino

    Data Sorting Macro

    thanks Andy!
  2. paconovellino

    Data Sorting Macro

    Hi, and thank you so much for your replys. I need the information to be displayed as SkipVought mention on his second replay.
  3. paconovellino

    Data Sorting Macro

    The result should look something like this Date: 09/08/13 1536 Avalos, Rodolfo Client Training 10:00 Date column B, Id column C, Agent Name Column D, activity Column E and Total time in activity Column F Thanks
  4. paconovellino

    Data Sorting Macro

    I want to extract the date, the agents ids (number next to name), the agent's name, the activity (client training)and the total (10:00) on different columns and repeat it until all data is formatted. Thanks :)
  5. paconovellino

    Data Sorting Macro

    So far I got this macro that I found on the internet, but I cant get it to get the date Sub JobsAndPercentsByName() '//Sub will strip out from a single column: '1) ID and Name '2) Job '3) Time '4) Percent of Time '//ASSUMPTIONS: 'Column A and only column A is populated 'Row 1 starts...
  6. paconovellino

    Data Sorting Macro

    I have a problem with a lot of text that can only be imported to excel into one column (A). The only problem is that it needs to be parsed and sorted by several different things. I have found it difficult to find any information on how to modify the information. This is how the text looks like...

Part and Inventory Search

Back
Top