sindhuja
07-28-2009, 01:58 PM
Hello…
Workbook1 named Static wherein we have all the details (master sheet) and the other workbook named Dynamic wherein we copy paste the data daily (not same all the days)
Now what I want to do is I need to search all the values [column K of the Dynamic workbook (sheet1)] in column A of Static sheet and get the corresponding column B values in column L of Dynamic sheet. If more than one value in Static sheet then the corresponding value should be in the next column (column M of Dynamic sheet) and goes on…
Can anyone help me out in this pls..
-Sindhuja
Workbook1 named Static wherein we have all the details (master sheet) and the other workbook named Dynamic wherein we copy paste the data daily (not same all the days)
Now what I want to do is I need to search all the values [column K of the Dynamic workbook (sheet1)] in column A of Static sheet and get the corresponding column B values in column L of Dynamic sheet. If more than one value in Static sheet then the corresponding value should be in the next column (column M of Dynamic sheet) and goes on…
Can anyone help me out in this pls..
-Sindhuja