Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Holly Fox   on Dec 21 In MS Office Category.

reconcile data from samew workbook but in different sheet


  
Question Answered By: Kara Hicks   on Dec 21

ACCOUNT NO AMOUNT
37811266 500
37546031 200
37688111 300
37555693 400

sheet 1


ACCOUNT NO AMOUNT
37811266 500
37546031 200
37688111 100
37555693 500


sheet 2



the system will reconcile between sheet1 and sheet2
the output will be display on summary sheet(sheet 3)

and if the system found error(amount in sheet1 and sheet2 differ)
between sheet1 and sheet2 it will display on different color.








37811266 500
37546031 200
37688111 300
37555693 400
37688111 100
37555693 500



Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on reconcile data from samew workbook but in different sheet Or get search suggestion and latest updates.


Tagged: