Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  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




See all Topics

Labels: ,


<Doug Klippert@ 3:14 AM

Comments: Post a Comment