View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gor_yee Gor_yee is offline
external usenet poster
 
Posts: 38
Default Script for sorting

hi all,

I need some help...

I would like to have a script that can do some sorting for me

Col A - Region
Col B - Area
Col C - Store
Col D - Trading Department
Col E - Fine Department
Col F - Reference Number
Col G - Item Description
Col H - Base FC
Col I - Uplift
Col J - Demand
Col K - Display
Col L - Planning

First of all, I would like to create a button that will allow me to
sort the Col F and Col G in a ascending order, then on col L
(planning), it would show me if the store has done any planning,
basically it would be using the following forumala

=IF(I2=J2,"Unreviewed","Reviewed")

Also, can I fill the ones that say "Unreviewed" with a color (yellow)

sorry if i am asking too much...hope someone can help me...