I am currently trying to create a excel spreadsheet using excel 2010.
I have created an summary page that holds a number of different sets of data, that i would like to separate out on to different sheets based on a session code.
At present I look after a number of different client groups and need to show what activity i have done with each.
what i am looking to achieve is, if a session code is EDB I want to copy the whole row and paste it into a new sheet. I would like to do this automatically or have an update button.
I am using column A as the session and I have the following codes EDB, EDBx, BESN, EC.
Can anyone help?