Tech Support Guy banner
Status
Not open for further replies.

Excel - Data from one workbook to another

397 views 2 replies 2 participants last post by  Damonc 
#1 ·
Hi,

I've got two excel workbooks that I need to merge.

The first book has the majority of the data and consists of multiple colomns and about 700 rows of data. For example lets say it has "Apple" in colomn G, row 241

The second book, has some data, some of which is the same, but not on the same row. for example, it may also have "Apple" in colomn G, but on row 248.

Is there a way to take data from colomn G, find the exact wording in Colomn G of the second workbook and paste/insert the entire row from the first workbook?
 
#2 ·
Yes ... (there's four parts to a Copy n Paste)
Select what you want to Copy > then Copy it .....
Then select where you want to start the Paste > then Paste it

Not sure what you're copying ... You may have to Right click and > "Paste Special"
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top