Scan and copy cells from one spreadsheet to another.
 

How to take data from one spreadsheet and copy it to another. The porblem is
I have to scan columns on both for a match first. The only example I could
think of is something like this.

If A5(on first spreadsheet) = C68(on second spreadsheet) then copy H68(from
second spreadsheet) to E5(on first spreadsheet) else enter 0

There is over 1500 lines so I would hate to have to do this manually. Thanks!

Hi Mark

do you mean:
If the value occurs in column A on the first sheet and in column C on the
second sheet, then copy the value from column H of the same row as it
occured in in C (of the second sheet) to column E on the first sheet (same
row as where it was in A)

if so use the VLOOKUP formula in column E of the first sheet to do this for
you
e.g.
=VLOOKUP(A1,Sheet2!$C$1:$H$1500,6,0)
which says find the value in A1 in column C of sheet2, and return the
associated information from column H where there is an exact match
.... if there is no exact match then the formula will return #NA so use the
following to deal with this
=IF(ISNA(VLOOKUP(A1,Sheet2!$C$1:$H$1500,6,0)),0,VL OOKUP(A1,Sheet2!$C$1:$H$1500,6,0))
this formula can then be filled down column E of the first sheet

note, substitute Sheet2 with the name of the actual second sheet -
surrounding it with ' ' if it has a space in it

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Mark" wrote in message
...
How to take data from one spreadsheet and copy it to another. The porblem
is
I have to scan columns on both for a match first. The only example I could
think of is something like this.

If A5(on first spreadsheet) = C68(on second spreadsheet) then copy
H68(from
second spreadsheet) to E5(on first spreadsheet) else enter 0

There is over 1500 lines so I would hate to have to do this manually.
Thanks!