Office Tips and Hints Blog

Home Page

Host your Web site with PureHost!

Friday, May 08, 2009 – Permalink –

Data from the Other Sheet

Sometimes we must go next door

Here is a discussion about how to use data that may be on a different worksheet, or another workbook.

Getting data from other sheets can be very easy: or it can be very hard, it all depends on what you need to do. This article looks at some of the ways you can get data from other sheets.

The basics

Using the Indirect function

Back to the old school, XLM! (previous and next sheet)

VBA user defined functions (previous and next sheet)

Links

Methods In Excel

Also: BetterSolutions.com
Cell References

[Edited entry from 3/13/206]

See all Topics

Labels: Excel

<Doug Klippert@ 3:12 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link