Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging data from two workbooks into one
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, -- A |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging data from two workbooks into one
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging or Consolidating Data from Multiple Workbooks | Excel Discussion (Misc queries) | |||
add vs. replace data when merging workbooks | Excel Worksheet Functions | |||
Merging Data from Workbooks | Excel Discussion (Misc queries) | |||
Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions | |||
Merging data from several workbooks | Excel Worksheet Functions |