Reverse Index???

[pipemaker]

I have a schedule set up in excel using dates (in a single Row), with multiple jobs on the sheet. I would like to have the sheet export dates to another sheet when an item is moved to another date. Problem is i have multiple values that are the same although they are for different jobs. The different jobs are set up using about 10 rows each with numbers across the rows corresponding to dates. When i place a number in the corresponding date column i would like it to reflect the change,(date change) on another sheet. Any help on this? Might need to go into more detail since it doesn't seem to be making sense to me.

 

[Chris Davison]

yeppers, maybe a few rows from the applicable columns would be useful

can you paste them up ?

 

[pipemaker]

Can't seem to get it to paste just right but have it as a spreadsheet. Just a small example and can email it.

Need it to search the "Job No" array finding a number, and returning the date corresponding to the column it is in. Trying to backflush a shipdate into other applications by changing it on this sheet. Night email is glockhart@sc.rr.com if you want me to send it.