accessing data from another document or tab

  • Thread starter Thread starter anjem
  • Start date Start date
A

anjem

Is there any way to run functions with a range from a seperate page o
tab in the same document
 
Hi
sure. e.g.
=SUM('othersheetname'!A1:A100)
Just enter the foormula name and select the range with your mouse (also
on a different worksheet)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing: page count exceeds pages in tab 1
Excel Moving data from one line to another 0
Mail Merge With Word, More than 1 Data Source 3
Multi tab setup 2
Printing Tabs on one page 1
List data 3
Sheet Macro Help Needed 4
Field and Worksheet Restrictions 2

Back
Top