Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Name: Debsparrott Date: July 31, 2009 at 07:16:40 Pacific
Reply:
Specifically; I am comparing Price Sheets to either add new product, or delete discontinued product (that is not listed on new price sheet). Here is an example of the look of each spreadsheet (2 Separate spreadsheets side by side):
MODEL # DESCRIPTION COST LIST AD20435 Planter $254 $549
So, I have 2 separate spreadsheet with numerous model numbers/information on each line (can be anywhere from 10-25000 lines per spreadsheet), and I need to compare each spreadsheet to 1. Add new model info, 2. List for Delettion discontinued model info (which is not listed on new price list), 3. End result: both spreadsheets should have exactly same information for further work up.
I hope this explains the situation better. Thanks again. Deb
0
Response Number 2
Name: anmor Date: July 31, 2009 at 15:32:54 Pacific
Reply:
You will need to use the Vlookup function and possibly some Visual Basic programming if you want it all automated. It looks to me as if using a Database like Access would be a better option for this type of thing. I havn't done anything like this for many a year and the memory is not so good these days. Posting in the Office Software section may yield better results.
Summary: The thing about Vista is it performs qualitatively differently, and the old ways of judging performance very often don't apply anymore. With the aggressive caching behaviors of Vista in Superfetch, it...
Summary: I installed Vista RC1 on a separate partition to create a dual boot with XP Pro. Everything seemed to be fine until I tried the Live OneCare Beta for Vista. I assumed it would not affect the partiti...
Summary: My way of doing business: 1. Three separate hard drives if you can afford them, this is a stronge recomendation as opposed to partitioning a single hard drive. 2. I format a small C dive, 2 Giga byte,...
0 
