![]() |
LOOPs problem
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 |
All times are GMT +1. The time now is 12:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com