Hello Everyone...
Here is my requirement.
I have a columns named 301,301-1,301-2,301-4,305,....... which is dynamic
I have a predefined criteria say if the cell value in column 301 is between 1.2 to 1.9 then all those should be picked and paste it in sheet 3. if there are more than one cell within the specified range, all the values should be copied one after and another in a separate row.
Similarly if the column names are -1,301-2,301-4,305 then the criteria range differs. For al these column if the cell value is greater than 2 then all those should be picked in sheet 3.
Apart from these all other fields in sheet3 should be filled according as per the corresponding row and column value.
Can this be done using macro as the data used is very sensitive.
Immediate response to this will be highly appreciated.
-Tharabai
Here is my requirement.
I have a columns named 301,301-1,301-2,301-4,305,....... which is dynamic
I have a predefined criteria say if the cell value in column 301 is between 1.2 to 1.9 then all those should be picked and paste it in sheet 3. if there are more than one cell within the specified range, all the values should be copied one after and another in a separate row.
Similarly if the column names are -1,301-2,301-4,305 then the criteria range differs. For al these column if the cell value is greater than 2 then all those should be picked in sheet 3.
Apart from these all other fields in sheet3 should be filled according as per the corresponding row and column value.
Can this be done using macro as the data used is very sensitive.
Immediate response to this will be highly appreciated.
-Tharabai