Get Master Worksheet to Separate Data into Various Worksheets

is this VBA of any interest to you?

Please Login or Register  to view this content.

EHT Library TEST.xlsm

Thank you very much for your help but all it did was create a single worksheet with all the information copied over again.

i have attached the workbook i am working with. so i need the information in the first tab "EHT Library" separated into the other worksheets based on the area in column a. it will also need to be updated automatically when i add or remove things from the first tab

thanks!

OK.
That code was actually modified from one designed for a somewhat different purpose.
It wasn't modified correctly to fit your situation in your attached file.

So, if you'd like to try again, copy your sheet "My EHT Library" to a new workbook (for testing) and run the following code from a code module.
Does it do anything like you want (apart from the automatic updating which may need to be looked at further)?

Please Login or Register  to view this content.

This works great but it creates new worksheets instead of putting them in the ones that are already there. i need the code to put the information in the already created tabs, not create new ones.

thanks!

That code names the new sheets after the various items (names?) in Column A.

I had little else to go on. You know your problem. I don't.

How to know which information should go into which already-named tab??