Saladsamurai
09-01-2009, 10:46 AM
:hi: 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!
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!