Reverse Index???

pipemaker · Apr 14th, 2002, 09:02 PM

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 · Apr 15th, 2002, 11:53 AM

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

can you paste them up ?

pipemaker · Apr 15th, 2002, 06:29 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 14th, 2002, 09:02 PM	#1
pipemaker New Member Join Date: Apr 2002 Location: Columbia, SC Posts: 23	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.

Apr 15th, 2002, 11:53 AM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	yeppers, maybe a few rows from the applicable columns would be useful can you paste them up ?

Apr 15th, 2002, 06:29 PM	#3
pipemaker New Member Join Date: Apr 2002 Location: Columbia, SC Posts: 23	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.