roqalexander
New Member
- Joined
- Jun 18, 2013
- Messages
- 8
Hello,
I am new to this so please excuse my ignroance... this is my first post...
I just have a question I want to create a macro that cuts data from a certain range in one sheet and then pastes that data into another sheet if one condition is met.
So I have attached this spreadsheet as an example..
in the first sheet= (Open administrative items) where it says "Partcipant Items" There is information that says
Peter Dunkin blah blah blah.. the range A24:G39
So the Macro does this: the first sheet- ONLY the range A24:G39 I want certain rows of data CUT ONLY if the status says COMPLETED and Pasted into the second sheet but when it is pasted it also inserts new row on the top (A2) so it doesnt disrupt the data below.
can this be done?
Thanks for the help in advance!!
I am new to this so please excuse my ignroance... this is my first post...
I just have a question I want to create a macro that cuts data from a certain range in one sheet and then pastes that data into another sheet if one condition is met.
So I have attached this spreadsheet as an example..
in the first sheet= (Open administrative items) where it says "Partcipant Items" There is information that says
Peter Dunkin blah blah blah.. the range A24:G39
So the Macro does this: the first sheet- ONLY the range A24:G39 I want certain rows of data CUT ONLY if the status says COMPLETED and Pasted into the second sheet but when it is pasted it also inserts new row on the top (A2) so it doesnt disrupt the data below.
can this be done?
Thanks for the help in advance!!