Thread: VBA if loop
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tony from Work Tony from Work is offline
external usenet poster
 
Posts: 4
Default 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