Copy Rows based on 1 criteria showing in Multiple columns
Hi Guys,
I have attached a file with questions in it.
Found a lot of codes that lets you copy to new sheet based on criteria but having trouble finding one that sorts through 3 columns then copying specific columns based on the 1 criteria
Appreciate the help and inputs CopyPaste.xlsm
Are you wanting those values copied to the same columns of the first empty row of the new sheet?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
I would like it to have a header. Plus the "Pend" will be changed to Bank, Debt or Loan depending on what column it came from.
WithDesti.xlsm
Sorry forgot to include that bit earlier
It doesn't handle the formatting on the "Pending Acounts" sheet but try: WithDesti.xlsm
Note - I changed the way you handled the naming of the new sheet. You don't have to keep it but it prevents you from using On Error statements which IMHO is always nice.
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks