Results 1 to 10 of 10

making cells in tab2 = cells in tab1 in same workbook

Threaded View

  1. #1
    Registered User
    Join Date
    06-08-2011
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    23

    Exclamation making cells in tab2 = cells in tab1 in same workbook

    My workbook has 4 Tabs PCM Data, Analytical Data, QA-QC, & View Report. I am trying to get 2 cells in View Report = 2 cells in QA-QC. I am trying to get the date(B10) in tab View Report = Date in tab QA-QC(D9), I tried: ='QA-QC'!D9 That didn't work. I am also trying to have tab View Report cell Analyst(F10) = tab QA-QC cell =K9:M9 I tried ='QA-QC'!K9:M9 and I am get an error: #value! What do I need to do to make this work? Also If there is no date entered in tab QA-QC I want the date cell in tab View Report to be blank. the password for the attachment is 12345.Please feel free to look at the file.
    Last edited by jimb01; 06-09-2011 at 06:24 PM. Reason: forgot to add a part of the question

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1