Processing
 

excel search and copy in/from another file

02/09/2016 12:00#1

deschus

Member

Joined at: 5 months ago

Post: 1

Thank: 0

Thanked: 0

how to search and copy content from another excel file in my current file with additional lines?

here what i need: belong to my example screen

i write manually in file-new.xlsx, example: C3 the value "1001"

1 . this should search in file-old.xlsx in all worksheets (T1, T2, ...) only B column for that input "1001" 2. if found, then transfer the entrys belonging to that finding, from A,C,D columns to file-new.xlsx columns B,D,E

i want only work in file-new.xlsx

excel search and copy in/from another file

thx for your suggestions

Similar articles

Excel More conditions in one formula?

5 months ago - Reply: 2 - Views: 172

Get Workbook reference from Open File dialog

5 months ago - Reply: 2 - Views: 130

Add Calculated Field To Pivot Table

6 months ago - Reply: 0 - Views: 7

Nested IF Functions in Excel not working

6 months ago - Reply: 3 - Views: 164

Formulating Date in Excel 2013

6 months ago - Reply: 2 - Views: 88

VB6 extracts in Excel 2013

6 months ago - Reply: 2 - Views: 153

Excel 2013 : Pull Matching Data from Column

6 months ago - Reply: 1 - Views: 23

excel search and copy in/from another file

6 months ago - Reply: 0 - Views: 1

Buggy PivotTable.ColumnRange

6 months ago - Reply: 0 - Views: 6

Excel static conditional formatting area

6 months ago - Reply: 0 - Views: 8

vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re