| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to copy data
Dear All,
I have a list of employees and their mobile No. which provided them by company, We have to check daily basis the sms count. I need one summary for all the sim nos. I want that in all the sheets macro check the no. and enter in summary and in front mention the count of sms and if its found new no. then automatically enter in the summary report and mention sms count. Sheet is something like that Sim No. Count of SMS 5212455 15 5212456 16 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to copy data
Maybe a PivotTable will allow you to do what you need to do:
http://www.contextures.com/xlPivot02.html http://peltiertech.com/Excel/Pivots/pivottables.htm Regards, Ryan--- -- RyGuy "TFMR" wrote: Dear All, I have a list of employees and their mobile No. which provided them by company, We have to check daily basis the sms count. I need one summary for all the sim nos. I want that in all the sheets macro check the no. and enter in summary and in front mention the count of sms and if its found new no. then automatically enter in the summary report and mention sms count. Sheet is something like that Sim No. Count of SMS 5212455 15 5212456 16 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
| Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
| How do I copy data from main frame computer and keep data in cell | Excel Worksheet Functions | |||
| Copy old Data from web query while keeping previous days data | Excel Worksheet Functions | |||
| How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
Linear Mode
