Hello there.


I have attached a small sample wrkbk.

Originally Sheet ! and Sheet 2 each conatined rows of the exact same length. This is because each Sheet is used to keep track of a particular property of a data center item.

On sheet 1 we have the power and on sheet 2 we have its performance.

I have manually gone into Sheet 1 and placed the "$" symbol in certain locations to make future coding easier.

Now I would like to make Sheet 2 follow suit. That is, I need a to write a code that will look at Sheet 1 and insert a "$" symbol onto Sheet 2 wherever necessary and then "shift" the data on sheet 2 accordingly.

Sheet 3 shows the desired effect done by hand.

Thanks!