Moving data on excel

November 17, 2015 at 06:48:55
Specs: Windows 7

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?

See More: Moving data on excel

Report •

November 17, 2015 at 11:08:53
Adding custom code to a spreadsheet can be very tricky. To be honest, I would use Microsoft Access for something like this. It's a bit more involved than Excel is, but it has more options on manipulating data than Excel does.

I apologize this does not directly answer your question, but this is the route I would take.

Jonas "Jackal" Lear
Serving the South Bay Since 1999

Report •
Related Solutions

Ask Question