Can anyone help me with this? (Loop problem)

Kaoss7

New Member
Joined
Sep 12, 2010
Messages
7


Hi

Please could someone help me? I`ve the situation demonstrated on Fig1,


image host


..and need to get a result like the Fig2:


wordpress image upload

Thanks for your help
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
There is no automatic way of changing cell entries. Or do you want to generate a copy of the sheet in another sheet by formulas to do this? Formatting can be done via Conditional Formatting.
 

Kaoss7

New Member
Joined
Sep 12, 2010
Messages
7
Hi, thank you for you reply.
In fact, I would like to run a VBA script to "see" the range A1:W35, up to down, left to right, and for each "0,130,530,0" sequence find, change the letter "B" above to "99" and for each "480,0,180,0" sequence find, change the letter "A" above to "99". I can`t figure out how to achieve this by conditional formatting. A VBA macro is more suitable, right?
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
To actually change cell contents, yes, a VBA macro is needed. Have you done any VBA ... have you done any research into how to write some VBA to do this?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,165
Messages
5,527,172
Members
409,750
Latest member
BorisYeltsin

This Week's Hot Topics

Top