Duplicating a formula for other categories

salgunaidi

New member
Joined
Jun 18, 2013
Messages
7
Reaction score
0
Points
0
Hi all,


I'm currently creating a document (pdf) finder, I have attached the final version for you to see how it works.


The field named 'file path' has a formula which I would like to duplicate for another table that has a different set of dates. I will still be using the same format however there are different date ranges I will be using. This current excel worksheet is for 'A' Category, now I would like to generate another 4 that do not link to 'A' and that have their own value. So I would like to duplicate the formula to create 'B', 'C' and 'D' categories without them affecting 'A'. Is this possible?


A, B, C and D between them might have dates that are within the same ranges, however they all relate to different documents (pdf).


I hope you guys can help with this.
 

Attachments

  • policy booklet finder (TMPP).xlsx
    34.2 KB · Views: 11
Top