Moving a row from a main sheet based on a word in a column

[Greggatm]

I am trying to move a whole row from a main document to another sheet based on a word in the B row. So I can separate everything into different sheets for easier viewing for the property.

[reagan.kha]

I have a macro that will do just that. Please post your example excel file.

[Greggatm]

Capture.jpg
I am going to have a different sheet for every property. I want the row to copy over into the sheet as it shows in the main. How this snip helps. Or do you want my exact file?

[reagan.kha]

Here is a VBA to get you started. It only takes care of the Sheridan properties. Also the code right now is set so you main sheet must be names "Main" and another sheet names "Sheridan", but those can be changed. Without your excel file, I cannot test the code so, give it a whirl. You may need to tweak a few things, just a heads up.

Please Login or Register  to view this content.

[Greggatm]

How can I send you my doc. Would save me time to have you just punch it in.

[Greggatm]

Should be attached. Thanks for all the help! I have taken out the who and the memo. I will paste them back in

[reagan.kha]

Labor Checks Forum VBA.xlsm


Greggatm,

I started it for you. Do you have any experience with VBA codes? The Macro I wrote does the first two hotels for you. To do the other hotels you will need to copy the following code and change them for each property. Than paste them in the macro where I specified with a comment. Just have to change the hotel names. Also I suggest that you move the running amount count located to the right of you data to a new sheet, because that is being copied to the other sheets as well. To to run the macro, go to the developer tab and then run macro.

Please Login or Register  to view this content.

[Cutter]

@ reagan.kha

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

[Greggatm]

I have added othersand its working. But it seems to be stopping at line 218 every time though there are more lines way below?. i have copied everything to point. Is there someting I need to change to make sure it continues?

[reagan.kha]

I may be stopping at line 218 because the value in Column A is blank. The code is set up so that it will run through Column A to check if there is a name in that cell, if there is then it will copy, if it is blank then the code will stop. If this solves you problem please mark the thread as SOLVED. And add to my reputation points if you found my suggestions helpful! Thanks