-
Specified table rows copy from Sheet to another sheet
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.jpgScreen Shot 2016-03-15 at 09.38.11.jpg
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules