Dhanushr
New Member
Hello every one!
My name is Dhanush and this is my 1st post.
I’m working on a project and have come to a standstill! Please help me. I’m working on purchase and issue of materials for a construction company and this is what I want,
1. when I insert a particular value [e.g. 1] in particular cell [e.g. K7] in Sheet1, I want the entire data in that row [Sheet 1, row7] to automatically appear in a particular row in Sheet 2 and again when the same value is used again in another cell [same column different row] of sheet 1, that data should come in the next row of sheet 2. Now is this possible??
2. in sheet 1 I will be entering lots of materials as they come and when they are issued. That is the same item will be repeated a lot. So in sheet 3 I want all the items in sheet 1 to appear only once its totals in the next column is that possible? Please help
My name is Dhanush and this is my 1st post.
I’m working on a project and have come to a standstill! Please help me. I’m working on purchase and issue of materials for a construction company and this is what I want,
1. when I insert a particular value [e.g. 1] in particular cell [e.g. K7] in Sheet1, I want the entire data in that row [Sheet 1, row7] to automatically appear in a particular row in Sheet 2 and again when the same value is used again in another cell [same column different row] of sheet 1, that data should come in the next row of sheet 2. Now is this possible??
2. in sheet 1 I will be entering lots of materials as they come and when they are issued. That is the same item will be repeated a lot. So in sheet 3 I want all the items in sheet 1 to appear only once its totals in the next column is that possible? Please help