I am new to Filemaker Pro. Could someone help me in creating one report with a common columnar format from multiple excel documents?
I have several excel documents that all have a common columnar layout, however some of them have subtotals, totals, blanks etc. in the rows. I would like to import each of these files, maintaining the column layout but eliminate all the sub total, total and blank rows and create one combined report. I have done some of the training, but have not seen how to do this exactly and don't have much time. Thanks to anyone for help.