G'day,
Back again after last time you guys were so helpful.
Everything is the same for each corresponding item (RP Laid, SP Completed, RP Retrieved and RP Harvested) so for simplicity I will just talk about the SP Completed.
Overall Goal:
To calculate the total SP completed from the numbers manually entered into the bottom section and show this calculated number in the top R/H section depending on the line number used.
I am trying to keep everything on one line, hence my question if i can use a delimiter to separate information.
Example.
For SP Completed the following information would be entered:
day 1, line 1 had 100, line 2 had 200
day 2, line 1 had 100, line 2 had 200
day 3, line 3 had 500.
Now in the upper R/H section I would like this table to be filled in automatically by adding the numbers corresponding to that line number.
So in the upper R/H section, under line 1, for SP completed i would like it to show 200,
the same for line 2, showing 400, and 500 for line 3.
So i somehow need the cell AN5 to search for the information contained in cell AN2 (line number), within cell D14, then find the position in regards to the comma and add the numbers from cell E-H14 at the equivalent comma position.
I think this is maybe a bit complicated so i am also open to other ideas, but i would like it to stay on one line if possible.
Looking forward to what you guys come up with.
Thanks,
Jim.
Bookmarks