So my question is simple "How to extract and sort data from a workbook to another"?
I have a document ( let's name it "devices" ) sent over the network, as a result of an another document ( "devices used" ), which sorts some devices used by people in that day. it doesn't arrange the data.
What I wanna do is take that data from that document, and sort it as a table in another workbook.
I know I have to declare the workbook and the sheets, but how to extract and sort the data it's out of my power of knowledge ( yes, I'm new to vba ).