LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Comparing Excel Workbooks

I have 2 seperate workbooks, 3 sheets each. However only the first shee
is being utilized.

I want to compare the first sheet of both workbooks and fin
discrepancies... The number of records will change every time in bot
workbooks as the sheets are pulled of a programme, also the number o
records in both workbooks might be equal and then again it may not be.

The columns of both the workbooks are fixed every time the sheets ar
generated , For example. I will always be comparing Column C o
workbook1 with Column T of workbook2 , and so on... Can I record
macro which will help me... The sheets are not sorted by default whe
they are generated....

--
Message posted from http://www.ExcelForum.com

 
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
Comparing Two workbooks AJ Excel Worksheet Functions 3 March 30th 09 06:06 PM
Comparing two workbooks. Kevin Porter Excel Worksheet Functions 1 February 14th 07 06:34 AM
Comparing formula's of 2 excel workbooks Johannes Excel Discussion (Misc queries) 0 May 8th 06 04:49 PM
Comparing Workbooks JS Excel Discussion (Misc queries) 2 October 21st 05 01:20 PM
comparing workbooks glenn Excel Discussion (Misc queries) 1 August 2nd 05 01:13 PM


All times are GMT +1. The time now is 02:54 AM.

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"