Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel 2003


  • Please log in to reply
1 reply to this topic

#1 amyl

amyl

  • Members
  • 77 posts
  • OFFLINE
  •  
  • Local time:05:04 AM

Posted 23 September 2009 - 11:48 AM

Hopefully this makes sense.

I am using If / And statements and conditional formatting to pull data from 1 Excel Spreadsheet (that includes multiple tabs) to another Spreadsheet {I am using as a Master spreadsheet to pull all data into}.


Example of current formula Spreadsheet 2 Cell A1 pulling info from Spreadsheet 2 cell H8:
=IF('[Spreadsheet2.xls]Tab,1'!$H$8="good voice tone",("True")) (if it doesn't equal this criteria then it defaults to false).
***Conditional Format is to highlight cells Red if "True" and no highlight if cells=false

Is there a way to pull from multiple tabs in a worksheet {Example: Tab 1, Tab 2, Tab 3, Tab 4} and use multiple cells within each tab {Example: H8, H9, H10, H11} within 1 formula (or can you use multiple formulas for 1 cell?)

Edited by amyl, 23 September 2009 - 11:49 AM.


BC AdBot (Login to Remove)

 


#2 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,574 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:05:04 AM

Posted 23 September 2009 - 06:58 PM

You might be able to pull it off, it you use ARRAY formula. See Help. You need to do Shift-Enter or Alt-Shift enter when you type in OR EVEN EDIT such as fomula, the result would be {=yourFormula} with those curly braces. And your formula should include the range such as H8:H10 from the other worksheet.
I'm not 100% sure I understand your question, so let's hope you can clarify a tad more :thumbsup:




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users