Question Locked

excel best for this?

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i have a text file that i have been converting
to an excel file, i download a new text file
daily so that now i have 2 different workbooks that look like this:

Spreadsheet #1

YESTERDAY DATE 10/12/2007
Item No. Price Retail
123458 10.00 25.00
133682 26.79 45.00
133683 18.45 30.00
134510 22.50 31.00

Spreadsheet #2
TODAYS DATE 10/13/2007
Item No. Price Retail
123458 10.00 25.00
133683 22.00 35.00
134510 17.45 28.00
136222 29.00 44.00

Problems:1) i have 3 columns with 6000-8000 rows
2) i need to determine from each day to
the next which item numbers have
been DELETED;#133682 ADDED;#136222
and if any pricing changes occured;
#133683(increase),#134510(decrease)

is there a program that i can run to do this that puts the desired results in a managable
form?

i'm an excell newbie. should i be using excel at all?

i'm very open to any and all suggestions you might have.

3 replies

by thechas

Sounds like you are trying to track sales and inventory.

A standard spreadsheet is about the worst way to do this.

You can either set up a database using SQL or Access. Or, buy one of the many inventory tracking programs that are out there.

Even some of the business accounting packages have some inventory tracking abilities.

If your on a tight budget, you might search around www.sourceforge.net for an open source solution.

Chas

by thumbsup2

You can compare the text files themselves, side by side, in WinMerge (http://winmerge.org/). It will tell you which lines are different between the two files as you are looking at them. I'm not sure you can store the results afterwords though. I'm just learning to use the program myself.

This discussion is closed to new replies.