|
|
#1
10-06-2011, 09:45 AM
|
|||
|
|||
Reporting Values Between Sheets/Tabs
Hi,
My formula "=IF('Sheet1'!R8="Y",'Sheet1'!A8)" reports back the value of A8 into 'Sheet2' cell A2, as intended, based on the variable in R8 (line 8 is 1st data/non-header row). However, there are merged cells from A8 all the way down to A78. The next value I want reported if true is A79. The problem is all the merged cells in-between report "FALSE." I cannot get rid of the merged cells/rows, and cannot figure out how to display/report only the true values. Any help would be greatly appreciated. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Reporting ManDays on people not fully assigned to the Project | Imagios | Project | 9 | 10-10-2011 04:36 AM |
| Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
| Resource Overallocation Reporting | Mutso | Project | 0 | 11-05-2010 12:27 PM |
| Outlook reporting from mail merge?? | jondoyle24 | Outlook | 0 | 10-18-2010 06:44 AM |
| Project Reporting | vickib1 | Project | 0 | 09-08-2010 03:11 AM |
Reporting Values Between Sheets/Tabs
Windows XP 
Office 2007
Threaded Mode