Dear excel experts,
I attach herewith a sample excel file which shows the total number of cases in a law firm coming in various courts. The attached excel file shows sample of various cases appearing in different courts with different worksheets. I am updating dates (Last date of hearing and next date of hearing manualy) when it has to be changed. For example, in any court, a case is coming on 23rd August, 2021 and after 23rd, 3rd October, 2021 is given, then So 23rd August will be gone to Last Date of hearing and 3rd October will become next date of hearing and so on for all the courts with various cases. My query is to prepare a cause list (sample provided in excel file). Say for example on 3rd October, different cases are coming, then all the cases should be listed on the cause list with formula or function. It may be possible that there are more than one case will come in all the courts or there may be no case in a particular court. Here, file number, name of court, case number name of party, opposite party remains same. I want to keep the column of court number and item no blank. it will be filled manually.
Is it possible to keep all the data in single worksheet (Main) with different Courts and stretch the data into cause list with formula. It would be better if anybody provide a solution to keep all the data in the Main file. By doing so updation of dates can be done in a single file.
Your help is requested.
VDS
I attach herewith a sample excel file which shows the total number of cases in a law firm coming in various courts. The attached excel file shows sample of various cases appearing in different courts with different worksheets. I am updating dates (Last date of hearing and next date of hearing manualy) when it has to be changed. For example, in any court, a case is coming on 23rd August, 2021 and after 23rd, 3rd October, 2021 is given, then So 23rd August will be gone to Last Date of hearing and 3rd October will become next date of hearing and so on for all the courts with various cases. My query is to prepare a cause list (sample provided in excel file). Say for example on 3rd October, different cases are coming, then all the cases should be listed on the cause list with formula or function. It may be possible that there are more than one case will come in all the courts or there may be no case in a particular court. Here, file number, name of court, case number name of party, opposite party remains same. I want to keep the column of court number and item no blank. it will be filled manually.
Is it possible to keep all the data in single worksheet (Main) with different Courts and stretch the data into cause list with formula. It would be better if anybody provide a solution to keep all the data in the Main file. By doing so updation of dates can be done in a single file.
Your help is requested.
VDS