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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cross-sheet hyperlinking, data insert,lookup
You need to write a worksheet_change function. Wroksheet_change get place
on worksheet page in VBA not in modules. to get to the corrrect page go to botttom of excel worksheet 9normally sheet 1) and right click and select view code. Place the code on this page. You can experiment with the sample code below which is from the VBA help menu. Private Sub Worksheet_Change(ByVal Target As Range) Target The changed range. Can be more than one cell. Remarks This event doesn't occur when cells change during a recalculation. Use the Calculate event to trap a sheet recalculation. Example This example changes the color of changed cells to blue. Private Sub Worksheet_Change(ByVal Target as Range) Target.Font.ColorIndex = 5 End Sub "csaba kobol" wrote: 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. |
Reply |
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 |