Forum Discussion
JustRuckOver
Oct 06, 2023Copper Contributor
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 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
- SaniGarbaBrass ContributorYou 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.