I need help. I need to figure out how to pull <vb_highlight>data</vb_highlight> from one spreadsheet and get all of the information in the row only if it contains a <vb_highlight>specific</vb_highlight> word in a different worksheet. How can I do this?
eg: first sheet named as entry and I enter A1 = month B1= name C1=Age D1=salary and I have there 12 month worksheet name as January, February, March, etc. I need the first page entry month column is January so I need all other cells that means B,C,D are copy to worksheet January if there is February so copy to Worksheet February
Please help me
eg: first sheet named as entry and I enter A1 = month B1= name C1=Age D1=salary and I have there 12 month worksheet name as January, February, March, etc. I need the first page entry month column is January so I need all other cells that means B,C,D are copy to worksheet January if there is February so copy to Worksheet February
Please help me