New to excel, having trouble changing values based on an input cell

The most obvious answer I see (in kind of pseudo code):

Table 1
Cell A =2*$Table2$CellA
Cell B =3*$Table2$CellA

Now put in Table 2 whatever fraction you want Table 1 multiplied by (1.0 if you want the original 2 and 3 to display).

Does that do the job, or is there more to the problem?

If this were my spreadsheet, with no constraints on layout, I would lay it out like this:

A1 would be the text label "multiplier=". B1 would be where I would enter the multiplier (start with 1.0 initially).
A2 would be text label "original value". A3 through Axx would be the original values (2 and 3 in your sample case).
B2 would be text label "result". In B3 enter the formula =A3*$B$2 (equivalent to =PRODUCT(A3,$B$2). The "$" mean a fixed reference when copied. Now copy B3 down column B as far as needed.

You'll have to adapt your cell references as needed, because I don't know exactly how you're laid out.

Ah, yeah I suppose that would work (would fix that circular ref error). Problem is I am somewhat limited in the layout.

Try to imagine this setup:

A spreadsheet with...
12 columns
20 rows

Each cell in that 12x20 table has a value. The numbers range anywhere from 5 to 300.

Now I have a seperate 1x2 table for the multipler. I'm trying to get it so when I modify the multipler it changes the values in each cell of the 12x20 table. If I change it from 1.0 to 0.8 it would decrease each value in that 12x20 table by 20%.

Then if I changed it to 0.5 it would change the -original- value of that cell by 50% (not 50% of the 20% reduced value). Then if I put in 1.0, it would return it to their default unmodified values, etc..

There's 6 of those 12x20 tables, which would all be controlled by that single multipler. That's why I also wanted to know of a method where I could just apply 1 single formula to an infinite amount of cells (maybe some form of drag/drop formula menu I missed?).

" I am somewhat limited in the layout." Meaning you have to use a rectangular layout like you describe rather than a straight column, or are there even more stringent requirements?

If the difficulty is just working with the rectangular area rather than a straight column, I would still do the same kind of approach:

A1, B1, and A2 would be the same as above.
A3:L23 would hold the original values
A32: "results"
A33 =a3*$B$1 copied through L53.

If you don't like having both tables together like that, it would be easy enough to move the table containing the original values to some out of the way place in the spreadsheet (maybe even hide it if you want, so it isn't visible).

The problem was the size of the sheet in general. If I had (6) 12x20 tables, then cloned them (to show the results) it wouldn't all fit.

That is why I wanted to show the multiplied numbers in the same table as the original values (it wasn't necessary to view both at once -- the only requirement was that I could return back to the original values when setting the multipler to 1).

I ended up just seperating them and all is well.

Wasn't bad but the end result looks sloppy (wasted space for no reason).