I work from home doing tech support for a large chain.
Every call i take and solve i get a solution report that is posted on my profile (web site)
here is a picture of what i would normally see.
SS1.PNG
so i copy from the page the entire contents. It looks like this..
ss2.PNG
I then paste that into either Word or Excel like this (excel used since thats my goal here).
ss3.PNG
What i need to do is select the cells after pasting into excel the dollar amounts that are after the "you earn:" as seen in cells A13 and A14.
I would like to them add them to another sheet and tabulate these amounts so i can keep a running total of what i am earning.
I have tried find select with no luck since the fields that i need are duplicated. i just need to select the amount i earned (always the same as the amounts in (XX.XX) fields.
I hope this explains what i want to do enough.
Please advise if you need any more info and thanks SO MUCH for taking your time to answer these questions on this board!
Joshua B.
Bookmarks