Hi,,

I need your help guys..
I have created 2 Sheets one is to be filled manually and the second one is to be filled automatically as a result of what has been filled in Sheet-1


I have used some formula in Sheet-2 which works great to read from Sheet-1 , but it lists the Numbers or results as it appears in cells No. in Sheet-1 which leads to blank cells in between...

I have a attached 2 screen shot for the sheets

Sheet-1 (image 1) is the Master sheet
Sheet-2 (image 2) is the Result sheet where thinks is filled automatically (reads from Sheet-1)


in image 2 you can see the formula I used to read from Sheet-1



Thanks

Attached Images

	1.gif (84.0 KB, 49 views)
	2.gif (76.9 KB, 45 views)