Automatic Data Insertion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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/xlCondFormat03.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
 
Back
Top