P
peiwen
How do I extract data from 4 other worksheets to input into one other
worksheet?
e.g. I have Costs and Distance for 4 different Destinations on 4
worksheets respectively. When I type in a Destination (say, Singapore)
on a new sheet, I want the Cost and Distance to appear automatically.
Different destinations will have different costs and distances. The
destinations are in 4 different worksheets, grouped according to
continents, together with their respective Costs and Distances.
I need help in having the correct formulas that will cause the
automatic appearance of Cost and Distance when I type in a Destination.
Thanks!
worksheet?
e.g. I have Costs and Distance for 4 different Destinations on 4
worksheets respectively. When I type in a Destination (say, Singapore)
on a new sheet, I want the Cost and Distance to appear automatically.
Different destinations will have different costs and distances. The
destinations are in 4 different worksheets, grouped according to
continents, together with their respective Costs and Distances.
I need help in having the correct formulas that will cause the
automatic appearance of Cost and Distance when I type in a Destination.
Thanks!