Selecting a cell based on the contents of another

[ianto2842]

So I have a big table and a column of data values to input into it on two separate tabs, but the data can go into different rows or columns based on various conditions. I have therefore got a helper column, producing the cell reference that the values need to be copied into. So for example below

So in this example I need the VBA to work out that 56 needs to be copied as a value into cell H5, 8 needs to go into cell AB2, etc. The values in columns A and B will change, but whatever is in B1 will need to be copied to whatever cell reference is in A1, and so on.

I'm imagining a lot of defining variables (which will take a while but is fine) but I'm not sure how to make it recognise the value in A1 as a cell reference, not a value. I'm fine with copying and pasting etc afterwards, its just that part I'm struggling with.

Any help would be greatly appreciated! Thanks!

 

[ianto2842]

So I have a big table and a column of data values to input into it on two separate tabs, but the data can go into different rows or columns based on various conditions. I have therefore got a helper column, producing the cell reference that the values need to be copied into. So for example below

So in this example I need the VBA to work out that 56 needs to be copied as a value into cell H5, 8 needs to go into cell AB2, etc. The values in columns A and B will change, but whatever is in B1 will need to be copied to whatever cell reference is in A1, and so on.

View attachment 78949

I'm imagining a lot of defining variables (which will take a while but is fine) but I'm not sure how to make it recognise the value in A1 as a cell reference, not a value. I'm fine with copying and pasting etc afterwards, its just that part I'm struggling with.

Any help would be greatly appreciated! Thanks!

So I have a big table and a column of data values to input into it on two separate tabs, but the data can go into different rows or columns based on various conditions. I have therefore got a helper column, producing the cell reference that the values need to be copied into. So for example below

So in this example I need the VBA to work out that 56 needs to be copied as a value into cell H5, 8 needs to go into cell AB2, etc. The values in columns A and B will change, but whatever is in B1 will need to be copied to whatever cell reference is in A1, and so on.

View attachment 78949

I'm imagining a lot of defining variables (which will take a while but is fine) but I'm not sure how to make it recognise the value in A1 as a cell reference, not a value. I'm fine with copying and pasting etc afterwards, its just that part I'm struggling with.

Any help would be greatly appreciated! Thanks!

Ignore this - solved it!

 

[smozgur]

Good to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.