hi friends,
i am attaching a sample book for your ref.
sheet 1 is the present set up. this is a letter that we generate to various depts.
sheet 2 is what i want. this saves spaces in order to get the letter on one page.
what i want is to fill up the empty spaces in column left by moving part of data from columns right.
the FRUITS (CONTD....) part in column left should come leaving one blank row up. here the blank row in the column left is row 8.
so from row 11 onward the splitting of data will start.
however this has to be automatically done. for instance if the column VEGETABLES got date till the 9th row then the header (FRUITS CONTD...) should appear in the 11th row keeping a space in between. this should happen automatically when ever data is entered.
many thanks and look forward to hear from you.
regards
rizvi
Bookmarks