S
SDS_Feole
Hello,
I'm a beginner to Excel VBA so any suggestions would be very help.
Here's the scope. I have a worksheet that consists of 3 columns of data. 1
column has a formula (with a value) and the other 2 columns have values only.
In the rows, not all cells have data so I wish to omit those rows from the
copy process. I would like to copy the values from worksheet1 to worksheet 2
where all 3 rows have values omitting the rows that have null values.
Example:
Dept Account Amount
=====================
0000 10001 500
0000 30002 650
0000 30106 1139
40504
3454 51125
4050 46925 5000
In the example above, I would like to copy (from worksheet1 to worksheet2)
the first 3 lines and the last line that have values for Dept Account, and
Amount excluding line 4 and 5.
I hope I explained this clearly.
Thanks again for any suggestions
Tony
I'm a beginner to Excel VBA so any suggestions would be very help.
Here's the scope. I have a worksheet that consists of 3 columns of data. 1
column has a formula (with a value) and the other 2 columns have values only.
In the rows, not all cells have data so I wish to omit those rows from the
copy process. I would like to copy the values from worksheet1 to worksheet 2
where all 3 rows have values omitting the rows that have null values.
Example:
Dept Account Amount
=====================
0000 10001 500
0000 30002 650
0000 30106 1139
40504
3454 51125
4050 46925 5000
In the example above, I would like to copy (from worksheet1 to worksheet2)
the first 3 lines and the last line that have values for Dept Account, and
Amount excluding line 4 and 5.
I hope I explained this clearly.
Thanks again for any suggestions
Tony