Hello friends,
I got this 1st sheet for data entry having 3 columns and i got the 2nd sheet as a result sheet. the 2nd sheet is based on the 1st sheet data. what I want to achieve is to fill up the 2nd sheet with data (based on the 1st sheet) without leaving any blank rows in between data rows. the 1st sheet can have blank rows but the 2nd sheet cannot have any blank rows in between the data entered. I have attached a sample document.
I would also like to perform this using only formulas instead of VBA unless ofcourse that a VBA is a must for this.
many thanks in advance
best wishes to all
Rizvi
Bookmarks