Comparing lists

  • Thread starter Thread starter Ralph Burnette
  • Start date Start date
R

Ralph Burnette

I'm trying to make a fairly fluid spreadsheet. I have a weekly sales
report that comes out every week that I compare to the prior week to
see detailed sales information on about 2000 skus. I have skus that
come on and off of this report every week.

I want to be able to paste a column of data from the new report each
week next to a column from the prior week and:

a) tell me which skus have been added or subtracted
b) keep existing skus next to eachother automatically

Any help is greatly appreciated. Thanks!
 
I'm trying to make a fairly fluid spreadsheet.  I have a weekly sales
report that comes out every week that I compare to the prior week to
see detailed sales information on about 2000 skus.  I have skus that
come on and off of this report every week.

I want to be able to paste a column of data from the new report each
week next to a column from the prior week and:

a) tell me which skus have been added or subtracted
b) keep existing skus next to eachother automatically

Any help is greatly appreciated.  Thanks!
Click to expand...

Send your file with a complete explanation and before/after examples
to dguillett1 @gmail.com
 
Back
Top