First time on this website. I am trying to generate a excel program that only pulls specific information from one sheet to another if the criteria is met. I work in the Navy and have made an excel sheet for my command. I am trying to put certain people in specific divisions to their corresponding sheets(division). For example. Sheet1 is my entire command sheet. Sheet2 is 400 division. Sheet 3 is 500 and so on. However I only want to pull only specific info and not the entire row.
ex1.
Sheet1(All Personnel)
[TABLE="width: 500"]
[tr][td][/td][td]A
[/td][td]B
[/td][td]C
[/td][td]D
[/td][td]E
[/td][/tr][tr][td]1
[/td][td]LAST
[/td][td]FIRST
[/td][td]RANK
[/td][td]PROGRESS
[/td][td]DIVSION
[/td][/tr][tr][td]2
[/td][td]SMITH
[/td][td]JOHN
[/td][td]E5
[/td][td]COMPLETE
[/td][td]400
[/td][/tr][tr][td]3
[/td][td]DOE
[/td][td]JOHN
[/td][td]E9
[/td][td]IW
[/td][td]500
[/td][/tr][tr][td]4
[/td][td]SMITH
[/td][td]DOE
[/td][td]O1
[/td][td]ROUTING
[/td][td]600
[/td][/tr]
[/TABLE]
AND SO ON...
THIS INFO ABOVE IS THE ONLY INFO I WANT TO DISTRIBUTE TO THE CORRECT SHEETS(DIVISION). I do not want the whole row. Just the columns A - E. From Column F and on there are other info but not all the sheets contain the same info. Column E has a dropdown list for those division.
My other sheets are titled as followed.
Sheet2(400)
Sheet3(500)
Sheet4(600)
And so on.
Also, VBA is not widely used in my command and I do not believe it would work if the developer tab is not activated.
I appreciate your advice. Thank you.