Hi, there is probably a very easy soultion to my problem but i cannot find it! Please help!
Basically I have a sheet that has loads of formulas in to gather external data, and i want to 'report' (for want of a better word) on various data for specific departments.
So, Sheet (A) contains the formulas, how can i get Sheets (B,C,D & E) to show the VALUE and not the actual formula??
I've looked at various Macros but was hoping for an easier answer, am i asking too much??
Please help, many thanks in advance.
Kirubiru
Basically I have a sheet that has loads of formulas in to gather external data, and i want to 'report' (for want of a better word) on various data for specific departments.
So, Sheet (A) contains the formulas, how can i get Sheets (B,C,D & E) to show the VALUE and not the actual formula??
I've looked at various Macros but was hoping for an easier answer, am i asking too much??
Please help, many thanks in advance.
Kirubiru
