LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
MAK MAK is offline
external usenet poster
 
Posts: 20
Default Matching Information in 2 Tables

Scenario
I have 2 tables on the same worksheet. One is for Sales and the second is
for Cost. The common column in both tables is the Sales Invoice Number
column. The tables run into thousand of rows. Both the tables are sorted as
per Sales Invoice Number columns.

Task Information
Cost for certain Sales are missing.

Objective
To find Sales Invoice Details which have missing Cost information.

Current Process
Cut and Paste Cost Table information to match Sales Table based on Invoice
Number column. This process takes weeks to complete one worksheet.

Question
Is there any formula or optional process which can make this task easy.

Conclusion
Since it's a critical report for the management, still I cannot continue to
do in this manner. I might soon loose my eye sight. I am constantly having
headaches. If I don't get a solution, I might consider to resign rather than
continue doing in this manner. Help me guys. Will appreciate from the depth
of my heart.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching column information mePenny Excel Discussion (Misc queries) 7 April 14th 09 01:21 AM
Matching Information Unexcellent Excel Discussion (Misc queries) 6 March 7th 08 01:25 AM
Matching information in two columns Greenback Excel Discussion (Misc queries) 2 August 3rd 07 12:32 AM
Matching cell information Wato2 Excel Worksheet Functions 3 July 24th 06 03:10 PM
Matching cells that have unrelated information Troy S. Excel Discussion (Misc queries) 1 August 31st 05 04:00 AM


All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"