Designing an excel document to populate other documents

Copper Contributor



I'm not really good with explaining but will try my best. 

I'm trying to use one document to  populate 6 other documents, which will populate the different sheets in the 6. I haven't started building them yet, but would want it to fill the row underneath the previous.

Eventually would like to compare the data from the sheets as well but for now I would just like to develop something that works.


Any help is appreciated




1 Reply
You can achieve your requirements by using the Filter function. On the each of the Sheet, Filter(A1:D100, “column of the documents name” = “name of doc1”). Repeat for each document, whether in the same or different workbooks. Hope this helps, or at least points you in the right direction.