Move Row Data to another sheet in same workbook

Hi Everyone.

I need to create a workbook for tracking sales. Based on the content of the first row (an X) I need to move the entire row starting with Sales Person name to another sheet. The first three rows will indicate which sheet the data needs to move to and in some cases it may have to go to 2 sheets. I have attached the file I am starting with.

thanks for any help provided.

Maybe:

Please Login or Register  to view this content.

John.

I am not a VBA expert. Is there anyway you can insert in my excel sheet and provide that to me?

Thanks.

I don't have 2010, but I do know that you have to goto File>Options>Customize Ribbon>Right hand side>Main Tabs>Developers Tab>On the Developers Tab Choose VB Editor>select your project>From the VBE Menu>Insert Module>Copy and Paste the above code there. You will then be able to run it from the Macros listed in the Developers Tab.

Ok, I did that. Am getting subscript out of range.

Provide me it in office 2003. I have that on another computer will try it.

Tools>Macro>Visual Basic Editor>Lefthand side choose your Project and insert module. Normally, a subscript out of range indicates Excel can't find either a Sheet Object or Workbook Object. Check the sheet names in the code and see if they match the ones in your workbook.

Ok!. That seemed to work. Now for the last question. Can I get this macro to run as the data is entered or will I have to run the macro manually. I would prefer either hitting a button or as I finish a row it reviews and populates the other sheets.

Thoughts?

You can assign the macro to a Button in 2010 or in 2003 you also have the additional option of attaching it too a current menu.

Also, one more thing.

I need the macro to over write the sheets. As it sits right now it appends the data which gives me duplicate entries. Since I will be updating this weekly, I would prefer it over writes each time.

Possible?

Maybe:

Please Login or Register  to view this content.

Thanks John, it works as advertised. Working on the button thing, but the code is exactly as needed.

Sorry one more thing. The macro replaces my headers in the other sheets with blanks, how can I make my header stay on the other sheets?

Try:

Please Login or Register  to view this content.

John. Another question. How can I have each sheet have a different header that is static.
So first line is header and 2nd line would have the column headings and data would start on 3rd line.

Thanks for the help.