This is very tedious so I would like a macro to do the following.
I have the following data and I need it to be inserted in its related worksheet in a particular cell.
Column A, Column B
030, 2500
031, 3600
032, 4500
040, 1500
045, 8900
etc., etc
Column A is the name of the worksheet where I want the data in Column B inserted.
example. 030, 2500 I would go to worksheet 030 and in cell F12 enter 2500.
I know there is a way to automate this, but I don't know how, can someone help me.
Thanks
I have the following data and I need it to be inserted in its related worksheet in a particular cell.
Column A, Column B
030, 2500
031, 3600
032, 4500
040, 1500
045, 8900
etc., etc
Column A is the name of the worksheet where I want the data in Column B inserted.
example. 030, 2500 I would go to worksheet 030 and in cell F12 enter 2500.
I know there is a way to automate this, but I don't know how, can someone help me.
Thanks