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
|