farrukh
10-06-2011, 11:51 AM
HI All
I have two excel sheets one is adjustable other is fixed. I need that the adjustable sheet follow the sequence of fixed sheet and based on Fixed sheet column A. Give the result in result tab, if result tab is not created. It auto create the result sheet,in adjustable sheet copy the whole row based on the sequence Column A of fixed sheet.
* My first sheet is name adjustable second is fixed.
* i need that find string in adjustable sheet suppose "HI" then look in (fixed sheet) where the name "HI" exist if "HI" is place at column A row 12 then copy the entire row of adjustable sheet in new sheet which is result sheet at row 12?
I need to to with all strings in the adjustable sheet?
The sample file is attached with.
thanks
hammeed
I have two excel sheets one is adjustable other is fixed. I need that the adjustable sheet follow the sequence of fixed sheet and based on Fixed sheet column A. Give the result in result tab, if result tab is not created. It auto create the result sheet,in adjustable sheet copy the whole row based on the sequence Column A of fixed sheet.
* My first sheet is name adjustable second is fixed.
* i need that find string in adjustable sheet suppose "HI" then look in (fixed sheet) where the name "HI" exist if "HI" is place at column A row 12 then copy the entire row of adjustable sheet in new sheet which is result sheet at row 12?
I need to to with all strings in the adjustable sheet?
The sample file is attached with.
thanks
hammeed