ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Transferring data from one wksht to another (detail and summary) (https://www.excelbanter.com/excel-discussion-misc-queries/186892-transferring-data-one-wksht-another-detail-summary.html)

Elena

Transferring data from one wksht to another (detail and summary)
 
I have a total of 3 wksht: Staff, Detail and Summary
In staff wksht I have formula in cell 'N' that returns Past due accounts;
when past due returns I need the whole row to transfer to detail wksht and I
need #'s in cell F or K (there's #'s in either F or K, not both)to be added
and tranfer to Summary in cell F6

Please help.

Thanks
--
Elena


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

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