Cell reference copy in another cell without link and formula

[r_know]

Dear All,

I have attach the file and looking for the Cell copy in another cell without any link and formula.

Please advise.

[fredlo2010]

Hi,

The file seems to be corrupt

[r_know]

Ok I am attaching again!

[fredlo2010]

Still cannot open it :(.

This will let you copy only the values from "A1" to "A2"

Cells(1,2).value=Cells(1,1).value

[r_know]

Attached Again.

Can you pls give full VBA code & I think code should work Automatically.

[fredlo2010]

Here it the codeSub CopyValues()

Range("F6:F2200").Value = Range("BA6:BA2200").Value

End Sub


What do you mean by automatically?

[r_know]

Hi Fredlo,
I think my mean by Private Sub way, automatic value copy when Worksheet Open or enter value. I did below,


Private Sub Worksheet_Change(ByVal Target As Range)
Range("F6:F2200").Value = Range("BA6:BA2200").Value
End Sub

This work great but when I apply this in my Original Workbook then I thought that in same concept I have required the followings.

Actually in Cell F6:F2200 fill up Value (Text) in original workbook, I also having another two method , one is Userform (Select Value (text) & appear in F columns Cells) & second Manually enter (typing) the same which available in OUTPUT Sheet.

That reason I required "F" & "G" column cell work on conditions,
1. "F" columns Cells should be empty and I can type manually the value (Text), even by second method means Userform ways also I can enter the value (Text) if no number given in corresponding "G" Cell and value (text) not appear in BA6:BA2200 cell.
2. Second conditions is reverse ways, If I enter manually Value (text) or userformways in F6:F2200 then automatically corresponding number should arrived in G6:G2200 Cell for Value (text) by referring the OUTPUT sheet. Otherwise, G column cells should empty to enter manually the numbers.
Little complicated requirement but in my working workbook I prefer to earliest method to select the value (text) and appears in "F" column.

I hope you understand my requirement; and hoping that you will give your time to solve this thread and suggest the code.

Thanks once again!
Regards,
RL>

[r_know]

Please Any One Suggest The Code?