LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Lookup Information from Across Worksheets

I have a Workbook with monthly worksheets (tabs) (i.e. JAN, FEB, MAR..., DEC)

On another sheet, I will have a cell referencing which month I will generate
a report for.

Using that cell, without using nested if statements, can I have Excel
reference data in that spciific month's tab for my formulas in the report?

I may not be clear in the ablve, please let me know if I need to clarify.

Thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compute using information from two different worksheets ! Shefali Excel Worksheet Functions 1 September 24th 08 04:16 PM
Lookup information in Access Database John Excel Discussion (Misc queries) 3 April 27th 07 03:35 PM
information the same for cells on two different worksheets? INKcogKNEEdough Excel Discussion (Misc queries) 2 August 14th 06 05:07 AM
How do I move information between worksheets? Nocomputergeek Excel Worksheet Functions 2 October 10th 05 03:02 PM
lookup information in a row like a record utraceme Excel Worksheet Functions 1 April 18th 05 05:05 PM


All times are GMT +1. The time now is 09:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"