Hi guys,
Please help me building a macro to my spreadsheet.
In sheet 1, I do have a daily record of contributions of every name in column A.
What I am trying to do is transfer automatically the rows (matching the cells in column A and sheets) to their corresponding sheets.
I want to run the macro every time add new records, but there should be NO duplicates entries.
Contributions.xls
Please help. Thanks in advance.
Last edited by ermengard; 11-27-2014 at 08:15 PM.
Here you go.......
Press ALT+F8 and run the macro and check ....
Hi Naveen,
Your code is amazing. Is it possible also to make the column C of each new sheets to be sorted? Where should I insert the filter code in your macro.
This will make easier if I'm working with around a thousand worksheets.
Thanks.
Just put these 2 lines of code after Application.DisplayAlerts= True
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks