Move rows from one sheet to another if a word in column is selected

**rwood540** · 05-16-2012, 10:39 AM

I have an excel sheet inventory of my company's PC hardware. I have a main sheet (Hardware) with all machines listed and I have created other sheets by office names and would like the info from hardware sheet to automatically copy over to the appropriate office tab if that office location is selected in column J.
Does this make sense? I will attach a sample sheet.
I am just learning excel and have no clue on how to create formulas of this complexity. Have no clue on how to use macros? Any help is greatly appreciated.

**arlu1201** · 05-16-2012, 10:46 AM

Do you want the transfer to happen instantly or on the click of a button?

Once the transfer has happened, should the row remain in the Hardware sheet or should it be deleted?

Also, if you opt for button-click transfer, if the button is clicked again, should the contents be deleted and fresh data copied to the destination sheets?

**jeffreybrown** · 05-16-2012, 10:47 AM

How about...

Please Login or Register  to view this content.

You will have to setup all the other sheets and finish off the case statement

This is worksheet code >> right click on Hardward tab >> view code >> paste right side of screen