I would like to link a range of cells from worksheet "B" to worksheet "A". The range of the cells is X45:AC47, (3 down and 6 across) total of 18 cells.
What I would like to see happen is, when I type the worksheet name "B" anywhere between cell O6 thru O24 of worksheet "A", the cell range from worksheet "B" will be linked onto worksheet "A".
examples:
I type "B" on cell O7 of worksheet "A", the cell range X45:AC47 from worksheet "B" is pasted and linked to worksheet "A", cell range P7:U9.
I type "B" on cell O6 of worksheet "A", the cell range X45:AC47 from worksheet "B" is pasted and linked to worksheet "A", cell range P6:U8.
Make sense??
What I would like to see happen is, when I type the worksheet name "B" anywhere between cell O6 thru O24 of worksheet "A", the cell range from worksheet "B" will be linked onto worksheet "A".
examples:
I type "B" on cell O7 of worksheet "A", the cell range X45:AC47 from worksheet "B" is pasted and linked to worksheet "A", cell range P7:U9.
I type "B" on cell O6 of worksheet "A", the cell range X45:AC47 from worksheet "B" is pasted and linked to worksheet "A", cell range P6:U8.
Make sense??
