Create a macro wherein if the condition in one rage is met it willcopy to another sheet

Hi Good Day,

I need your help because I need the right code for macro in excel wherein if the condition that the posting acct# is equal to the value 8001001
the column posting acct#, amount, emp name and expense columns will be copied to another worksheet. Thanks for the help in advance.

Welcome to the forum Rhyne,

There is far too little information here. You should really should consider posting a copy of your workbook.


Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.

If this has been of assistance, please advise.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Hi

I attached the sample file.
I have to copy it to the other sheet in the same file.
Thanks for your help.

The attached workbook will copy the data you indicated onto Sheet2 whenever you enter 8001001 onto column "F"

ryne copy to another sheet.xlsm

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Hi David,

Thanks for the help.

Can you tell me how can i create the macro in excel? the current worksheet where the columns are being copied name as RAWDATA then the sheet where it will be pasted is DATA.
I tried to replace the data in the excel file you have sent but it does not show those columns with 8001001.

Thanks.

Sorry Ryne,

I was thinking that you wanted to move the data to another sheet if you changed the Posting Acct # to 8001001. Having looked back at your request, I don't know where I got that idea from!

ryne copy to another sheet V2.xlsm

Here is a new version with a button you can click that will move all the data that meets the condition. (The code that copies the data is still there so that if you change a cell in Col F to 8001001, the data will copy, but you will get a prompt).

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Hi David,

Thank you for this. This really helps.

You're welcome! Don't forget to click the Star (bottom left), and mark the thread as SOLVED

DAC