View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ZEXXX69@HOTMAIL.COM is offline
external usenet poster
 
Posts: 1
Default MESSAGE BOX IN EXCEL

Hello,

I have created a spreadsheet with totals on it, the total is a formula
in cell J25, what i am trying to do is each time the total goes over a
limit of £5k, i want a message box to appear and say somethinkg like
seek more approval, also is there a quick way to archive data from a
spreadsheet, so for example if i have popultaed a sheet with 200
records on it, and in column "D", if it has an "I" in it, i want to
create a new tab, and cut and paste all those records onto it but
without affecting my form, I woudl appreacite any help whatsoever
Kind Regards

Zed