ash.ali
11-24-2006, 10:09 AM
:dunno Help needed. I am an excel user but don't know much about functions or VBA. I have a wkbk with 2 sheets and a further 2 sheets which are the templates.
I have a button for adding new rows and basically when you click a row from the first template is copied and pasted into the corresponding sheet then a row from the second template is copied and pasted into the second corresponding sheet. In the second sheet the functions are not looking at the correct fields in the first sheet, to retrieve relevant data from the first sheet. Any help would be appreciated. Sample file attached. Thanks
I have a button for adding new rows and basically when you click a row from the first template is copied and pasted into the corresponding sheet then a row from the second template is copied and pasted into the second corresponding sheet. In the second sheet the functions are not looking at the correct fields in the first sheet, to retrieve relevant data from the first sheet. Any help would be appreciated. Sample file attached. Thanks