I am doing bank recon in excel
for every allocation i make between books and the bank statement i am marking a unique serial number for reference ..manually ..
can someone help me generate this automatically based on a click .. using vba code
Appreciate your immediate response

Hi Nick,

Could u pls. assist with the below queries

1. When this file is closed and opened
the form control shrinks & expands- becomes steady only after a couple of scroll

2. When a particular item (parent/child) is selected
the same should get linked to a particular cell in the ctrl sheet

Thanks
Deepak Ji Paulson