Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with the VB script | Excel Worksheet Functions | |||
I need some VB script please | Excel Discussion (Misc queries) | |||
VB script help - please!! | Excel Discussion (Misc queries) | |||
VBA script help..Please !!!! | Excel Discussion (Misc queries) | |||
VB script help..please !! | Excel Worksheet Functions |