Updating a Spreadsheet

[AOmegan]

I have a Master spreadsheet that contains several columns that are updated using a source excel spreadsheet. My master spreadsheet has information that is not on the source spreadsheet. The source spreadsheet also adds new rows and I need to capture that information also. So how do I accomplish this without comparing each spreadsheet side by side and without missing added info or deleting extra info on my Master spreadsheet? Or is Access better for this? Or for that matter what is our purpose on this earth? Thanks for any help you can provide, I know the solution is there but I am not seeing it.

 

[GlennUK]

Is your source spreadsheet in the form of a list or table? If so, it may be that Access might be better for you. On the other hand you could use MS Query to fetch all the data into Excel regardless of the order, if it's in table form. Then use formulas or other Excel summary techniques to get what you want in the Master spreadsheet.