d_raghu9
03-22-2006, 07:44 PM
Hi there,
I am very much new to VBA as well as the forum.
I need some help in copy and past of VBA cells
My problem is
I need to select 3 cells of a row (which has 10 cells) copy them and paste them in new worksheet which is already created.
The cells of the row should be selected only if the value in "B" is equal to 'Good'
This checking should start from first row and end till the last row.
So In programming terms
start at first row
if(B1)=='Good'
copy A1, D1, G1 of the perticular row
go to another worksheet (Worksheet 2)
find the last unused row
Paste the copied vaues
Go back to the previous worksheet (Worksheet 1)
increment B1 to B2 (next row)
Repeat the same steps again.
This should happen till the end of row in worksheet 1
Sorry if i am sounding confusing.
Any help would be greately appreciated.
Thank you
Raghu
I am very much new to VBA as well as the forum.
I need some help in copy and past of VBA cells
My problem is
I need to select 3 cells of a row (which has 10 cells) copy them and paste them in new worksheet which is already created.
The cells of the row should be selected only if the value in "B" is equal to 'Good'
This checking should start from first row and end till the last row.
So In programming terms
start at first row
if(B1)=='Good'
copy A1, D1, G1 of the perticular row
go to another worksheet (Worksheet 2)
find the last unused row
Paste the copied vaues
Go back to the previous worksheet (Worksheet 1)
increment B1 to B2 (next row)
Repeat the same steps again.
This should happen till the end of row in worksheet 1
Sorry if i am sounding confusing.
Any help would be greately appreciated.
Thank you
Raghu