22 February 2012
My query is: I need to print the 2 vouchers on the same page from MS Excel. I will link it with the main register thru vlookup. Now i want that i should the give the base as range and the 2 vouchers on same page are printed like voucher 1 above and voucher 2 below. Like if give range from 1 to 40 then it is printed in 20 papers i.e 2 vouchers on each page. So pl guide is it possible, & How?
06 March 2012
not possible in excel as series of actions required. if u have the knowledge of the VB script then it can be programmed for the same using the interface between the two excel sheets.