Instead of creating a second sheet, I'd add a Reason column to Sheet1,
and enter the data there. You can hide one or more columns, if you need
to print without all the data.
Also, I'd add the date to every row, so you can sort the data if
required. Use conditional formatting to hide the duplicate dates, as
shown here:
http://www.contextures.com/xlCondFor...html#Duplicate
You could also delete the blank lines between days, and use conditional
formatting to colour the line when a new date starts.
Those changes would make it possible for you to use an AutoFilter to
view specific items in the sheet, such as the Overview records. You
would also be able to create a Pivot table to summarize the data. There
are instructions and links on Jon Peltier site:
http://www.peltiertech.com/Excel/Pivots/pivotstart.htm
George wrote:
> I have been working with filters ever since you suggested it. I must be
> having some sort of brain block going on as I am still unable to get this to
> work.
>
> I have printed all the help info I can find about filters. There is nothing
> shown that is doing what I am trying to do.
>
> "Frank Kabel" wrote:
>
>
>>Hi
>>I would try using an adanced filter for this ('Data - Filter')
>>
>>--
>>Regards
>>Frank Kabel
>>Frankfurt, Germany
>>
>>"George" <(E-Mail Removed)> schrieb im Newsbeitrag
>>news:C75A0B04-0868-4A51-AE09-(E-Mail Removed)...
>>
>>>Hello.
>>>
>>>I cannot seem to get trough this one. I have a workbook with two
>>
>>sheets.
>>
>>>Information on sheet two comes from sheet one depending on what is in
>>
>>cell on
>>
>>>sheet one. Does this make any sense?
>>>
>>>Sheet 1
>>>
>>> A B C D E
>>
>>F
>>
>>> G
>>>1 Date Job Job# Start End Hours
>>
>>Total
>>
>>>2 20Sep Overhead 6-3 0730 0900 1.5
>>>3 XYZ Bank 5W67 0900 1600 7.0
>>
>>8.5
>>
>>>4
>>>5 21Sep ABC Cust 3456 0800 1300 5.0
>>>6 Overhead 6-3 1300 1700 4.0
>>>9.0
>>>7
>>>8 22Sep
>>>
>>>Sheet 2
>>>
>>> A B C D E
>>> F
>>>1 Date Job Start End Hours
>>
>>Reason
>>
>>>2
>>>3
>>>4
>>>5
>>>6
>>>
>>>Here's the deal - This sheet (Sheet 2) needs only "Overhead"
>>
>>information
>>
>>>from Sheet 1. Cells A2, B2, C2and D2 should be filled in as
>>
>>information is
>>
>>>entered in these same "fields" on Sheet 1. I seem unable to make
>>
>>this work.
>>
>>>As you can see from the "example" sheet 1, Overhead information can
>>
>>show up
>>
>>>anywhere on the sheet. Information is grouped together by date and
>>
>>separated
>>
>>>by a blank row.
>>>
>>>If it will help, I have a blank workbook that I could send.
>>>
>>>Thank you in advance for the help.
>>
>>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Similar Threads
