PC Review


Reply
Thread Tools Rate Thread

Comparing lists

 
 
Ralph Burnette
Guest
Posts: n/a
 
      21st Nov 2011
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!
 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      21st Nov 2011
On Nov 21, 11:31*am, Ralph Burnette <ralph.burne...@gmail.com> wrote:
> 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!


Send your file with a complete explanation and before/after examples
to dguillett1 @gmail.com
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:13 AM.