Hi All,
As I have brought up in the past, moving formulas to another sheet would be extremely powerful.
The sheets I have designed are used for different departments....Sales, Production, Accounts/Admin. By duplicating each (4) sheet, all irrelevant data in that department is hidden i.e. those rows are there but hidden (Giving the illusion the sheets are different when in fact they are the same when unhidden) This stops dumping and creating extra rows.
When a job goes from Sales (Goes through the sales process too sold) its then handed to production to do job ("Move To Another Sheet")
I NEED THE FORMULAS TO GO AS WELL.........in the attachment below there is options when save as new WHY CANT WE HAVE AN OPTION TO SEND THE (CODE) FORMULAS AS WELL ???
Thank you Smart Sheet.....
Dog with a bone ; )
