if cell = true copy entire row to a dif tab

**alfonse83** · 05-05-2009, 09:57 AM

Hi,
I am trying to do something very similar to this post. If you look at the attached spreadsheet you will see 6 tabs. Main, New Cust, Quote, etc.

"Main" will be the sheet that everything is inputted. If there is a "Y" under new customer, I want the entire row to copy to the tab "New Cust". If there is an "X" under quote, struct design, or graphic design I want it under its approp. tab. The Lisa tab should take certain Sales-Person and copy entire row on the Lisa tab. The certain Sales-Persons are BS, PK, PB, PD.

Any help will be greatly appreciated.

Buttons are fine. The "main" page will be getting updated daily w/ new info so after entering new data, i can press the button and it should copy the above to its locations.

Thanks again

**StephenR** · 05-05-2009, 01:01 PM

So one row can be copied to multiple sheets?

**alfonse83** · 05-05-2009, 01:20 PM

1 row will be copied to its desired location.

Main" will be the sheet that everything is inputted. If there is a "Y" under new customer, I want the entire row to copy to the tab "New Cust". If there is an "X" under quote, struct design, or graphic design I want it under its approp. tab.

If there is multiple checks on the same row for either quote, struct design and graphic design, then the same row will be copied to the 3 tabs. The Lisa tab should take certain Sales-Person and copy entire row on the Lisa tab. The certain Sales-Persons are BS, PK, PB, PD.

**StephenR** · 05-06-2009, 06:34 AM

There really wasn't any need to repeat your question. My problem is not with reading or comprehension skills.

What if they're a new customer and there's an X in quote?

**alfonse83** · 05-06-2009, 08:13 AM

i apoligize for repeating, i am new to forums, and since my last thread was closed i wasnt sure what to do. sorry.

but if there is a new customer and an x under quote, then the same row will be copied to new cust and quote.

**StephenR** · 05-07-2009, 06:55 AM

Try this:

Please Login or Register  to view this content.

**alfonse83** · 05-07-2009, 07:45 AM

It is perfect. Thank you very much. I am currently reading up on VB so maybe sometime soon I can also help out some people on here. Thanks again.

edit:
It just came to my attention that everytime we input more data on the "Main" tab and run the macro, everything that was already inputted will repeat in the other tabs. Is it possible to only have the new data copy over so everything will be copied 1 time w/o repeats.
Thanks again

edit2:
i found the code through a search. Thanks again

**StephenR** · 05-07-2009, 09:26 AM

This should delete the contents of each worksheet, except Main, before copying.

Please Login or Register  to view this content.

**jmrowe504** · 05-11-2010, 07:51 PM

With out getting to complicated, here is what I am attempting I am trying to develop a workbook that has all sorts of data in it. The situation is this, I have 4 sheets that are within this workbook that I need a macro (I think); The main sheet is "Group Alpha Roster" inside this sheet there is a varible that could reflect H, 1, 2, or 3 and I would like it to copy all H and their respected row to the worksheet titled HHD Alpha Roster for H all 1's to EB 1 Alpha Roster and so on. I am having trouble. P.S. H, 1, 2, or 3 is found in Column C.