Please help....it's driving me crazy!
I have 3 worksheets: Input, Sheet1 and Sheet2.
On the input sheet I have in cell A1, a sheetname. In cell A2, a ROW number. In cell A3, a COLUMN number. I.E. A1=Sheet2, A2=49, A3=C. Also on the input worksheet I have a range of numbers (for example in a5-a10).
How can I write a macro, which I can assign to a button which will copy the data from the input sheet, move to the correct sheet, and then paste in the data.
Any help any of you experts can give me would be GRATEFULLY received. Thanks
I have 3 worksheets: Input, Sheet1 and Sheet2.
On the input sheet I have in cell A1, a sheetname. In cell A2, a ROW number. In cell A3, a COLUMN number. I.E. A1=Sheet2, A2=49, A3=C. Also on the input worksheet I have a range of numbers (for example in a5-a10).
How can I write a macro, which I can assign to a button which will copy the data from the input sheet, move to the correct sheet, and then paste in the data.
Any help any of you experts can give me would be GRATEFULLY received. Thanks