Macro to Copy Selected Range from one Worksheet to Another, based off of Criteria

Currently working on a workbook that has 1 Main Page of data entry that will copy information to other worksheets accordingly, based of criteria in column H. For Example, any scrap on Main Page Worksheet will be copied into the Scrap worksheet. However, I need all the same table headings on Row 1, on all pages.

Any help would be greatly appreciated. Thanks.

This deletes everything. It does not copy. Thanks though.

When I tried the macro on your file it looked like it worked for me. Try the attached file.

Oh. The code is working, however, is there a way to copy the contents, and not change the formatting in the other worksheets? For example I enter a new entry, run the macro, and it paste the new data in the according worksheet, but leave the existing information alone, that is already in there?

The different worksheets will have other formatting, so I don't want to mess up that in the other worksheets once the macro is ran.

This is great so far. I really appreciate your help.

See if this works for you.

Please Login or Register  to view this content.

Well I appreciate it. It still is erasing formatting on other worksheets. You have given me somewhere to start. Thanks again.

I don't understand why that is happening because in my last post the code is set to paste only the values. If you're willing to post a copy of your file. I'll be happy to have a look.

It may be operator error. Lol. Here is the worksheet with a little bit more information, and how I would like them formatted.

The problem was due to the fact that you are working with tables. I have made some changes and additions. Please try the attached file and let me know how it works out.

Oh that looks GREAT!!!Thank you so much MUMPS1. I will begin using and see if there are any bugs. I really appreciate your help. Awesome.

Ummm. Trying to say this was solved but the option is not available when I click Go Advance...

It was my pleasure.

To mark the thread "Solved":
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

Mumps1: Is there a way to keep it from putting duplicates in the spreadsheets when the macro is ran? For example, I input data, then run the macro, I only want to copy the most recent/new data, not everything? When this macro is ran, every time, it will put duplicates in the other worksheets.

Try:

Please Login or Register  to view this content.