If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Organizing worksheets in a workbook
I have a master worksheet with system downtime data. Example
System Date owner time down XXX 12/5 Jim 12:45 YYY 12/5 Jim 1:30 ZZZ 12/5 Frank 2:45 XXX 12/8 Jim 3:15 I then have worksheets for each of the Systems XXX, YYY, and ZZZ. I used an IF statement to pull the rows of data to the respective worksheets. The problem is the data for XXX shows on rows 1 and 4 of the XXX worksheet and I have 2 blank rows where the YYY and ZZZ data was. Is there anyway to get the 2nd XXX data on Row 2 on the XXX worksheet. My IF statement on the XXX worksheet in A2 is IF('sheet1'!A2:A2000 = "XXX", 'sheet1'!A2:A2000,"") Thanks Jpnga |
#2
|
|||
|
|||
Organizing worksheets in a workbook
The problems with using IF statements is that they may be rather cumbersome
and may become unreliable when the data in the master worksheet is moved or deleted (as I think you may have already found). Are you using the worksheets for each of the systems XXX etc as a means of analysing data in the master worksheet? If so, you could reduce the workload by using 'pivot tables' (if you want a printable table of abstracted data) or 'Advance filter' (if you want data in the form of a worksheet). Regards. Bill Ridgeway Computer Solutions "jpnga" wrote in message ... I have a master worksheet with system downtime data. Example System Date owner time down XXX 12/5 Jim 12:45 YYY 12/5 Jim 1:30 ZZZ 12/5 Frank 2:45 XXX 12/8 Jim 3:15 I then have worksheets for each of the Systems XXX, YYY, and ZZZ. I used an IF statement to pull the rows of data to the respective worksheets. The problem is the data for XXX shows on rows 1 and 4 of the XXX worksheet and I have 2 blank rows where the YYY and ZZZ data was. Is there anyway to get the 2nd XXX data on Row 2 on the XXX worksheet. My IF statement on the XXX worksheet in A2 is IF('sheet1'!A2:A2000 = "XXX", 'sheet1'!A2:A2000,"") Thanks Jpnga |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Protecting all worksheets of a workbook | neeraj | General Discussion | 14 | May 30th, 2006 09:46 PM |
Appending external worksheets into existing workbook? | Xuratoth | Links and Linking | 1 | September 27th, 2005 12:52 AM |
How do I build a workbook from the worksheets another workbook? | Rico | General Discussion | 4 | August 19th, 2005 02:04 PM |
Can I tile worksheets within a workbook, like one tiles workbooks. | Tovarish_Dad | General Discussion | 2 | July 6th, 2005 09:11 PM |
Hyperlink to individual worksheets in same workbook | kgriffith | General Discussion | 5 | June 22nd, 2004 06:35 PM |