Macro to move any selected cell to a specific column on the same row

Hi,
I'm sure this is easy but I can't seem to find the answer. I'd like a macro that will take the data in any cell I have selected and move it to a specific column in the same row it was selected on.
Thank you for your time!
Jonah

So select A1 and have it go to G1
or I can select B2 and have it go to G2
or I can select C3 and have it go to G3
or I can select D4 and have it go to G4

Any cell I select and run the macro on the data always goes to column G on the same row

Thanks Winon,
you're right, that will make things easier if Jonah wants to move the value each time the cell changes.

Thank you NickyC and Winon!

NickyC: The code you wrote copies the data to the column. Is there an easy to change that so that it moves the data?

Winon: When I paste the code you wrote into the Visual Basic module in Excel the macro doesn't show up in the run macros window. If I modify the first line to be Sub Worksheet_Change() it will show up but when I run it Excel says there is an error in the line If Target.Rows.Count > 1 Then Exit Sub. I am very new to macros and don't have a good understanding of what each line of code means or the different ways to go about running macros. I'm sure this is an error on my side. Your further input would be greatly appreciated. Just in case it matters, I'm running Excel 2010 in Windows 7

One other question, within this same macro is it easy to add the ability to move the data up or down a row in the final column? So, always same column but the next row up.

Finally, thank you for helping me on this. Each time I use a macro and see what it does I am learning how they work and the commands that are used to do different operations. Probably not the most efficient way to learn but it seems to be working for simple operations.

Thanks again.

Hi Winon,
At times yes. I know how to make a macro that will move data from the cell it is in to another cell relative to the original so when I asked the original question I figured I could just run the macro you originally helped me with and then run another macro if I needed to move the data up or down within the column. But if one macro could do both that would be even better.
Again, thank you for your time and information.
Jonah

Hi Winon,
The file you attached shows what I'd like to be able to do.
In your example file the original data is copied to column G but I'd like it to be cut and pasted to column G.
By "fire" a macro do you mean run it? How would I run this macro if I don't see it in the run macro window?
Sorry for the dumb questions...

Okay, this is the function I would like to preform but I only want it to happen on a cell I select and run the macro on. I will be using this to make the task of moving addresses much more efficient. I attached an example of how it will be used. The example shows how the data is imported, somewhat random as to which row the address, city and state end up on (terrible way to import but I don't have control over the importing format). Once I have it in Excel I move the address over to the columns named "Address Line 1", "Address Line 2"...
So I would like to be able to select a cell and use a keyboard shortcut to run the macro so it's contents move to the appropriate column. For example, B2 would move to E2 and B3 would go to F3.
NickyC's code worked great, but it copies the data. Like I mentioned, I need it to cut and paste.
Thank you for sticking with me on this, I deeply appreciate it.

Hi Jonah
if you want to delete the contents of the active cell as well as copy the contents to column G, try this:

Please Login or Register  to view this content.

NickyC, this works perfect. Thank you!
Winon, thank you for the time you took yesterday to work with me on this.

Again, thank you both for your time and information. I really appreciate it!