Moving data to another sheet based on criteria

Hello,

Please, I would require your assistance if you can help me figure out how I can do this.

I need to move data from one sheet to another based on the following criteria (See attached file)

CDN
To display all Canadian units.
Except fields define as "United States" & "*"


CDN TONNAGE
To display all Canadian Tonnage except “United States”.
Units including values define as “*” have to be included

USA
All USA units defined with “United States”

Empties
Display units without “Final Destination” and “Gross WT Tons”

Ontario
All units defined with “, ON” under final destination

Any help would be greatly appreciated.

Thanks,
Ant

Originally Posted by stanleydgromjr

jantonio,

In your workbook, sheet1, cell A2 = "Toronto, ON"

Should the next three cells A3, A4, and A5 = "Toronto, ON"? Is it implied?

I will have to automatically fill in the empty cells with some macro code.

No, A3, A4, and A5 are local units which are staying locally in Montreal and are not considered part of Toronto.

Thank you...

I came up with this which does the trick:

Please remove sheets (ONTARIO, EMPTIES, USA, CDN TONNAGE, CDN) from original "move data.xls" prior to running macro.

How can I put a timer on this for user to view that macro is running?

Please Login or Register  to view this content.