Hey Everyone!!
I need to build a macro for excel to make my life easier. I've never done it and I am having a hard time figuring out how to get started. Could you point me in the right direction?
I get lists of customers every month and I need to break them into 5 additional sheets, Customers with birthdays listed, Customers with birthdays and emails listed, customers with emails listed, customers with sales date listed and customers with no sales date listed.
Thank you!!
Last edited by KLH2007; 06-08-2016 at 09:09 AM.
Hi KLH2007,
If you could please provide a sample file of the format of your data and also the format that you want it broken into we can help you.
Also, I suggest that you update your title into something like "Splitting data into 5 sheets" (please see forum rule #1). This will be helpful for someone one who is google searching for a similar problem.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
Thank you so much Stephen! I have updated the title and I went to add my example but the attachment feature is not working for me. I am going to try tomorrow morning when i get to work.
If you select "Go Advanced" then scroll down to Manage Attachments you can upload from there rather than using the paperclip (I believe there is some issues with this).
Thank you!! That is what I needed. You are so helpful!
Try this:
Please Login or Register to view this content.
Thank you!!
I am getting an error "run time error '9' subscript out of range"
When I click Debug it highlights:
cell.EntireRow.Copy Destination:=Sheets(4).Range(C4 & ":" & C4)
What can I change to remove that error?
Hmm, I can't pick what the error is... here is the sheet that I used that isn't coming up with and error for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks