| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA if loop
Hi!
I'm working as accountant and I need a little help with a macro that could relief me from several hours of scanning and replace Basically I got to work with several sheets in excel 2000 where in each row I have to change a value of a cell in another one (the value that is in that cell divided by 2) if the another cell in that row is equal to a certain value in another worksheet. Explained: Sheet1 62 colums Row 1 if the value in the column 51 is equal to value in Sheet2!A1 then replace the number in column 44 with that number divided by 2. Go to the next row till end. Many thanks for your time and your help! Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Naming Worksheets - Loop within a loop issue | Excel Programming | |||
| Naming Worksheets - Loop within a loop issue | Excel Programming | |||
| (Complex) Loop within loop to create worksheets | Excel Programming | |||
| Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
| Problem adding charts using Do-Loop Until loop | Excel Programming | |||
Threaded Mode
