Hi
Im relatively new to vba,
I need to move rows in manipulated spread sheet with a cell value in column F of advisory, managed advisory, ISA Inc.NOT Withdraw,ISA Inc. Withdraw into my exception spread sheet.
This is made more complicated as some ISA Inc.NOT Withdraw,ISA Inc. Withdraw need to stay in the manipulated spread sheet as in column G they have a strategy of "Discretionary Managed"
Then sort the manipulated spread sheet ascending by column F
How do I do this.
Copy of james work.xlsm
can you attach also desired result ?
If solved remember to mark Thread as solved
Copy of james work.xlsm
Hi Please find desired output on two extra tabs
Please Login or Register to view this content.
works a treat thanks very much.
What would I need to add to sort the manipulated sheet ascending by mandate.
the 2 last rows in sheet All have some merged cells, need to be copied ? Can we exclude them ?
with merged cells we can not sort.
add this code before End sub
Please Login or Register to view this content.
Last edited by patel45; 11-02-2013 at 04:02 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks