Discussion Locked

Excel XP - Creating w/s for phone bills

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello All :-)
I have to create a worksheet for my company for the Phone Bills, that will show as to who (eg, Nancy, Steve, etc) has called which #'s and the amount of the calls made, Create an Excel worksheet where when my next bill comes I can paste the list in and press "Sort into who dialed the number" and each phone number and cost will be sorted so there's a total for Accounting.

4 replies

by dklippert

If your data comes in such that you can paste it into Excel, or import from a CSV type format, this is relativly easy.
If you sort by name you can use Data>subtotals
or Data>Auto filter

by dklippert

Send me a sample and I'll see what I can do.
What format is the bill in?
If you can get it in a consistant format, you could record a macro to clean it up.
Past the data in and then go to Tools>Macros Record macro and reformat the numbers. When you're done turn off the recorder and you can repaet the action when ever it's needed.

by nick1

DKlippert Date: 10/27/03
Thanks for your prompt reply,
yes that won't work, I am sorry I shouldn't have mentioned the PASTE part cause it doesn't work all the time (phone company's format problem) What I need to do is format a completly fresh worksheet.
Rgds
Nick.

by nick1

Hi Doug,
I did post the sample phone bill, but not sure if it was sent in the proper box, so if you can't see it I will post it again.
Thx
Nick.

This discussion is closed to new replies.