Reverse Index???
Reverse Index???
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Reverse Index???

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Columbia, SC
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    can you paste them up ?

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Columbia, SC
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com