Good morning everyone.. At least those of you where it is morning.. If you don't want to read the boring quick bio about me, skip the next paragraph.

I figure since this is my first post, I'll do a quick intro. My name is Ryan. 28 from Michigan. Been very into computers since I was about 8. First computer ran DOS and had Windows 3.1 on it. I had to learn how to use just by playing around with it because I had no books, no internet, nothing. Needless to say, I liked it and have been messing with computers ever since. Recently, I took a job working for a Ford Motor Company contractor and they have no IT, so they nominated me to design their forms and worksheets for them. Never really bothered much with Excel until about a month or two ago.

I'm hoping what I'm looking to do is very simple. I want to have two sheets. We will call them sheet 1 and sheet 2 for lack of imagination.

What I'm looking for is, and I really believe a Macro/Script is the only way to do this, is say cell A1 on sheet 1 has a value of L. I want to copy data from say cell B17 on sheet 1 and paste it to the column letter that is equal to the value in A1 on sheet 1 onto said column in sheet 2. If the L changes to say V and the macro/script is ran, the data will then copy to column V on sheet 2. And obviously I would like to be able to do the same for row numbers. So essentially, set A1 on sheet 1 to the column letter, set B1 to the row number also on sheet 1, then switch to the location on sheet 2 and paste the data. The select data/copy/paste part is easy. I'm just hoping it's possible to set coordinates on another sheet based off the values of a sheet.

Any help is greatly appreciated!