Create another sheet with info from a "Job #" column

H

HoundofCullin

Good aftermorning to you all.

It seems the more I get done the more that is added to my list of
things to do (don't ya hate it when that happens?)

Here's what's on today's TODO list:


I am working on a TruckLog, had everything running perfectly then was
told that I need to add a column to let us know which Job the trucks
are runnin' to. Fine, that's easy. But the problem is that they want it
set up so that when a Job# is entered in the column, it creates a new
sheet (the sheet has to come from an outside source: i.e. another Excel
worksheet), then the sheet has to be titled the same as the Job# -AND-
every row with the same Job# gets logged into the same sheet. I need it
set up so that every different Job# has a different sheet.


Included is a picture of what the trucklog lookslike. Maybe it will
help bring into light what I'm gettin' at

Attachment filename: truckloggraphic.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=384271
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top