|Unfortunately, you still haven't provided enough detail for us to offer a solution.|
Here are some of things that are unclear, at least to me.
You said: "...i need only transaction id, value"
I don't know if you mean all transaction id values, just one, some, etc.
I also don't know where you want the value(s) placed in the orderbook.xlsx workbook.
Keep in mind that we can't see your workbooks from where we are sitting so we don't know anything about your layout or your process.
You said: So i want that is there any way either by cmd or access or excel where i just link two files each other and the value which i required in saleshistory.xlsx and paste in orderbook.xlsx file.
You mention 2 very different processes here - link and paste - and that is confusing.
When you say "link two files" I think of a simple formula in one workbook which refers to a cell in the other workbook. For example, if this formula was placed in a cell in orderbook.xlsx, the two files would be linked and the value from [saleshistory.xlsx]Sheet1!$A$1 would appear in the cell in orderbook.xlsx:
However, you also mention "paste" which to me means a copy and paste process, either done manually or by using VBA i.e. a macro. Do you see the reason for my confusion?
Perhaps if you provided a small sample of the data in your workbooks, showing us both the "input" and the desired output, we might be able to help. Please click on the blue line at the end of this post and read the instructions on how to post sample data in this forum.
Note: You can not attach a file to a post in this forum, but you can upload it to a share site such as zippyshare.com and then post the link back here.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.