Hi,
I am using Excel 2002.
I work for a small shipping company. We have 6 boats. These boats send in reports on postions, with time and date. These positions are logged to a file.
I import this file into a spreadsheet, the format is a bit messed up but i have it cleaned. I need the order reveresed so I just sort it, no problem there. I have the import set to auto update.
What I need to do from that point is sort the data by most recent position update per boat, and send that update to that boats worksheet.
So it would go along the lines of. Boat A, Boat B, Boat C, Boat D , Boat E and Boat F as worksheets, using the actual boat names. Each one with it'se most recent position update displayed in the first row.
I've attempted to record macros to sort the data then paste it, but the macros seem to overlap and the data gets posted out of place (Boat A to Boat B.. etc.) Sort seems to get a little messed up at times as well. I've been using a page change event to trigger this.
Is there a simple way I can sort this information and paste it to the individual sheeets (automaticlly) avoiding this overlap I have? ray:
Once the filtering, sorting is done I compare the most recent update to the current time now(), and based on the IF= I display if the postion is late or on time. That much works fine.
This is really driving me nuts. ANy help is appreciated. Is there someplace I could even buy the macro, VBA or whatever I need to finnish this?
Thanks again.
M
I am using Excel 2002.
I work for a small shipping company. We have 6 boats. These boats send in reports on postions, with time and date. These positions are logged to a file.
I import this file into a spreadsheet, the format is a bit messed up but i have it cleaned. I need the order reveresed so I just sort it, no problem there. I have the import set to auto update.
What I need to do from that point is sort the data by most recent position update per boat, and send that update to that boats worksheet.
So it would go along the lines of. Boat A, Boat B, Boat C, Boat D , Boat E and Boat F as worksheets, using the actual boat names. Each one with it'se most recent position update displayed in the first row.
I've attempted to record macros to sort the data then paste it, but the macros seem to overlap and the data gets posted out of place (Boat A to Boat B.. etc.) Sort seems to get a little messed up at times as well. I've been using a page change event to trigger this.
Is there a simple way I can sort this information and paste it to the individual sheeets (automaticlly) avoiding this overlap I have? ray:
Once the filtering, sorting is done I compare the most recent update to the current time now(), and based on the IF= I display if the postion is late or on time. That much works fine.
This is really driving me nuts. ANy help is appreciated. Is there someplace I could even buy the macro, VBA or whatever I need to finnish this?
Thanks again.
M