Solved tranfer data from xlsx to xlsx by picking a first row

January 10, 2016 at 23:17:23
Specs: Windows 8
Day by day i download the files in which some particular shows. Like transaction id, total price, contact number and many more upto 15.
For this i maintain a separate workbook where what particular i'd like to get i manage in first row.
Then starting copy and paste from previous book to this worksheet. But is bit hard due to large data in this particulars and get them manage without any error.

So i'd like to get the program or command that helps me to transfer data from original workbook of a specified column what i'd like to get and same paste on exact that name particular in different column in new workbook that i manage
If i can be of assistance please don't hesitate to ask

Highly appreciate your help in this concern


See More: tranfer data from xlsx to xlsx by picking a first row

Report •


✔ Best Answer
January 13, 2016 at 04:08:07
In the formula you posted, the cell reference is "locked" by the $. When you use the $ you are using "absolute references". I believe that you want to use "relative references".

http://www.gcflearnfree.org/excel20...

If you eliminate the $ then you can drag the formula up, down, left and right, and the cell reference will change, "relative" to the position of the formula.

Try this in B2 and drag it down:

=[saleshistory.xlsx]Sheet1!A2

As you drag it down it will change to:

=[saleshistory.xlsx]Sheet1!A3
=[saleshistory.xlsx]Sheet1!A4
etc.

I am not at a computer where I can access your workbook at this time. Perhaps later...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03



#1
January 11, 2016 at 05:04:23
I absolutely dont get what you are asking, maybe it is me, but your question doesnt make sense to me, can you please clarify.

Report •

#2
January 12, 2016 at 02:10:28
I have a file name Saleshistory.xlsx in which first row contains Item Id, Transaction id, value, Quantity etc.

And then i have separate file name Orderbook.xlsx in which i need only transaction id, value
The data saleshistory.xlsx file is much bigger and need focus while copying because a slight error can make my orderbook.xlsx file junk.

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
Hope you understand.


Report •

#3
January 12, 2016 at 05:59:33
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:

=[saleshistory.xlsx]Sheet1!$A$1

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.


Report •

Related Solutions

#4
January 12, 2016 at 22:04:08
hi dear,
It thinks it works =[saleshistory.xlsx]Sheet1!$A$1
In order id we have value from A2:A30
In transaction we have value from B2:B30

I want this one in my order book with the help of sales history. this above formula when i copied then only one value of A1 shows.
So definitely it will help, kindly let me know how to write the above range in your formula =[saleshistory.xlsx]Sheet1!$A$1

Highly appreciate your help
thanks


Report •

#5
January 12, 2016 at 22:16:54
http://www31.zippyshare.com/v/hgVQT...
http://www31.zippyshare.com/v/iW7OB...

Kindly see the above link of two excel file. one is blank and other have some data
just look forward to get a formula or way out through which data of one file of particular cell range move to blank file in same heading cell
Like if order id pickup from one then it must paste the data in blank file where order id particular shown
thanks


Report •

#6
January 13, 2016 at 04:08:07
✔ Best Answer
In the formula you posted, the cell reference is "locked" by the $. When you use the $ you are using "absolute references". I believe that you want to use "relative references".

http://www.gcflearnfree.org/excel20...

If you eliminate the $ then you can drag the formula up, down, left and right, and the cell reference will change, "relative" to the position of the formula.

Try this in B2 and drag it down:

=[saleshistory.xlsx]Sheet1!A2

As you drag it down it will change to:

=[saleshistory.xlsx]Sheet1!A3
=[saleshistory.xlsx]Sheet1!A4
etc.

I am not at a computer where I can access your workbook at this time. Perhaps later...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#7
January 13, 2016 at 18:01:48
Thank you for uploading the 2 files, but they don't really help.

If the formula I offered, or variations of it, don't work for you, you'll have to try and explain your needs again. Perhaps providing a file with the desired output data in it might help.

At least then we can actually see what you are trying to do.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question