I need a macro that will sort FileA by Policy Number (Column A), and send the last data row for each column after sorting step to File B. Therefore FileB would have one row per policy number. My files are attached for calrity. I hope someone out there can help me with this. Thanks in advance for your help.
You mean the last entry per policy number should be sent to File B?send the last data row for each column after sorting step to File B.
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]
yes! last entry per policy should be sent to fileB
Try this code. Paste it in a standard module (see steps after the code) in FileA.xlsm.Copy the Excel VBA code
Please Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button
I have sorted on column A. Let me know if any other fields need to be sorted.
Thanks, this works great but for one little thing. Both files will usually be closed at the point of process. The process will be initiated by button on a thrid workbook. Could you please modify the code to work even whether or not files A & B are opened or closed.
Arlu's code designed to be run from a third source:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Havent tried it yet, will try it right now
Hats off to both of you, thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks