• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup, Index, Match or? Is there a way to do what I need?

wnorrick

Member
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
 

Attachments

  • Sample file.xlsx
    17.9 KB · Views: 3
Nebu, this is perfect. I really appreciate it. When I get help like this I take the opportunity to learn for the future so this is a great help.
Wanda
 
Back
Top