Excel: Copy all the cells automatically to another sheet


I need help. I need to figure out how to pull data from one spreadsheet and get all of the information in the row only if it contains a specific 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


This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of November 26, 2016.


For more resources for Microsoft Excel