Need 2nd sheet to set values for 1st sheet (as text), without touching sheet 1!

[aninja]

Hey guys,

So this is what's going on.. It doesn't matter if it's a Macro (preferred) or a simple formula in the cells of the second sheet; I just need it to work .
I Need the 2nd sheet to set values for the 1st sheet as text, without touching sheet 1.

So if I were to write "Fun" in cell C2 of Sheet2, I need it to appear in the same cell on Sheet1.

This has to be done with well over 100 cells. I tried to make a fancy for loop but capital letters are driving me crazy .

Thanks again guys, would be much appreciated !

PS: I don't think this needs an attachment, let me know if anything.

[davesexcel]

Right click on Sheet2 tab and select View Code
Paste this Code there.

Please Login or Register  to view this content.

[aninja]

That works ! thanks for answering.

My last problem id don't really need, but what if:

Both sheets have A-1 to A-125 numbered in order.
If I were to jumble Sheet2, could I still have it refer to its proper cell?Now it's cell for cell.

As I said it's not a problem if not, thanks again Dave

[aninja]

Think anyone could get this to work ?

It's all about my managers keeping me from touching their stuff, which is clearly in the wrong order and very unpractical. I want a sheet i can pop in, complete in my own order, and let the macro/code reorder it and position it in it's proper cell relative to it's A.'x'

Thanks guys