I would like to set up a template for a monthly report that allows the user to drop in a financial report on the data tab (BC worksheet in attached sample) and have it populate the ops report on the first worksheet. The data report may have additional fields in some months so simple linking won't work. I have attached a sample file that has part of the ops report and the data (BC) report. Is this possible with the data report having headers and other data along with vacant rows. I just have a few of the line items on the ops report for testing. Any suggestions would be appreciated.
Thank you for your help.
Wanda
Thank you for your help.
Wanda