• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel Question

Netraider

Alumni Member
Joined
May 31, 2006
Messages
719
Likes received
49
Thanks received
27
Location
Belfast
I have a worksheet with some calculated values. ie - Each line represent one record.

I would like another worksheet or even another spreadsheet to duplicate that worksheet , but filter the records based on one value in each record. I am trying to avoid using filters, as I don't trust the management not to tinker with the sheets.

Any ideas?
 
Excel Question

Pivot Table returning the values and protect and hide the source data?
 
Pivot table ^^ would do the job, else you could create a new Excel workbook and have a parameter driven external data link to the one with all the data in ?
Put a list of available parameter values into a cell. then data could be refreshed automtically when the cell changes, for example ?
 
Lotus Improv! That was a great tool - wonder if there is an AIX version....
 
I have a worksheet with some calculated values. ie - Each line represent one record.

I would like another worksheet or even another spreadsheet to duplicate that worksheet , but filter the records based on one value in each record. I am trying to avoid using filters, as I don't trust the management not to tinker with the sheets.

Any ideas?


Use MS-Access?
 

Advertisers

Back
Top