Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
fomula comes to next row on click
If anyone help me to write VBA scrip for following
I've dropdown list in A3, and other calculation formulas in C3,D3,E3,F3 all are ready calculating, as I click on A4 I want above same formula automaticaly copy work on C4,D4,E4,F4. continues like this in every rows as I click to fill up. Thank you very much in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
fomula comes to next row on click
Right click sheet tabview codecopy/paste this. A DOUBLE click will do as
desired. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column < 1 Then Exit Sub Tr = Target.Row Range(Cells(Tr - 1, 3), Cells(Tr - 1, 6)).Copy Cells(Tr, 3) End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ... If anyone help me to write VBA scrip for following I've dropdown list in A3, and other calculation formulas in C3,D3,E3,F3 all are ready calculating, as I click on A4 I want above same formula automaticaly copy work on C4,D4,E4,F4. continues like this in every rows as I click to fill up. Thank you very much in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If fomula | Excel Worksheet Functions | |||
Help in a fomula | Excel Discussion (Misc queries) | |||
Fomula (if?) | Excel Worksheet Functions | |||
Fomula | Excel Discussion (Misc queries) | |||
Please help, i need a fomula | Excel Worksheet Functions |