LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Comparing and updating two spreadsheets

Hello everyone, one of my monthly tasks including updating this spreadsheet
by comparing my old spreadsheet with the new system generated spreadsheet.
The system spreadsheet has over 1400 groups. My spreadsheet only takes 200
groups out of those 1400 groups. All I concern is about the same 200 groups
every month. So I have to see if the 200 groups in the the system spreadsheet
has any changes, ad update the change for the groups on my spreadsheet. What
is the easy way to compare or filter out the 200 groups from the system
spreadhsheet and update any difference for my spreadsheet? The two
spreadsheets are the same.

What I did last month is manually take out each one the 200 groups from the
1400 groups to create a new updated report for the current month. This has
takenlot of my time and I hope there is an easier way to do this. Any
suggestion is appreciated!
 
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 different spreadsheets Hyun New Users to Excel 1 May 2nd 08 12:55 AM
Comparing Spreadsheets Richard Excel Discussion (Misc queries) 1 January 17th 07 05:56 PM
Comparing two spreadsheets. Excellerate New Users to Excel 2 November 16th 05 02:37 PM
Comparing data and updating spreadsheets mvhutton Excel Discussion (Misc queries) 3 July 11th 05 08:38 PM
comparing 2 spreadsheets Danny Excel Discussion (Misc queries) 3 July 11th 05 12:56 PM


All times are GMT +1. The time now is 11:20 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"