+ Reply to Thread
Results 1 to 1 of 1

How to validate the two sheets Report

  1. #1
    Registered User
    Join Date
    05-10-2011
    Location
    india
    MS-Off Ver
    MS365
    Posts
    28

    Smile How to validate the two sheets Report

    Hello Forum users,

    I would like to match the sales report submitted by the Area Sales Manager and Agent.

    Comparison should start from Manager with the Agent report.

    I have three sheets 1. Agent, 2. Manager 3. Match for Diff and explains about the report on the sales made during the day
    Sheet 1. Agent – Report on Sales made on the day by the Agent

    Sheet 2. Manager – Report on Sales made on the day by the Sales manager

    Sheet 3. Match for Diff – This sheet should compare the other two sheets about the
    report given by these two different persons are accurate.

    I don’t want to go for the cell reference as each of the sheet will contain more line items and two reports will not be in the same order.
    I have attached the spread sheet for easy understanding and in the third sheet given the example output which I am expecting.

    Thanks in Advance
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1