• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Specified table rows copy from Sheet to another sheet

R

Robi

New Member
Hello,

First of all thank you for all the help on this topic.

I would need Macro to do the below.

Let say I have one database with few thousand lines of data.
On column A I have multiple rows with same text file in the cells.
And on the B,C,D,E and so on I have different data on each row.

I would like to have macro in case I select on Sheet2 the same text what is in column A then he copies only that rows what contains that text exactly. I will also add two photos how i would like to have it. I think it is easier to understand.

And above this I also would like to have option by button push, to create separate Excel sheets for each individual name tables and save it on specific folder.
So for the attached photos I would have A,B,C,D file saved on the hard drive with only containing the Sheet2 and rows belonging to each name.

Thank you for your Help.

Screen Shot 2016-03-15 at 09.38.04.png Screen Shot 2016-03-15 at 09.38.11.png
 
Thank you for your helix worked like charm. :)
Now i just only need to figure out how save this on new excel workbook automatically. Do you have idea? I think that can be don only with macro.
 
There are no macro's or named formula involved
Just take not of the references and the relativity of them all to each other
Then copy/paste them over and adjust

Then send the file back here and we can assist
 
You must log in or register to reply here.
Back
Top