Excel Question

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
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!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

wobbegong replied

26 April 2013, 07:10
Originally posted by Netraider View Post

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?
Leave a comment:
SimonMac replied

23 April 2013, 09:35
Originally posted by Andy Hallett View Post

Agent in 'knowing something' shocker!

Nah, you probably have a techie you are abusing and taking all the credit for their work, typical bloody agents
Leave a comment:
Andy Hallett replied

22 April 2013, 18:37
Excel Question

Originally posted by MarillionFan View Post

WHS

Agent in 'knowing something' shocker!
Leave a comment:
stek replied

22 April 2013, 14:48
Lotus Improv! That was a great tool - wonder if there is an AIX version....
Leave a comment:
kevpuk replied

22 April 2013, 14:33
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 ?
Leave a comment:
MarillionFan replied

22 April 2013, 14:33
Originally posted by Andy Hallett View Post

Pivot Table returning the values and protect and hide the source data?

WHS
Leave a comment:
Andy Hallett replied

21 April 2013, 21:28
Excel Question

Pivot Table returning the values and protect and hide the source data?
Leave a comment:
Netraider started a topic Excel Question

21 April 2013, 20:35
Excel Question

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?
Tags: None