Lookup data in other workbook
 

hi.

i want to know if it possible get values to a sheet from another workbook
sheet.
How i can do this.
Thanks!

Lookup data in other workbook
 

Yes it is. You either link directly

=[Timesheet.xls]Summary!$A$2

or evne use VLOOKUP

=VLOOKUP(A1,[Timesheet.xls]Data!$A$2:$C$5,2,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pasmatos" wrote in message
...
hi.

i want to know if it possible get values to a sheet from another workbook
sheet.
How i can do this.
Thanks!

Lookup data in other workbook
 

Thanks, Bob.
Best Regards.

"Bob Phillips" wrote:

Yes it is. You either link directly

=[Timesheet.xls]Summary!$A$2

or evne use VLOOKUP

=VLOOKUP(A1,[Timesheet.xls]Data!$A$2:$C$5,2,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pasmatos" wrote in message
...
hi.

i want to know if it possible get values to a sheet from another workbook
sheet.
How i can do this.
Thanks!

Lookup data in other workbook
 

Sorry, I think that its over but all the time i edit the formula she excel
ask the path for the excel file that i want to vlookup

Thanks!



"Bob Phillips" wrote:

Yes it is. You either link directly

=[Timesheet.xls]Summary!$A$2

or evne use VLOOKUP

=VLOOKUP(A1,[Timesheet.xls]Data!$A$2:$C$5,2,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pasmatos" wrote in message
...
hi.

i want to know if it possible get values to a sheet from another workbook
sheet.
How i can do this.
Thanks!

Lookup data in other workbook
 

I am not sure what you mean. Can you clarify?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pasmatos" wrote in message
...
Sorry, I think that its over but all the time i edit the formula she excel
ask the path for the excel file that i want to vlookup

Thanks!



"Bob Phillips" wrote:

Yes it is. You either link directly

=[Timesheet.xls]Summary!$A$2

or evne use VLOOKUP

=VLOOKUP(A1,[Timesheet.xls]Data!$A$2:$C$5,2,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pasmatos" wrote in message
...
hi.

i want to know if it possible get values to a sheet from another
workbook
sheet.
How i can do this.
Thanks!

Lookup data in other workbook
 

Thanks for your help. But your post resolve my problem.

Regards.
Paulo

"Bob Phillips" wrote:

I am not sure what you mean. Can you clarify?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pasmatos" wrote in message
...
Sorry, I think that its over but all the time i edit the formula she excel
ask the path for the excel file that i want to vlookup

Thanks!



"Bob Phillips" wrote:

Yes it is. You either link directly

=[Timesheet.xls]Summary!$A$2

or evne use VLOOKUP

=VLOOKUP(A1,[Timesheet.xls]Data!$A$2:$C$5,2,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pasmatos" wrote in message
...
hi.

i want to know if it possible get values to a sheet from another
workbook
sheet.
How i can do this.
Thanks!