Copy data between 2 excell spreadsheets

**omer123456** · 11-29-2011, 07:57 PM

Lets say there are 2 excell spreadsheets

1st excell spreadsheet has a buch of data
2nd excell spreadsheet is only data related to a certain event e. g (Only keeps data for STORE #1)

For example:

1st excell file has

Store # - # of people - sold - profit

Store 1 - 4 - 23- 09
Store 2 - 93- 23 - 759
Store 3 - 98 - 983 - 9
Store 1 - 09 - 992 - 2
Store 7 - 30 - 0 - 3921
Store 5 - 392 - 09- 95
Store 1 - 39 - 8 - 2871

So I want spreadsheet #2 to copy STORE#1 data from spreadsheet #1. (only copy column 1,3,4) Dont care for Column 2

POSSIBLE SOLUTION: IF "column A" from "spreadsheet 1" = "STORE #1".... then copy column 1,3,4 ( Dont care for column 2)

I hope I explained it well

**darkyam** · 11-29-2011, 08:16 PM

One way: in a helper column, beginning in row 2 (with row 1 having a 1 in it if it is for Store 1), =IF(A1="Store 1",Max($E$1:$E1)+1,""), dragged down.
In sheet 2, A1 can have =Index(Sheet1!A:A,Match(Rows(A$1:A1),Sheet1!$E:$E,0)). You can drag that over and down for the columns and rows you want and then either copy/paste as values or simply hide the helper column in the first sheet.