Forum Discussion
Designing an excel document to populate other documents
Hello, 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 st...
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.
