L
lud1
Hi All,
On the sheet A I created the form is to be completed by a few people
Always after completing the form data are transfered to the sheet B i
the same workbook (database.xls). Then the A sheet is saved as a ne
workbook (new1, new2 etc) in the different directory.
What I like to have is connection between the new workbook (new1, new
etc) and sheet B. New1, new2 etc are current value (text) from F3 in
and column B in B sheet. Is it possible to create a macro or somethin
to enable following. When I click on ex. B2 (=new1) in B sheet it caus
automatically openning of the appropriate file (new1.xls). Afte
changing and saving new1.xls data would be also changed in B sheet i
database.xls
I have to say I am a beginner in macros environment and I do not kno
visual basic.
Any help appriciated
On the sheet A I created the form is to be completed by a few people
Always after completing the form data are transfered to the sheet B i
the same workbook (database.xls). Then the A sheet is saved as a ne
workbook (new1, new2 etc) in the different directory.
What I like to have is connection between the new workbook (new1, new
etc) and sheet B. New1, new2 etc are current value (text) from F3 in
and column B in B sheet. Is it possible to create a macro or somethin
to enable following. When I click on ex. B2 (=new1) in B sheet it caus
automatically openning of the appropriate file (new1.xls). Afte
changing and saving new1.xls data would be also changed in B sheet i
database.xls
I have to say I am a beginner in macros environment and I do not kno
visual basic.
Any help appriciated