Merging data from two workbooks into one

G

Guest

I have two different workbooks. One for usage and one for revenue. I want to
combine the two together. The only thing is that revenue will tally up the
total for ALL cell phones while usage will only calculate those that have had
activity. So if someone didn't use their phone, they would be missing in
usage, as it does not include zero's. Is there a way to get around this?

Thanks,
 
D

Dave O

Sounds like you'd need your billing department or billing provider (if
they're offsite) to change the way they report data, and include
phones with zero usage on the usage report. How are rows within the
spreadsheet differentiated? If I can suggest, and if you're making
changes, go by telephone number as opposed to account number or ESN or
IMEI. This will help if your company offers account bundling, family
features, multiple phones on a single account, etc.

Dave O
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top