Bookmark and Share

Enter your email address:

Delivered by FeedBurner

Home Page

Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

eXTReMe Tracker

  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

Cell References

[Edited entry from 3/13/206]

See all Topics


<Doug Klippert@ 3:12 AM

Comments: Post a Comment

Links to this post:

Create a Link