Move rows to separate sheets

[astro_kt]

Hi All,

I would like to use Sheet 1 to put in all PO's as I make them. Then I would like to have other named sheets (account codes) that will separate out all the information. Each sheet would be named with a different account code. I have gotten it to work using an IF Statement, but then it puts them in the same row as what they are on Sheet 1. I would like each of the account code sheets to start on the 2nd row. I realize I could just sort them each time, but I would like it to be automatic. How can I get this to work. Any help would be greatly appreciated.

[jeffreybrown]

Hi astro_k,

You could most definitely do this with formulas, but probably not the best choice.

See this example with formulas; however, have you considered other choices.

VBA, pivot Table, filtering, advanced filter. No matter what you choose, it will take some further investigation on your part. Is there a particular reason you are separating out the sheets? If not, then look into a Pivot Table where you can quickly generate a separate sheet one at a time. Again, when you have a master sheet already, why not just apply a filter to look at the account number of your choice.

Anyway, in the example is a way to do it with formulas.

[astro_kt]

Hi Jeff,

Thank you for the help. Unfortunately I don't know anything about VBA or filters. I have only used a pivot table one time. I need the accounts separated out so I know how much is spent for each account. Right now I have to put numbers on 2-3 different sheets each time, so I am trying to make the process easier. It looks like I have a lot more to learn.

[jeffreybrown]

Hi astro_k,

Yes, indeed a lot to learn, but step-by-step you'll get it. Based on what you just described, check out the Pivot Table.

Change the Acct Code in B2. Sometimes the easiest solution are the ones most people seem to shy away from.

[astro_kt]

Thank you. I will definitely start playing around with this.

[jeffreybrown]

You are very welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.