ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i merge data from specific cells to different workbooks? (https://www.excelbanter.com/excel-worksheet-functions/111078-how-do-i-merge-data-specific-cells-different-workbooks.html)

Rich

how do i merge data from specific cells to different workbooks?
 
I have a workbook that I update every day on the call ins I recieve. At the
end of the week I have a total for all the calls that came in from different
sources. I want to know how to merge the prior weeks numbers into the next
weeks workbook so I have a Month-to-Date talley. Is there a way to pull info
from certain cells and combine it to another workbook to give me that result?

Ron de Bruin

how do i merge data from specific cells to different workbooks?
 
If I understand you correct

Look at EasyFilter
http://www.rondebruin.nl/easyfilter.htm

You can filter on Month-Year, Days, Weeknumber, Weekday, Nth Weekday, Quarter
and copy to another sheet or workbook

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Rich" wrote in message ...
I have a workbook that I update every day on the call ins I recieve. At the
end of the week I have a total for all the calls that came in from different
sources. I want to know how to merge the prior weeks numbers into the next
weeks workbook so I have a Month-to-Date talley. Is there a way to pull info
from certain cells and combine it to another workbook to give me that result?





All times are GMT +1. The time now is 08:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com