| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlinking to a sheet in an excel workbook | Excel Discussion (Misc queries) | |||
| Cross-sheet formula and sort data | Excel Worksheet Functions | |||
| Hyperlinking from data in one sheet to matching data in another sheet | Excel Worksheet Functions | |||
| E - Mail when sheet updates - hyperlinking ! | Excel Programming | |||
| HYPERLINKING WITHIN A SINGLE SHEET | Excel Worksheet Functions | |||
Threaded Mode
