W
www.butterflysystems.co.uk
Hi
I want a userforn to search for and get data from multiple cells on the same
row of a closed worksheet. Then display the data on the userform, in a
number of labels/textboxes, for the user to review (and if requried, enter
on the active worksheet by the click of a command button). Now the entering
to the active worksheet I can do but its getting the data from the closed
workbook where I am struggling.
Can anyone give me some ideas on how to do this?
Upto now I have been using vlookup to find and enter the data in the active
worksheet and then we delete it if not needed. But with a vlookup in 18
columns this can be a pain. Below are some of the 'vlookups' I use, is there
an easy way to put this same functionality into a userform?
'=VLOOKUP(A15,'J:\rev_accs\[CSPost2003.xls]CBNW'!$1:$65536,2,FALSE)'
'=VLOOKUP(A15,'J:\rev_accs\[CSPost2003.xls]CBNW'!$1:$65536,12,FALSE)'
Kind Regards and thanks in advance for any help
I want a userforn to search for and get data from multiple cells on the same
row of a closed worksheet. Then display the data on the userform, in a
number of labels/textboxes, for the user to review (and if requried, enter
on the active worksheet by the click of a command button). Now the entering
to the active worksheet I can do but its getting the data from the closed
workbook where I am struggling.
Can anyone give me some ideas on how to do this?
Upto now I have been using vlookup to find and enter the data in the active
worksheet and then we delete it if not needed. But with a vlookup in 18
columns this can be a pain. Below are some of the 'vlookups' I use, is there
an easy way to put this same functionality into a userform?
'=VLOOKUP(A15,'J:\rev_accs\[CSPost2003.xls]CBNW'!$1:$65536,2,FALSE)'
'=VLOOKUP(A15,'J:\rev_accs\[CSPost2003.xls]CBNW'!$1:$65536,12,FALSE)'
Kind Regards and thanks in advance for any help