VBA Data Entry

[Johndinho]

Hi,

I'm trying to code some data migration between 2 spreadsheets.
My stumbling block is knowing how to tell the code where to paste the data.

The destination workbook has a list of unique IDs in columnQ but the data needs to be pasted into the relevant ColumnD.

I can get the cell reference I need into a separate cell - A1 for instance so my copied data I then need to paste to the cell reference shown in A1 - Q50 for instance

Any ideas how I do this?

Thanks

 

[manc]

Hi Johndinho,

I don't know VBA, but why not record a macro of you doing what you need to do manually, and then jump into the code to see if you can take anything from it.
I just tried an example and it works for the macro side of things.
Just a thought.

Sub Macro1()'
' Macro1 Macro
'


'
    Range("A1:Q10").Select
    Selection.Copy
    Sheets("Sheet2").Select
    Range("D1").Select
    ActiveSheet.Paste
End Sub

Best regards
manc

 

[Johndinho]

Thanks Manc but I want to use the value of A1 to tell the VBA where to paste

My code would look like

Range("A1").Value = 10
Range("B1").copy
Range("Q" & cells(1, 1)).Paste Special xlValues

My aim is to paste the value of B1 into Q10 based on A1 containing 10

 

[Joe4]

No need for Copy/Paste.
You can just do it like this:

Range("A1").Value = 10
Range("Q" & Cells(1, 1).Value) = Range("B1")

 

[Johndinho]

Got it..

Range("A1").Value = Q10
Range(Cells (1, 1)).Select