Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I need either a "Do...While" or a "For...Next" loop that will take Thre numbers in Sheet1 and enter them into Cells on Sheet2.(Sheet2 is a calculator program) The answer will appear on the bottom of Sheet2 once the inputs ar entered, but having them show up on Sheet1 would be great. Here is a rookie example: Sheet2!B3 = Sheet1!A1 Sheet2!B7 = Sheet1!A2 Sheet2!B8 = Sheet1!A3 Then have the answer show up on Sheet1: Sheet1!A4 = Sheet2!D28 As I typed this it seemed like an "If...Then" statement may be neede inside the LOOP. This calculation may have to be done for about a hundred Rows o numbers. Any help would be appreciate -- Emmett42 ----------------------------------------------------------------------- Emmett423's Profile: http://www.excelforum.com/member.php...fo&userid=3295 View this thread: http://www.excelforum.com/showthread.php?threadid=53161 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Loops & Ifs | Excel Programming | |||
Do loops | Excel Discussion (Misc queries) | |||
Excel 2k VBA problem - For loops interating a sort | Excel Programming | |||
Loops etc. | Excel Programming | |||
LOOPS | Excel Programming |