Cross-sheet hyperlinking, data insert,lookup
Hi, I have a problem I am newbie for VBA.
I have a master sheet and a slave sheet.
I want to automatize this:
If I enter/edit something in MasterSheet.Range (CustomerNr) into cell
then excel make a lookup into Slave1Sheet.Range(OrderNr) and if not
exists then copy my entry to
SlaveSheetRange(OrderNr).CoulmnA.LastCell and made a hyperlink vica-
versa for that row/cell, if exists select the last OrderNr for that
CustomerNr. (In slave sheet aren't customer nr. so its some
backtracking for MasterSheet) I cannot change the xls structure.
Please help.
|