SiChambo
09-09-2013, 03:59 AM
Hi All
I have a workbook with multiple sheets (below)
Data
Switchboard
Active Projects
and sheets numbered 1 thru to 10 (could be more)
What I am trying to do is summarise all the worksheets from 1 to 10 but only if a condition is met.
There is a drop down list in column A with multiple entries however when I select "Active Project", I want to Cut (not copy) and paste the entire row on to the Active projects worksheet next available line.
I would prefer this was a command button so the user can make changes to his information before moving the rows.
There are many similar answers but I cannot get them to work.
Many thanks in advance.
I have a workbook with multiple sheets (below)
Data
Switchboard
Active Projects
and sheets numbered 1 thru to 10 (could be more)
What I am trying to do is summarise all the worksheets from 1 to 10 but only if a condition is met.
There is a drop down list in column A with multiple entries however when I select "Active Project", I want to Cut (not copy) and paste the entire row on to the Active projects worksheet next available line.
I would prefer this was a command button so the user can make changes to his information before moving the rows.
There are many similar answers but I cannot get them to work.
Many thanks in advance.