Hi everyone, i need help.
in the image, i want to copy the text service_cost to cell A2 of Chk_1 spreadsheet and 4003 Accident Repair to cell A13.
And in chk_2 i want to copy Material_cost and 4004 corrective mtce to new spreadsheet Chk_2.
how do i do that?
As the chk_ appears differently under different scenario as in chk_2 may be under Service_cost and not under material_cost, i don't know if it is possible to automatically copy the values for me to the new spreadsheet. i do not wish to manually copy the text to the new spreadsheet. is it possible?
there is always 36 rows in service_cost, there are 5 headers: service_cost, material_cost, labour_cost, ext_labour_cost and other_cost. all of those have 36 rows.
4003 accident repair, 4004 corrective mtce.... and some others below the screen shot all have 6 rows each.
the number of rows is always fixed. but the ->chk_ will change under different month if the value beside it is more than 0.
->chk_ will be located at values more than 0. and i want to do a cell reference to a new spreadsheet Chk_(number depend on the ->chk_).
But because at different month, the value greater than 0 may be in other position, i do not know how to cell reference the text to the new spreadsheet
in the image, i want to copy the text service_cost to cell A2 of Chk_1 spreadsheet and 4003 Accident Repair to cell A13.
And in chk_2 i want to copy Material_cost and 4004 corrective mtce to new spreadsheet Chk_2.
how do i do that?
As the chk_ appears differently under different scenario as in chk_2 may be under Service_cost and not under material_cost, i don't know if it is possible to automatically copy the values for me to the new spreadsheet. i do not wish to manually copy the text to the new spreadsheet. is it possible?
there is always 36 rows in service_cost, there are 5 headers: service_cost, material_cost, labour_cost, ext_labour_cost and other_cost. all of those have 36 rows.
4003 accident repair, 4004 corrective mtce.... and some others below the screen shot all have 6 rows each.
the number of rows is always fixed. but the ->chk_ will change under different month if the value beside it is more than 0.
->chk_ will be located at values more than 0. and i want to do a cell reference to a new spreadsheet Chk_(number depend on the ->chk_).
But because at different month, the value greater than 0 may be in other position, i do not know how to cell reference the text to the new spreadsheet
