Not even sure how to ask this one.. separate sheets for rows of data, based on a cell

Hey everyone.

I am kinda new, well back into the scene here. im having trouble refreshing my memory as it has been several years since playin in excel.

I have a workbook, that contains a list of all of our accounts.

in the workbook, I have sheets all named after states.

what I am trying to do is get a script, to put on a button, that does the following.

copy rows from sheet Stores-full, and paste in to the sheet that matches the state from col G
ie. on stores-full sheet, I have these headers. Billing State/Province is Column G


Account ID Account Name Account Phone Account Type Billing City Billing Country Billing State/Province Billing Street

if in Billing State/Province the value is CA, then copy the row to Sheet CA
if in Billing State/Province the value is AZ, then copy the row to sheet AZ


is there a way to do this easily?
All the sheets are created already.

Thanks again

Please Login or Register  to view this content.

this is what im at, however, stuck as it wont work. .....

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

Hi MR.MYSIS,

welcome to the forum!!

As long as the sheet tabs in Col. G exist in the workbook, the following will do the job:

Please Login or Register  to view this content.

Bear in mind that you can generally get away from doing this by simply filtering the data on the source tab (Stores-full in this case).

HTH

Robert