I am not a programmer but need to automate clean up of data that I have to
work with daily. I was hoping someone could please help me out.

I need to do the following:

For entire worksheet. Could be data in A1:J500 or data could be in rows
A1:AV6000.


If Column A = Then Do This:

1 Do Nothing
2 Indent Column B 5 Spaces
3 Indent Column B 10 Spaces
4 Indent Column B 15 Spaces
5 Indent Column B 20 Spaces
6 Indent Column B 25 Spaces
7 Indent Column B 30 Spaces
8 Indent Column B 35 Spaces



Also for entire worksheet. Could be data in A1:J500 or data could be in
rows A1:AV6000.

If Column B = Yes Then Bold and shade in gray this row from column A to end
of data on row. Could be column J or Column AV.

Many thanks and much appreciation in advance for your assistance.